Discussion Forums

Hello all,Where can I find or how can I calculate the cash at the beginning of the period?Thanks.

I have a client using Pacejet that handles their shipping. They are running into an error with  Pacejet because the DHL API is pushing a foreign currency into their system. DHL does not have a currency converter on their end so they are telling our client to set up the Currency Type in Acumatica.  Our client is not currently using Multicurrency Accounting.  I am wondering if anyone has had to set this up for their clients for Pacejet only and if so what it entailed and if they ran into any issues with it. 

Hello, we are trying to accomplish the following in our system:Track material and product scrap/cycle count adjustment by part number, lot, scrap code/reason, cycle count reason. Track defects (production scrap) in sortable fields and down to material or defect code. Entering scrap (and reporting) allows to report by component, sub-assembly or finished product level. Track scrap per stock itemThere are a few methods that we know of, but each has it’s drawbacks from our perspective, summarized below. Does anyone have suggestions for the best approach to overcome the issues noted? There may be some gaps in the procedures outlined as we are new to the system. Method 1: Scrapping Against the Production OrderThese are the general steps as we understand them, please confirm or correct as needed:Scrap action in the BOM must be set to “Write-Off” or “Quarantine” In the Move transaction within the production order (such as op 010 to 020 in our case), you can enter quantity scrapped, reason, and

Hi,I have a custom screen , I need to get the total amount of the header level based on the sum of line amount of the grid level. as per above screenshot, I have taken the multiplication of A and B to the C column. Likewise I have to get the value in C column for each row which were added in the grid, Then I need to pass the sum of C column to the D field in the header level. for that I have added below code snippet in rowinserting event handler but it’s not working, only the C value is calculated. decimal? amount = this.APProformaItems.Select().FirstTableItems.ToList().Select(x => x.Amount * x.ProFormaQty).Sum();// Acuminator disable once PX1048 RowChangesInEventHandlersAllowedForArgsOnly [Justification]item.DetailTotal = amount; decimal? LineAmount = row.ProFormaQty * row.Amount; row.TotalAmount = LineAmount;ApproformaItems = view for the grid Can someone suggest a way to achieve this?Thank you.

In a perfect world where dreams come true, I envision my trial balance screen having arrows at the top where I could just click to advance or go back one period at a time. Does anyone know if something like this is possible? 

Is there an option to run the trial balance summary report for the entire year rather than one period? 

Hi team,When receiving drop ship items, I cannot add serial#’s.We need to be able to track the serial#’s also for drop ship orders.Thank you!Monika 

I am trying to understand the Entities sync settings better. We have Stock, Nonstock, and Template finished products with Export Mapping Active fields established. I noticed on older products mapped to the Website, the Export Map settings are not installed on the products in the BigCommerce. Is this due to the fact it only reads this mapping once when the External ID is assigned and the first sync occurs?  I went to the SKU in question in Sync History to manually sync it to see if the fields fill in on BigCommerce, and they did not.  I noticed this because some products have the fields filled in on BigCommerce, and others don’t. Yet, the Acumatica file has not been updated. I am guessing that the active export mapping settings were not active during the first sync. Any ideas?  

I would like to display the Day of the week in a GI,  Either display, Sunday, Monday, Tuesday, etc… or display, 1, 2, 3,   Where 1 is equal the first day of the week etc… So for Document Date,  I would like to see  Document Date   Document Day10/6/2023          Monday  

Hi, I’m trying to better format a Dashboard Table to show whole dollar rounding for some of our GI’s. I’ve been scouring different DACs and Community posts trying to find a ‘whole dollar’ schema that would provide a right aligned number with comma separators and no decimals. (#,##0).I’m able to use these parameters for Report Design and Pivot Views, but cannot find a schema to use with this format. I’m hoping I’m just way overlooking the solution to this and maybe someone could help me out. I’d really like to avoid creating a Customization to achieve the formatting.

I would like to create a report that includes Inventory ID, Description, Lot Number, Warehouse, Location and Ending Balance ONLY. The system seems to be only pulling transactions which ends up looking like duplicates on the report itself OR the lot number is completely empty. Is this a limitation?I found this previously posted:  

My team is wanting to add their Email Signatures to mass emails, but I am stuck on how to add them. So far I have enabled and created an email signature in the user profile, and I’ve also created a notification template the is just “((GeneralInfo.MailSignature))” to go at the bottom of the mass email body, but I am having no luck with it actually showing up. I’m wondering if it has to do with our mass emails only have the “Contact” datafield to pull from?Test Signature in User ProfileEmail Template in Mass Email and it’s preview screen.  Datafield Available in Mass Emails 

Hi All,We have added date filters and Location Filters to the Inventory Valuation report. Could you please assist us in resolving the data filtering issue specified below.If the date filters and the warehouse, Location filters all are selected, data is filtering properly and prompting expected results in the report. Whereas when only Data filters are selected, without Warehouse/Location, it is prompting incorrect results. (not filtered)We have attached the screenshots for the Relationships and filters tab in reports.Please review the report considering the issue and share your thoughts.Thanks,Swathi A.

Has anyone tried ACUMATICA integration with Rippling HRIS for Asia region? Much appreciated for your information and sharing on how it worked also what are the challenges during implementation, Thank you

The "From Date" and "To Date" fields have been added to the "Process" screen, automatically populating the date range from the current date minus three days. This is working as expected.When we select a specific date range, it resets to the default dates and retrieves data only within the default date range. Below is the screen shots for DAC and Events.   Could any one please suggest a solution

In the customer portal checkout page, I have made some of the fields mandatory. However, if I don’t fill them in, I get the below error message, instead of being prevented from submitting the order. And after the error, the sales order gets deleted. Is there a way around this to prevent the user from submitting the form without the cells being filled in.  

Hi Everyone,Has anyone worked with MT940 files to import data into the Import Bank Transactions screen in Acumatica?If so, I would really appreciate it if you could share your approach or any insights on how you handled the import process.Thanks in advance for your support!

Hi all,My team has asked for a mod that makes sense… with tasks that have opted to have a reminder, the reminder date defaults to today’s date (@today)… which doesn’t make sense for us. We would like to have the reminder date default to the set end date. Is there an easy way to customize this or low code it? Maybe with modified attribute?  

 Why is System.Net.Http.dll missing in 24 R1 when many variations are included?@Dmitrii Naumov 

Hi AllWe have a custom report in our instance (24R1) called ‘Quantity Sold Report’ it basically gives us how many items were sold, how many we have on hand and how many we have on order (see screenshots attached).The users wanted a bit more granularity to the report and asked if it was possible to include the brand of the products as well, since brand was an inventory attribute being used, I was able to add it as a parameter and it worked (see screenshots attached).We have another attribute that they would like to use as a parameter, that being the ‘Critical’ attribute to mark if the item is a critical item or not. I added the parameter to the report same as the brand attribute (see screenshot attached) but the items do not show how we wanted it to. If the critical item checkbox is ticked, then only the items marked as critical show up which is correct, however if the box is unticked only the items that are not marked at critical show up. I’m not sure if that is how the behavior is sup

Currently, we have a cash flow statement that works for the current year. The client wanted to add a column for the previous year which is easy enough to create the second column within the Column Set with and offset of -1. However, in row set they have created, there are two lines that also has an offset value to -1 as they need balances from previous year for the current year Cash Flow statement. When I created the Column set with an offset of -1, it will get the data from last year, however, the two lines within the row set still retrieves last year but I need it to pull 2 years back. Is there a way to do this in ARM?  Basically, if the offset within the Column Set is set to -1, I would need for the offset value within the row set to be -2.  Any help is greatly appreciated. Joey

When you create a PO, the Promised On date in the header transfers to any PO Lines that are added.However, if you update the Promised On date in the header, the Promised date in the PO Lines alters to the Promised On date PLUS the Item Lead Time in the Vendors tab in the Stock Item (in the example below, 7 days).Is this a setting we need to change, or a bug (as obviously the Promised On date is the date the Vendor is delivering their goods to us. It does not need a lead time adding to it)?Thanks,

Hi All,I need to create a GI based on the below info. I don't know how. Does anyone perhaps have a similar GI that I can use or give me documentation on how to do this. I am still new to Acumatica ThxDries

We are an MSP and one of our clients has a technician onsite that works cases from the customer portal. We need them to be able to edit the reason listed in the case to some of the custom options we have created. I was able to add these to the combo box values in the field section of the customization but they do not appear in the drop down only the combo values that exist in the base version of portal. If we change the reason in the main tenant it does change on the customer portal side but gives an exclamation stating that it is not set for this workflow. Unfortunately there is no workflow option with the customizations for the customer portal. Now they are set to be available in the workflow as it is set in the main tenant. Reason had its name changed to status 

I was wondering if there was a way to prevent a shipment from being created on a Sales Order that has no Ship Via and/or Shipping Terms selected? Unfortunately we have a problem with sales reps not doing due diligence to check the Shipping tab prior to creating a shipment and it creates confusion and time wastes in the warehouse when a pick ticket prints with no shipping information on it.