Discussion Forums

I have an import scenario where I would like to use address line 1 and the postal code of the customer’s account as key fields instead of the customer ID and then update 2 user defined fields. This current import mapping isn’t working.   

Dear ALL,In Acumatica Report Designer, some reports, such as Unreleased AR Documents (AR656100), do not display the "RUN REPORT" button, unlike other reports.Could you please advise how to make the "RUN REPORT" button appear on this report?  Best Regards,NNT

When we create a SO from Sales Quote (QT) using the copy order option, I have noticed the Quote is updated to the Completed status. However, I was unable to find the Sales Order number anywhere on the Quote. Is there a way we can see the So number on the Quote itself. Thank you!

When creating an AP bill directly from the Purchase receipts screen, then click ADD PO Receipt Line to add additional PO receipt lines to the same bill, some eligible receipts are not displayed.However, when we create the AP bill directly from the Bills and Adjustments screen, select the same vendor, and then ADD PO Receipt Line, all received PO receipt lines are available.Could someone please clarify why the available receipt lines differ between these two methods and whether there is a setting or process we need to follow to ensure all applicable receipts appear on the AP bill?

Hello, the following code snippet does not result in my new field being added to my inventory selector. This seems like a straightforward approach? namespace PX.Objects.IN{    public class InventoryItemExt : PXCacheExtension<PX.Objects.IN.InventoryItem>    {        #region UsrModelID        [PXDBString(125)]        [PXUIField(DisplayName="Model Number")]        public virtual string UsrModelID { get; set; }        public abstract class usrModelID : PX.Data.BQL.BqlString.Field<usrModelID> { }        #endregion    }    [PXNonInstantiatedExtension]    public class IN_InventoryItem_ExistingColumn : PXCacheExtension<PX.Objects.IN.InventoryItem>    {        #region InventoryCD        [PXMergeAttributes(Method = MergeMethod.Append)]        [PXCustomizeSelectorColumns(        typeof(PX.Objects.IN.InventoryItem.inventoryCD),        typeof(PX.Objects.IN.InventoryItemExt.usrModelID),        typeof(PX.Objects.IN.InventoryItem.descr))]        public string InventoryCD { get; set;

Hi all,Does anyone have any knowledge or experience with being able to have one “parent” customer with multiple bill to’s?  We use the locations for having multiple ship to locations but am looking to be able to link multiple Bill To’s to one customer number.

I have an existing GI that works and pulls records correctly.  I wanted to use it as a base for another GI.  I tried copy and paste from the clipboard,  I tried saving it as a template and I tried copying it by recreating from scratch using the same tables, conditions etc but the new one pulls no records before I even made any changes. I am completely stumped.  Has anyone else run into this issue?  We are on 2025 R2

Our company has noticed on every screen, when entering a string into the search bar if they slow down typing even a little bit it will start the search halfway through entering. It seems ridiculously acellerated in 26R1 from our previous version.Is there a way to slow this down, give it at least 1.5 or even 2 whole seconds before it starts the search? (right now it feels like a quarter second or even less, some of our slower typists find it borderline unusable) 

How to install acumatica erp application in mac

My FA team report the different about sub account of Credit Memo and Oriinal Invoice.they using Invoice Correction to generate that Memo. i have  try to identify, and i found that subaccount for the Memo same with  SO Subaccount  for the Original invoice.Is there any configuration that needs to be done so that the Credit memo subaccount is the same as the Original Invoice subaccount? thanks for helping me.

Hi everyone,We’re hitting a small snag with rounding in our setup and would love some advice!Our system is set to 2 decimal places, but a few of our vendors use unit prices with 4 decimals. Because of this, the total amount (ext. cost) gets slightly off when we generate Bills and Receipts compared to the original PO.Here’s what we’re doing right now: Vendor Bill: We can manually tweak the total so it matches the vendor's invoice fine. Receipt: It pulls the total directly from the PO and won't let us edit it. This leaves us with a small inventory value difference. Has anyone run into this before? What's the best way or workarounds to fix or balance this out on the Receipt side?Thanks in advance for any tips!

I’m trying to log in with my user (or any user) but I keep getting “Invalid credentials. Please try again.” message.  I reset the password to “setup” in the Users SQL table but that doesn’t help.I even tried clicking “Forgot your credentials?” and filled out the form giving me: “An email with further instructions will be sent to this address if it matches an existing user. If you don't receive the email within a few minutes, try again or contact your system administrator.”No email is sent. How can I set the password and log in?

We are using the  native Amazon Connector (BC201020), importing seller-fulfilled orders.I originally set up an item as a stock item and added its ASIN as an Alternate ID (Global type) on the Cross-Reference tab. We later decided the item should be a non-stock item instead. I created the non-stock item, removed the cross-reference row from the stock item (and saved), and added the same ASIN as a Global cross-reference on the non-stock item.When the Amazon Connector imports an order containing that ASIN, it errors out saying the cross-reference exists on two items — both the original stock item and the new non-stock item.**What I've checked:**- Reopened the stock item (IN202500) — the cross-reference row is not visible on the Cross-Reference tab.- The non-stock item (IN202000) shows exactly one row for the ASIN, Alternate Type = Global.- Only one UOM row exists per item; no duplicates within either item.**Questions:**1. Is there a place other than the item's Cross-Reference tab (e.g., a

Hi everyone,The Dashboard Reference is now available for 2026 R2:Acumatica Dashboard Reference (2026 R2): https://beacon.acumatica.com/reader/shared/bffd1312-b73c-4159-82e0-6d180c4a026e/rootIt covers all 70 predefined dashboards in 2026 R2, grouped by module. Each dashboard page shows its screen ID, what it's for, where it's published, and every widget with the generic inquiry or form behind it.What changed since 2026 R1:Management now has a Modern UI version. AM-Production Meeting replaces the two project widgets with Active Project Production Orders and Project Production Orders by Status, both based on production orders. More dashboards now open in the Modern UI from the menu, including AP Clerk, AR Clerk, Controller and the main Manufacturing and Payroll dashboards. AP Clerk, AR Clerk and Controller also have separate Classic UI entries now (DBAP0001, DBAR0001, DBCA0001). These are listed on each dashboard's page.The 2026 R1 version is still available in the original topic: Communi

has anyone been able to use the decision wait time on approval maps?What happens when the decision wait time expires what happens to the pending transaction?I set my wait time for 10 minutes and nothing happened, I was still able to approve it after the ten minutes.Do i need to set something else up?

Dear community!We always listen to your feedback and it is very helpful and valuable.I’m glad to share that in 26R1 we are introducing improvements to Project–Branch defaulting in Purchasing and AP documents. More details will be available in the release notes soon.We are continuing to move in this direction. At the moment, our main focus is on Employee Time Cards and Employee Time Activities in combination with Payroll and corresponding Project transactions and Journal transactions.We would really appreciate your feedback, especially around real-life payroll and time entry scenarios. In particular:Do you have cases where employees enter time for projects that belong to a different branch than the employee has, and this creates issues after time is released or payroll is processed? What is the semantic of the branches of such clients? Which payroll (built-in or external) is used? What branch do your customers expect to see in the project expense and employee liability and why? Which

Hi everyone,We have a consignment sales process where, upon receiving a PO from a consignment customer, we manually create a Transfer Order (TO) sales order in Acumatica. This process transfers inventory from our warehouse to the consignment warehouse.Subsequently, every two weeks, we create a regular sales order based on the actual quantities sold during that period.We are currently integrating with SPS Commerce EDI and would like incoming customer POs to automatically generate TO orders in Acumatica. However, we have encountered an issue: the “Destination Warehouse” field on the TO header is mandatory, and the EDI-generated order does not populate this value. Has anyone implemented a similar consignment process with Acumatica and SPS Commerce EDI? If so:How did you handle the Destination Warehouse requirement?Were you able to configure it through standard functionality?Or did it require customization on the Acumatica side? Any insights or recommendations would be greatly appreciated.

Hi, I’ve created a very simple GI to show account’s history out of GLTranR DAC. However, I am unable to pull the beginning and ending balance data. The goal is to show each GL Account ending balance per transaction line. Basically, like the below showing the Account ID, BegBal, Debit and Credit Amt and its ending balance on that day.Attached is the GI I created. I am open to suggestions or if you could modify the GI to achieve this, that’d be great as I think many of users/consultants would want this. Thanks heaps! 😊I’ve created a GI to show ending balance per period, but we do need the specific date rather than the period with no way to check at any other point in time. With a date filter we simply go back to the day we need to check.

Hi all,I’m testing Order Orchestration in Acumatica 26R1 using Destination Priority with multiple warehouses and wanted to confirm the expected behavior when total available inventory across all eligible warehouses is insufficient.Current setup:Fulfillment Strategy: Destination Priority Shipping Zone: EAST Warehouse priority: EAST CENTRAL WEST Order type is configured for Order Orchestration Will Call is cleared and the order is otherwise eligible for orchestrationI’ve confirmed the following behavior:If one warehouse can fulfill the full quantity, Acumatica may select that single warehouse. If no single warehouse can fulfill the quantity, but multiple warehouses can collectively cover it, Acumatica successfully splits fulfillment across those warehouses. If the total available quantity across all eligible warehouses is less than the sales order quantity, orchestration fails with:“The order cannot be orchestrated due to insufficient stock across all available warehouses.”  The clien

Hi,Does anyone have experience with Email Templates using ((Case.Description)) or ((Tasks.Body)) in the layout but the notification when sent is almost certainly treating ((Case.Description)) or ((Tasks.Body)) as plain text and lumping every thing that should be on separate lines together? Email Template using ((Case.Description))Case Description on a Case CR306000 which is prepopulated from the Workflow inside the customization project All Emails GI record shows the ((Case.Description)) is plain text / squashed together This started happening with 26R1 but it doesn’t happen on every Case/Task Email Template where ((Case.Description)) or ((Tasks.Body)) is being used.I tried to replicate it many times but can’t.

Hi, another beginner's question to you experts and if this is covered, my apologies and please direct me to the correct reference.  We have multiple tenants in our production environment.  I recently made change to a Genera Inquiry in one of the tenants and same change is not visible in other tenants? Do I have to make the change in each Tenant or there is an easier way to cascade the change down to other tenants? Thanks in advance.

I just created this KPI, and I’m trying to pull the OrigOrdeNbr to know the Original Owner. NOT the new ownerAll the records are pulling the OrderNbr Owner.Like the records below its showing 2 different OwnersI need help in finding out how to get to the OrigOrderNbr Owners.

Hi, I've setup a GI and a business event to send an email notification to all members of workgroup that there are POs waiting for their approval. It works fine but it sends an email notification for every PO made and approvers find it confusing. To avoid confusion, the new requirement is to send a daily blanket email instead of an email for each single order. To do that, I need to create a report and a business event to send it on schedule, but how do I set it up so that it sends the report separately per workgroup?For example, one email notification only to members of workgroup 1 and if the PO requires approval from workgroup 2, it only sends it to members of workgroup 2 and so on..

We have recently upgraded to 2025R2 and with modern UI on our Change Orders require to be released after final approval. With Classic UI it still works as expected where Final Approval results in Status Closed How do I update the modern UI to go straight to Status Closed after final approval instead of Open → Release

Hi, While releasing “Materials” transaction for Non-stock items , no inventory transactions (issue transactions) get recorded however for “Purchase Receipt” there is inventory transaction (receipt) get created. Is it expected behavior or I am missing something ? I have observed that scenario in 25R1. Please help me