Discussion Forums

Hey folks - do we know if there is a way to create a mapping, without customization to default the Ship Via - or are we forever bound by the Shipping mapping on the Store Settings?i.e. when a new shipment method is created in shopify and we want to import an order the system errors out because the mapping to the ship via is not provided on the Store Settings. How can we default one ship via value?

I’ve been looking around and see that it should be possible to use the Create Purchase Order screen to create 1 PO from multiple Sales Orders lines.  But when I click the POs I want to combine, it creates multiple POs.  Is there a flag or setting somewhere that I may be missing.  The POs are for the same item and same vendor

I’m seeing the error message: [2025-11-19 12:17:33.647] Cannot delete C:\[tenant]\App_Data\TSScreenInfo\Company folder, lock.json is present, pid=21156, ppid=17096 I presume this relates to a fatal build error in the previous publish attempt, which aborted with an HTML Merge error. It seems like the lock.json is not deleted when the publish exits abnormally.I have to manually delete that file before I can Publish.The issue might go away if the HTML Merge error gets fixed in a new version, but it strikes me that the Publish ought to remove the lock file.This is with 25.200.0248.

Hello,We are looking into using USPS First Class Large Envelopes “Flats” (not a flat rate shipping method, but literally a flat envelope) to ship a majority of our products. We sell small, thin envelopes of seeds. We will save about $100k a year in shipping costs by switching from Ground Advantage to USPS First Class Large Envelopes.Is anyone using this service method in Acumatica?I do not see this as an option when setting up a Ship Via. We have an integration with stamps.com and it does exist as a service method on our account:I wonder if we have to do something similar to when we set up Med/Large Flat Rate ship vias? We had to do some heavy lifting to get those working:First by creating new Carrier IDs for each of those:

So, I just build this GI. I want to show year to date for this year and last year.The formula for this year is working. The formula I have for this year is not working. Can I please get help if anyone has done this.This is my result now. 

Environment - Acumatica version: Acumatica 2025 R2,Build 25.200.0248- SQL Server: Microsoft SQL Server 2022 Express  - Module: Automation Schedules / Scheduling Error messageCannot insert the value NULL into column 'IsRelative', table 'DatabaseName.dbo.AUScheduleFill'; column does not allow nulls. INSERT fails. When it occursOccurs when saving or running an automation schedule that includes entries in the Filter Values tab after recent changes (upgrade, customization deployment, or schema update). The error appears at the moment the system attempts to insert rows into ‘

I was wondering if anyone has a work around for reconciling Balance Sheet accounts?  Our accountant likes us to reconcile all of our Balance Sheet accounts.  When we were using QuickBooks, this wasn’t an issue.  However, using Acumatica, this doesn’t seem possible.  Any suggestions? 

Good Day how can one get the current detailed TB report to display budget columns next to each TB line? 

Hi Community, Is there a way to have an API Role for a designated API User that is basically an API Admin and not a UI Admin? -RJ

Hi, I’m trying to consolidate group of companies for financial reporting. I’m using ARM reports to consolidate different companies and there are minority adjustments to be made to remove the non-controlling interest of few companies. Is there any way that can be configured in Acumatica?Thank you,Dulanjana

We are trying to clean up old vendors from our list vendor but do not have a way to identify the VENDOR status without having to drill down and open each one which is rather inefficient and not as useful as “VENDOR” status.  This may be to do a user before my time messing with the generic inquiry schema or is that how everyone’s vendor report appears. We do have MASS EDIT option SELECTED and can INACITIVE the VENDOR(s) accounts all at the same time once we have the VENDOR STATUS column available in the GENERIC INQUIRY.Does anyone know our VENDOR GENERIC INQUIRY would have a column for CUSTOMER STATUS rather than VENDOR STATUS?  The Vendor status also does not appear in the list of fields that can be selected to be visible in the report edit options.  . 

Hello Has anyone seen this error? I added Mass Actions to a GI for Production Order Ticket, but when I try to mass edit them or even one, I get this error. I was looking to complete or cancel multiples at once.  

Customer have Company wise Financial Calendar . I am running my 12 months BS based on Master Calendar”  What variable I can use to display the Respective company wise Periods (Eg :11-2025 ,12-2025) .   

We’re experiencing some odd behavior with the main search field. No results are returned when using a combination of three or more numerals and “AS”.Specifically, we have a stock items called “MAS513” with different suffixes, like AO, A12, and AS. Using the search bar at the top gives results for searches of “MAS513”, “MAS513-AO”, and “MAS513-A12”, but not for “MAS513-AS”. “MAS AS” and “13-AS” give results and can find the item, but “513-AS” does not. It works without issue in grids’ quick search field. It seems like ‘as’ is a keyword but only in certain circumstances? Does anyone know why this would be happening?Thank you for any insight you can provide,

Hello! I am reviewing the Import Scenario “ACU Import AP Bills”. When we manually print a check in Acumatica, it automatically finds the next “payment ref.” # in the sequence for the cash account/payment type and adds that into the  Payment Ref. cell. I was wondering if (for our AP Bill Import Scenario), instead of manually inputting the “Payment Ref.”, is there a way to have Acumatica autogenerate it based on the existing sequence? 

Good afternoon,Is there a way to set up a line item (i.e. - our company catalog) to go in at $0 value and bypass CREDIT HOLD so it doesn't get tied up?We want it to count against inventory for the product, but just no monetary value.Thank you!

As shown in the screenshot below, we understand that when a Move transaction is performed, the system should create both: The Move Transaction, and The corresponding Cost Transaction. This is not the actual screenshot; it was taken from the local system. In our case, we can only see the yellow-highlighted Move transaction line. The Cost Transaction shown above does not appear in the Production Order. We have identified an issue where, after completing a Move transaction, the Cost Transaction is not being created for that specific Move.As a result, the system generates a

I have only project ID and TaskCD. How to import task by TaskCD?

Is it possible to download multiple selected files as a ZIP file?Able to download one file at a time, but I need to download multiple files together as a ZIP file 

I have a sales order that i have processed through into shipping and invoiced. the shipping and invoiced status both show completed/closed  but going back to the sales order it shows as ‘Open’ and not ‘completed’. I have put the order on hold and clicked off the check box under the completed column and have also clicked on ‘complete order’ under processing and still will not change the status of the sales order to ‘complete’.How can this be resolved in order to show status ‘completed’. Please help. 

HelloWe’re having an issue with Canadian payroll and I’d like to know if anyone else has seen this, or if there is something we’re missing.We have a test employee who has maxed out on EI and CPP (tax reports confirm this), and when I process a subsequent regular pay run and compare the Federal Withholding Tax (FWT) and the Provincial Withholding Tax (PWT) to the Payroll Deductions Online Calculator, the amounts don’t line up. In Acumatica PWT is lower while FWT is higher. If I run the Online Calculator again and do not select the option for max EI and CPP having been reached, then the PWT matches what Acumatica calculates, but FWT is still out. In all standard pay runs I can get an exact match. We’re only seeing this now with maximums having been reached. I’ve gone through all setup and can’t see anything that seems like it would impact this.Appreciate any feedback anyone has on this! 

Hello everybody,I have the following scenario:A set consists of two components: a certificate, a 20-item box, which can contain one or more lot/serial numbers. In the delivery note, the information should be displayed as follows: Line for the certificate Line for the item (20-item box) Below the item line, a list of all associated lot/serial numbers should appear – regardless of whether there is one or multiple lots. The lot/serial numbers come from the field:[SOShipLineSplit.LotSerialNbr]Problem:When I use a separate detail section for the lot/serial numbers in the report, Acumatica repeats the item line for each lot/serial number. This causes duplicate or multiple item lines, which

Hi all, I have my reverse and apply API working per this threadReverseInvoiceAndApplyToMemo via API | Community Issue is that when you try to Reverse an Invoice it defaults to the Fin Period it was created. Since that Period is closed it needs to be changed to the current Period.  I have tried adding "PostPeriod":{            "value": "122025"        }  or "FinPeriodID":{            "value": "122025"        }  to the payload but still Errors out    "PostPeriod": {        "value": "072025",        "error": "Error: The 07-2025 financial period is closed in the ABC company."    } Is this possible with the API?  How do I find the right field to pass? I can

If the client purchased an incorrect item from a Vendor, and the item is returned with a restocking fee (no replacement will be sent by the Vendor), how do you process that?There are 2 separate scenarios:The original Bill is still Open. The original Bill is Closed.

Hello, We are running into an issue with Lot Size. From our supplier, we need to order item A in multiples of 144 (closed cases), so we use Lot Size 144 under the Vendor tab of the Stock Item. We have three stores that Replenish from our main warehouse. For Item A, each store (a different warehouse) has a Reorder Point of (say) 3 and a Max Quantity of 6. When we run a Prepare Replenishment and a Create Transfer Order the replenish quantity defaults to the Lot Size of 144.We cannot have a full case (Lot Size) on our shelves. How can we tell Acumatica that Lot Size is only for Purchase order to our supplier, and that Transfer Orders to our stores do not need to be in full LotSize? Regards