Discussion Forums

 IssueI am unable to find a field in the ecommerce Sales Order export mapping that indicates that an order has been paid via check on a related invoice. BackgroundWe work with government agencies across the nation, allowing them to pay via Purchase Orders, where we invoice them at Net 30 terms.We have set up a manual payment method on Shopify called 'Purchase Orders.' This method is configured in our e-commerce store settings in Acumatica but is not active. If we activate this manual payment method, orders will be marked as 'Paid' on Shopify, which can mislead some customers into thinking they owe nothing. This also adds a prepayment to the order, causing Acumatica to show all invoices as paid, resulting in no invoices being sent to customers. Consequently, we do not receive payment.To pay these orders, most customers send in a check, which we then apply to invoices in Acumatica. This payment information is not exported to Shopify, so even after the order is paid, it still shows as 'Pa

How can I get value from EPEmployee for POOrder? I tried to join them by EmployeeID for POOrder and AcctCD for EPEmployee but got error that EmployeeID does not exist in POOrder. How should I join them?

Below are the customization packages for the Surcharge customization. This customization allows you to apply credit card surcharges to invoices and sales orders in Acumatica, helping you recover processing fees with ease while staying compliant with regulations.  NOTES  The customization only works with Acumatica Payments; no other payment providers are supported.      Reference the Surcharge Customization User Guide for the setup procedures. 

We have 25R2 and when we create a vendor shipment for a Production Order, if material is not in OI-WIP at that time, the material shows 0 on the Material Move of the Production Order once the vendor shipment is confirmed even though we transfer the material from a bin location to OI-WIP prior to confirming the vendor shipment.We now have about 5 vendor shipments that show On Hold, yet the Production Orders are completed.  Material is NOT being taken out of inventory even though the vendor shipment does have the quantities shipped on them.Has anyone else had this issue?  If so, do you know a fix?

Hi community!Does anyone know of a package, or a bundle of advanced Acumatica reports available to the community members or for sale by a partner? Outside of the out-of-box ARM reports and generic inquiries.Thanks! 

When a user creates a Journal Voucher to reclassify an AP Bill (APB) and an AP Prepayment (APPR), they enter the correct Project and Project Task for both documents.However, after the Journal Voucher is released: The AP Bill retains the correct Project information. The AP Prepayment shows Project = “X – Non-Project” in the Financial tab. Why does the system ignore the Project information for the Prepayment while the Bill behaves as expected?

Issues is a standard GI for Acumatica.  When a Customer SO is shipped, Acumatica posted the COGS side of the equation.  The customer is known as the customer shipment generates the transaction, therefore one would presume the customer field would populate on the GI.  We are running MRP, so the Prod Order is produced, moved to FG and then shipped from inventory.Am i missing something somewhere?cch 

Our team picks 12 orders at a time using the mobile scanners and pick lists.  When multiple orders in a pick list (wave picking) have multiples of the same item, picking directs them to pick one per tote until complete.Example: totes A, B & C each get two of the same white shirts.  A picker will be directed to put one unit in tote A, one in tote B, one in tote C, then another in A, another in B and another in C.Is it possible to change it so that they are directed to put two in A, two in B and then two in C?

Our team is currently in the middle of an implementation of Acumatica 2025R1. We have the manufacturing module.  With our existing process, we would make a production order for 100 parts with an outside process operation. We might only have a portion of the parts ready for outside processing, and would make a PO for those parts and send them for outside processing. Later, we may send another portion from the same production order on another purchase order, etc., until all parts have been sent for outside processing. The parts from the earlier PO might return before the other parts, and we would start working on the next operation for those quantities.  Is there a way to achieve this process in Acumatica? We want to be able to track the costs from the purchase orders on the production order and track the quantities sent to the vendor, including how many have been returned and how many are waiting to go.

I am trying to update the default salesperson on a list of customer.  I did visit a few answers where someone showed an example and I created it based on that.  I tried to just run one line and I am getting an error message.  I tried a few different things but it’s still erroring out without giving me much guidance to what the issue its.    

This has floated around a bit over the years.  You install Acumatica on a local instance, and you include RabbitMQ.  Installation goes ok, or so it seems. However, when you try to access your local site, you get that dreaded message that RabbitMQ failed to load.  Or maybe after some updates on your system, it stops working.  What can you do?  Well, the simple “fix” is to comment it out in web.config, but there’s a catch!I was helping a colleague today with business events, and RabbitMQ being commented out (because it failed to load, and we took the easy route of web.config months ago) resulted in an error that MSMQ was not installed.  Sure enough, we don’t enable it as a feature on our local machines.  RabbitMQ was running as a service but failing with error when trying to access the website.  In this case, we uninstalled ERL and RabbitMQ, rebooted, deleted the last of the ERL(something) folder in Program Files.  Then using the extracted files of the installer package from the same bui

We need your help with a specific payment process on Acumatica. Here is our scenario:An employee hires a worker and pays them on behalf of the company. Later, the employee submits the documents and bills to the company to get a reimbursement (get their money back).Our desired process is: The company receives the bill from the employee. We create a Bill in Acumatica where the Vendor is the worker, and we apply withholding tax. We pay the full amount to the employee, but the withholding tax must be recorded under the worker. We tried using the Joint Payee feature on the Bill, but it did not work. It does not allow us to pay the full amount to the employee while keeping the withholding tax history for the worker.Is there any way to handle this payment process in Acumatica?

We are experiencing an issue with the bank feed for the USD15 account in Acumatica. The feed is connected successfully; however, no transactions are being retrieved for April 2026. In some cases, the system only pulls recent transactions (e.g., from the previous day), but not from the beginning of the month. ImpactIssue affects 4 Bank of America accounts under the USD15 feedOther bank feeds (e.g., Amex) are functioning as expectedClient is currently forced to manually upload transactions, impacting operational efficiency Observed Behavior Bank feed returns no transactions for April 2026, despite confirmed activity in the bank accountAfter reconnecting, only partial/recent data is retrievedOther feeds (e.g., Amex) are working correctly Troubleshooting Performed Disconnected and reconnected the bank feedVerified bank login credentials directly via the bank’s platformRetried transaction retrieval after reconnectionTested in test mode – same behaviour observed (no transactions returned)Att

Hi, I have written the logic to expose a UDF (UsrMACFWarehouse) on the Companies and Branches screen which works on my local site running via Modern UI, however once I export the customization package and import to my production site, the fields are not exposed but the project builds correctly.Can you please check the attached project on what could be the issue? 

hello all,We have the AI Assistant feature from 26R1, however I would like to know if anyone has experimented it, and how?Thanks.

Hello Community,Hope someone in the community will be able to share some insights.if a vendor has 30 day payment terms, these terms will apply to the AP Bills.  Acumatica does NOT apply these terms to AP Debit Adjustments.  Why? We have situations where vendors issue a credit and then a re-bill for a price correction. We don't want to take the credit against one payment and then have the re-bill paid on a future payment. We would want them both to show up on the same payment.Thanks,Hari

I updated our production site a couple of days ago and have encountered a strange issue where the site still works, the GIs, reports and customizations all still work, the updates screen is showing the correct version, the server is showing the correct version for the site and the database but the login screen says “Last update was unsuccessful”. I’ve tried running the update again and it does not show the correct update date, it still shows the original one from two days ago and the update history does not show a timestamp for when the update finished. Any ideas on what I can do to get rid of the error message and ensure that there is nothing wrong with the site? 

Hello All,We have a client migrating from Dynamics SL where they have the option to update the Cost at Completion with every Budget Revision.  They may have multiple Budget revisions on a single day, especially at the end of month.  We would like to recreate this functionality by creating a Cost Projection by Date for every Cost Budget in Acumatica, but are limited due to Acumatica only allowing one cost project for a date.Is there any plan to allow multiple Cost Projections by Date for a singe date or revise/correct a Cost Projection for a date?  Or..has anyone found a work around to allow multiple cost projections for a single date?Thanks!

The BAccounts in my system each have multiple locations.  I need the GI line results to have 1 line per BAccount and show the Location address information for the LocationCD =’Mailing’.  If there isn’t a LocationCD = ‘Mailing’, then I want it to show the location that is marked as “IsDefault”.   Maybe it is better said, “If there is a location named “Mailing”, show that address.  If not, show the address for the location marked “Default” What would be the best way to create this condition in my GI?  

I want to add a box connotation (colored status field) to a customized stock screen (AR303000) in a customization project on 2026 R1.I created status-colors.scss and referenced it from my customization HTML:<template>    <require from="./status-colors.scss"></require>    <qp-fieldset id="fsLoyaltyProgram" view.bind="BAccount" caption="Loyalty Program" wg-container="BAccount_LoyaltyProgram">        <field name="UsrMembershipStatus" class="colored"></field>    </qp-fieldset></template>The file shows on the Modern UI Files page at screens\AR\AR303000\extensions\status-colors.scss, and the customization publishes successfully. But at runtime the console throws:Uncaught (in promise) Error: Failed loading required CSS file: customizationScreens/Company/screens/AR/AR303000/extensions/status-colors.scssWhat I've already ruled out:Not the SCSS contents — fails the same way even with a trivial .colored { font-weight: bold; } and no @import. Not sta

We are working on setting up MRP and seem to have run into an issue. The Safety Stock field in inventoryItem (AMSafetyStock) can only handle values up to 9,999,999. We have items that require a safety stock of anywhere from 10-50 million (possibly even more). In a sandbox, I updated the field to accept additional digits but we are still getting errors. I also do not know if that is a good way to go about it. Seems like an update that touches that table could change the field back and destroy that data. 

As i was releasing tax report this error popped up. see attached

We create our Production Orders from our Sales Orders.  By default, the system will create the order for the full sales order quantity.Without having to create the Production Order via MRP, Is there a way to: Create the PRO for the shortfall amount automatically in Sales Order, Or be able to adjust the quantity before hitting CREATE.In example below, we have 5 in inventory, so we only need to make 11. 

Hello all,In the previous versions of Acumatica we had the functionality, for instance that if we have an item lets say AAComputer and if a user tries to add a new item in the Inventory ID field, as soon as the characters are entered Acumatica displays the relevant results. So if the user enters AACOMP, Acumatica displays the result for the existing item in the search result.Here the user isnt making use of inventory lookup, but just typing in the characters and it displays the items that already has the keyword.However in the current versions, its not working at all even after enabling the full text search. Is there anyone else facing the same issue? Regards.

Hi, I was wondering if there is any report or GI (custom) that can display for all transactions:The net amount of the payment (excluding GST) The GST amount in the payment The details of the payment (ie supplier/client name, transaction description etc) What GL account the transaction was coded to Some way to be able to drill into the transaction if needed, whether that be a link in the report or at the very least a transaction number or similar that I can then go and look up in the relevant area to get more detailThe idea here is to be able to review whether GST has been claimed correctly.  For example, I can look at all transactions in the “Donations” expense account and confirm straight away that no GST has been claimed on any of those, and then I can look at all transactions in the “Software Charges” expense account and confirm straight away that they all have GST claimed on them.  Example of what the report should display (see the yellow highlighted section). You can see straight