Discussion Forums

Hello all,How can we record loan (liability) against a project in acumatica? So the project will first start with construction which will be funded from loan - as a liability and not income. Then once the project is about to be closed, it is open to be sold out - so the interested prospect pays the deposit for the project which is also a liability and when the prospect signs off the deal, he’s converted to the customer and then the invoice is generated for that project.How can we handle the same in Acumatica? Since its project with 2 accounts - Loan & customer.

Publishing works correctly on the Customization Projects List page,but an error occurs on the Customization Project Detail page. 

I’m trying to ship a sales order via the REST API.  This involves…Creating the shipment record Updating the quantities on the shipment Confirming the shipment Updating INThe actual quantity to ship comes from our internal custom WMS site, outside of and integrated with Acumatica.  Typically, the SO line item will have a linked Production Order.  When recording multiple Move transaction on the Prod order, the resulting Shipment will have multiple lines for the same item.  We rarely ever ship exact.  Depending on how production was recorded whether we had some extra pieces in stock already, the actual quantity to ship will frequently be different than the quantity ordered or allocated or produced.Admittedly, I don’t fully understand how the “allocated” calculations fit into all of this, or how they are determined based on quantity ordered and production quantities.  No matter what I try via the API, I run into the error of “quantity shipped is greater than the quantity allocated” when tr

We use Sales Order (SO) Invoices for all our Field Service invoices.  Our SO Invoice has its own report design, which is different from that of an AR Invoice.  The invoices for Service Contracts ONLY use the AR Invoice report. Because we have several companies, we cannot modify the AR Invoice report to meet our service company’s specific needs.  I have submitted a case to Acumatica.  We are told that Service Contracts only use AR Invoices.  To use the Sales Order Invoice, a customization is needed.  This makes no sense to us.  We should be able to use our SO Invoices to bill a Service Contract.  We believe this should be an out-of-the-box feature.Does anyone have recommendations for using the SO Invoice for Service Contract Billing?

Hello Team,I currently have an Import Scenario that imports Opportunities successfully.The Opportunity is created correctly with the relevant contact information, and the Business Account is also created through the same Import Scenario. However, I am unable to map the Business Account Name correctly.Has anyone created a similar Import Scenario where an Opportunity, Contact, and Business Account are created together using the same import process?I would appreciate it if you could share a sample Import Scenario or provide guidance on how the Business Account Name should be mapped. Regards

Hello all,How can I generate MRP consolidated out of all demands under a single row?

Looking for AP automation in Acumatica:Automatically capture vendor invoices from email/PDF Auto-match invoices send by vendor to POs/bills in Acumatica system Only flag for manual review if price variance exceeds tolerance Auto-send payment batches to bank after matchingWe only need the above core functions—no extra or complicated features required.We’re wondering:Is there a native Acumatica solution for this, or recommended third-party integrations? Our biggest challenge: some of our item IDs are different from vendor item IDs (only descriptions are similar). How does AP automation handle matching the correct line items in this case?Any advice or experience would be appreciated. Thanks

I am developing a GI where I need to change pricing of items on sales orders based on customer price classes. For example: If a customer has a customer price class of CUSTOMER, I need to reference the price of an item associated with COMPCUSTOMER. COMPCUSTOMER will never be a customer price class that we actually designated to a customer, but it’s more of a reference.  I’ve been trying to create a reference GI for my main GI to use but because you can’t use formula fields as relation link I’m a little stuck. 

Hello all,The Completed qty is still 0 even after releasing Move transaction:  

Hi, we have a sales order for a stock item that has unit cost of 0.4568 back in June 2025, but I can’t find the cost in inventory transaction history. How is this calculated and where is this inherited from? Help please..Item’s valuation method: FIFO This is the UOM of the stock item 

Hello all,I have a requirement where a user would like to create an SO from quote. Is there any automation that we can make use of or any import scenarios?Thanks.

How can I get the shipping address on the Invoice actually match the override from the Sales Order in the scenario below? Have in mind the Shipments and Invoice are generated from the Processing page on a schedule.I have a sales order with direct override of the Ship-to Address.This order then is partially shipped by 2 shipment to that same address. Then the Invoice is generated for the whole order and the address on the invoice is reset to the location address instead.The easy workaround would be to create actual Customer Location before shipping and use it, but that means I can’t normally use the Address Override feature anymore. It seems like the “Multiple Ship-To Address” logic on the Invoice is simply checking the Address IDs and ignoring the fact that it is the exact same address actually.  

The Create Production Orders screen is sometimes including sales order lines that already have a linked production order.  This seems to occur when the first production order is on an In Process status and has been partially completed.  The new production order is for the remaining quantity.This is a big concern in a Make to Order scenario where Create Production Orders is automated.  It can lead to over production of costly custom ordered product.  We have opened a support case and this has been documented as a bug.  In order to prioritize this for development, it would be helpful to identify if others are having this same issue.There is a similar known issue which was documented here and is considered resolved.  We are seeing this issue in 2025 R1.Thanks in advance!

Hi Team,In Acumatica, on the Journal Transactions screen, there is a Customer/Vendor field that is currently disabled. I have enabled this field, and I want it to work the same way as the Vendor field in Bills and Adjustments.In that screen, if a vendor has a branch restriction, the vendor does not appear in the selector when working in a different branch. I want the Customer/Vendor field in Journal Transactions to follow the same behavior.I have tried several code approaches, but I am still not getting the expected result. Does anyone know how to correctly apply branch restriction to this field so that the selector only shows vendors/customers allowed for the current branch?Any guidance or solution would be appreciated.Thank you.  #region ReferenceID          [PXDBInt()]        [PXSelector(typeof(Search<BAccountR.bAccountID>), SubstituteKey = typeof(BAccountR.acctCD),            DescriptionField = typeof(BAccountR.acctName))]        [CustomerVendorRestrictor]        [PXUIField(D

Has anyone else had connectivity issues recently when trying to connect or work in the mobile app when they know that they do in fact have WiFi/cellular connectivity?  When the error occurs the user is able to open a website in Chrome to confirm that they do have connectivity. This seems to be a new issue in the last couple of days, and all of the reports so far have been on Android devices.  It is affecting more than one of our customers on different Acumatica instances.    

Hello, I’m trying to automate the Create Purchase Order Process of my MYOB Acumatica. Though the automation works, it stops with the error, “Owner Cannot be Empty”. I have identified this because, there is no Linked Entity connected with Admin user and hence no Owner is filling on the Purchase Order form. And the field is mandatory. The admin user is not editable even to a full user.  Is there any way that I can automate the process. 

We have Restriction Groups that relate to certain Users seeing certain items. This Restriction Group has worked fine for a couple years. Now it periodically doesn’t work and Users can see items we don’t want them to. We are currently using Acumatica 2025 R1.Is anyone else experiencing this issue? Is there a fix?

I’m trying to update the Days Sales Outstanding to accurately reflect how our accounting team calculates DSO. I’m able to get monthly sales and current AR, however, I can’t get prior AR. For example, for March, 12th of 2026, I would want to pull open AR for March 12, 2025, December 12th 2025, and September 12th, 2025. Is there a way to pull that information into this table, and if so, how? 

Based on testing in 25R2, using Generate Orders for Subassembly pegs the Constraint Date to the Parent Order Start Date (not the individual Operation Start Dates) for the Subassembly orders that are generated.The Due Date is smart enough to look at the Operation Start Date for when the Painted Assembly is actually needed, but Due Date has no impact in the Generate Orders for Subassembly action.We’d like the Constraint Dates for the child orders to be pegged to the OPERATION start date, not the ORDER start date.  Is there a configuration we’re missing?  We do not use APS.Other areas of the system seem to look at OPERATION start date to determine Constraint Dates/Promise Dates/Demand Dates.  I know on the Order Type you can force the MRP system to “Use Order Start Date for MRP”, which pegs all Constraint dates to the ORDER start date, but there is no setting for generating production orders that says “Use Order Start Date [for pegging demand dates]”.  This behavior seems inconsistent wit

Hi Everyone, I’m trying to have more than one mailing “Default sources” under the Mailing and Printing Tab of Purchase Order Preferences, as seen in below screenshot. The issue is that, when i create a PO logged in to each of the branch, then when i click “Email PO”, only for the first branch’s PO does send the email successfully. For the rest of the 2 branches POs, clicking “Email PO” throws an error. Please see below screenshot for the specific error: Please help!Thanks,​​​​​​​Wandile

Is there a good way to accomplish this special situation?   Send shopify transfer order details to Acumatica as 1 step transfers. Thanks,Nirav S.

I import some records from file for Requisitions screen. in my file i have column with unit cost but unit cost not updated. Help please

I know that if I Prepare Invoice FROM the Sales Order after the shipment and return are complete, I will get a single invoice with both the return and the new item(s).However, that isn’t normal processing.  We don’t want to handle RMA invoicing separately. When we use Process Shipments > Prepare Invoice - we want to hold off invoicing till everything is returned and replacement shipped and create a single invoice (or credit memo if more returned than shipped). Is there any way to force the shipped and returned items into a single invoice?

Hello, I am required to initiate an approval process for Cash Transactions.However, I do not want the approval process to apply when the Cash Transaction originates from the Process Bank Transactions form, as those transactions are released by default without manual intervention.Is there a way to identify the origin of a Cash Transaction and bypass the approval process when it has been created through the Process Bank Transactions form?Thank YouAmanda 

Hello,We are on Build 25.100.0054.6 and we were in contact with UPS for a separate issue we were encountering.They informed us in their communication the following:“Starting Q3, 2026, the lifespan of OAuth tokens will be reduced from 4 hours to 1 hour. This means your integration must generate a new token every hour instead of every 4 hours to maintain uninterrupted access to UPS APIs. If your integration is hardcoded to refresh tokens every 4 hours, you will need to update your logic”We are wondering if this will potentially change how the carrier is connected with Acumatica and if this change will impact the connection with Acumatica at all?Thank you!