Discussion Forums

I’m at a lost keep getting a “Failed to Commit to Adjustment Row” XML attached. The intermediate save is not the issue. 

Is it possible to prepare an existing binary snapshot already prepared for export in XML using “Prepare in XML format”?If this is possible, would I need to put the tenant in maintenance mode to do so?I exported a binary snapshot to import via the setup wizard and also to save as much space as possible but I forgot that it had to be in XML format for that method of import to work. 

On the Portal Settings page, the uploaded Sign-In Page Image does not seem to be displayed on the portal Sign-In page.Has anyone else had this issue or know how to fix it?The Welcome to the Self-Self-Service Portal default screen is replaced with a blue box, instead of the uploaded image…  

Here’s my scenario: on Acumatica 26.100.0175.3, I have an environment with two tenants, let’s call them Tenant A and Tenant B. Tenant B is configured as a Test Tenant.I have a simple customization project that includes both custom fields to extend existing DACs (in this case, the CR.BAccount, SO.SOOrder and SO.SOLine DACs), as well as a new custom action button on SOOrderEntry. Both Tenants have the same Customization Projects loaded (via Export / Import). When I publish the projects in Tenant A, the custom action appears in both Tenant A and Tenant B, but the custom fields only appear in Tenant A. When I publish the project in Tenant B, the inverse happens (fields disappear from Tenant A, appear in Tenant B, and the new custom action still appears on both).I can’t make the custom fields appear in both Tenants at the same time for some reason. I’ve never had this issue in any other environment. I’m at a loss to explain what is going on here...

How to Calculate  Landed Cost for  items in Drop-Ship Order . In Normal Practice Yes its Not Possible since drop-ship orders are shipped directly from the supplier to the customer without passing through your warehouse

Hello,Really struggling with this one. Customer uses Crystal reports for a year on year analysis so can do full sql etc. I’m trying to reproduce this below in a GI and this is for a specific customer Where is becomes difficult is that when they go live there is no last year data although we will have a legacy dac and that is challenge when there is no option to do union, has anyone else achieved this ?

We know that Acumatica supports two entry points to create Credit Memo, I refer to them as SO Credit Memo and AR Credit Memo for short. Is there a way to restrict most users to only create SO Credit Memo from the SO Invoice entry, while only specific people have the permission to directly create AR Credit Memo in "Invoices and Memos"?The difficulties I encountered:Although the entry points of these credit memos are different, they seem to be essentially the same entity. SO Credit Memo will be converted into AR Credit Memo. I only want specific people to be able to create AR Credit Memo, but I also want other users to have permission to create AR Invoice. They are on the same screen and are different types of the same document, so I cannot directly restrict the "+" button on the "Invoices and Memos" screen.  

Hello,  I have a scenario where my company is based on UK and I have warehouses in Netherlands and Spain (Also in few other countries) Also, I have an EU customer whom I shall deliver goods from either Netherlands or Spain.On a sales order when I select the warehouse considering the country of it (If the country can be taken from branch that is also an option), and country of the customer, it should update the correct Tax Zone. In simple terms, my tax zone needs to be updated not solely based on the customer country but also considering the order origin country.  Is there a way to get this done?

I’d love to visit with someone who is using DRP for imports. We import textiles from India and Turkey so we have purchase orders placed, receive goods to an ITR warehouse when we put a container on an ocean shipment, then transfer goods to our main warehouse to fulfill sales orders. Our goal is for DRP to keep the inventory in our main warehouse to a minimum while keeping supply flowing in the purchase orders and containers in the ITR warehouse. Obviously DRP generates a lot of data with the requirement plans, safety stock, planned transfer demand, forecasts, etc. I’d like to hear with anyone who is using DRP and importing goods from overseas using container shipments (no preference on what you use to track containers - just interested in the bulk nature of transfers instead of being able to transfer at any time to meet demand). What tips/tricks do you have to keep this user-friendly for purchasing and inventory management staff? How did you set up safety stocks in each warehouse? 

I am using an import scenario to migrate my client’s open purchase orders.  I am testing it to ensure it works for go-live and it is only bringing in the first line of the purchase orders and the remainder error.  I have tried adding the @@LineNbr, but it still errors.  What am I missing? 

We have a weekly report of order cancellations/adjustments which we send out to customers. I have been able to set up a Generic Inquiry to identify the Customers who need notifying with a scheduled Business Event to send an Email Notification with a report attached to those customers. However, we have a customer that would like that report sent to multiple email addresses each week. I have set up the email template as a Mailing in the Account Receivable Preferences, added it to their Customer Class, and added the additional Recipients on the Mailing & Printing tab of that Customer record. Yet, when I generate the email via the business event, those additional recipients are not added to the email. Am I missing something in the setup, or is this functionality just not compatible with a custom GI/report like this? Is there a different way the Email Template has to be set up so it can have those additional recipients added, like a special placeholder or something? Testing Event Setup

 In December, I identified discrepancies in my historical inventory valuation report. I was able to isolate the specific transactions causing the issue; however, I require guidance on how to properly resolve it.The issue appears to have originated from the following sequence of events:A purchase order was created, and the items were subsequently received into inventory in November. Upon receipt, the Inventory account was debited and the Inventory Purchase Accrual account was credited. The customer was then billed in December, resulting in a debit to Accounts Receivable and a credit to Revenue. After billing, the inventory was allocated to the job, at which point Inventory was credited and Cost of Sales was debited.For this particular item, the historical inventory valuation report reflects a beginning cost, which is the correct value, followed by a sale amount that is double the beginning value, ultimately resulting in a negative inventory balance.  I don’t understand why the sale colu

Hello! I have made a few filters and want to show our “Default Salesperson” employees how to filter only their name. This is easy to do on desktop However, when I go to the mobile app, the filter doesn’t show up correctly. When I click on their filter, it’s blank.My initial guess is because there is no sort option for the salesperson on the app. Is this the case? If so, how do I add this as an option so our remote salespeople can see their sales more easily when they are travelling?

Hi good day.On the customer contracts screen, when adding a file to a contract with already existing files, i received this error message.Did anyone encountered the same? Thank you.

Hi everyone,We’ve recently upgraded from 24R2 to 25R2 and have encountered a strange issue with Employee Timecard/Summary/Summary Activity.In 24R2, users can enter their time spent per day of the week directly in the Summary Activity section (see left screenshot). However, in 25R2, this entire section appears to be missing, even without any customization published (right screenshot).This prevents users from entering their daily hours as they normally would.Has anyone else experienced this behavior after upgrading to 25R2?Thanks  

Currently when you upload the revenue items in a project, cost codes are not available to be imported.  Would be nice to extend this. Has anyone found a workaround, or created a customization?  We typically have 100 plus task on each project, would be nice to upload with all the other information. Thanks,Jeremy  

We’ve created an export scenario using a GI as the source. We need to add a trailer record to the end to sum up the number of payments and the total payment amount. Does anyone know how to do this?

Hi all,I know there is an existing discussion regarding adding @FinPeriodID as the default value for Period schema fields in Generic Inquiries:Add @FinPeriodID as Default Value for Period schema fields in Generic Inquiry | Community   However, I haven't been able to find the workaround that others have used. Would anyone be able to share some insight?My goal is to have the Generic Inquiry default to the current financial period, as it currently loads all periods by default, resulting in performance issues and, in some cases, errors. Thanks for your time.   

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Arpine Arzumanyan - Acumatica Community Featured Member for July 2026Meet Arpine Arzumanyan our Acumatica Community Featured Member for July 2026. It’s great to have you as part of the Acumatica Community ​@arpine08! Introducing Beacon: Your New Knowledge DestinationOne place for everything, Personalized for you, AI-powered, More personalization comingVisit Beacon today: https://beacon.acumatica.com Acumatica User GroupsNew! Special Interest Groups:  Food Distribution Customer User Group, Nonprofit Customer User Group, Industry Groups: Construction Customer User Group, Distribution Customer User Group Request to join today!All Acumatica User Groups How to Answer Questio

Does anybody know how I can have Acumatica prevent one from Posting an AP Bill against a Purchase Order if the Amount of the AP Bill is greater than the Unbilled Amount of the PO? There is a setting in the Purchase Order Preferences screen where you can choose between No Validation or Validate with Warning but the Validate with Warning still allows you to do it. Our client wants this to be prohibited. I thought of using an Approval Flow to require approval if the AP Bill Total Amount is greater than the PO's Unbilled Amount, but I don't see how to do that. Is there another way?

I have enough stock item to adjust but after releasing it show the error message about

We have a client that does a lot of custom one off work, and they often reuse the same inventory ID, so they do not have to create 100000 inventory id that they will never use. They are using estimates, so everything gets built out to meet the needs of their customer, but when they go to add it in to the project, it will not allow for duplicates on the project task. They don’t really want to create multiple project tasks, as it duplicates a lot of their work flows. Ideally we would be able to utilize configurations, but configurations and estimates don’t play nicely, especially since there are a lot of outside processes and unknown charges that they need to then flow down.The workaround that they have come up with is to have duplicate inventory ID (remove and replace1, remove and replace 2, etc) so that they can add everything to the project task and group everything together.Not ideal, but better than creating a bazillion part numbers. 

Hello,Does anyone able to manage sales categories in Acumatica and sync it to Shopify as product Collection?Thank you

I am stuck. I setup a Sales Order Invoice approval map so that Certain People can do the approval, but they cannot do their own. When I test myself it works and catches on the NOT Norman with a reject. When I test it with Lana, it catches on NOT Lana, BUT IT APPROVES! but NOT Lana is setup the exact same as mine.I am at a loss

We are trying to find a solution to alert users that we have shelf-life inventory that is nearing expiration date. Is anyone using the MAX SHELF LIFE field on the Stock Item under the Inventory Planning tab? If so, how does it work? If there are other processes that people are using, I’d love to hear them. We want to be more proactive with identifying product nearing it life span.  Thanks!