Solved

I

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. 

Hello, We are currently in the process of upgrade from 23R2 to 25R2. In the process, of upgrade we encountered an issue with scrapping on production orders. A case/Bug has been opened with Acumatica. However, we do not have an established timeline for resolution at this time.  Problem:When performing a scrap on a production operation the Production Order Detail will record the scrap on the operation in which it was performed. However, the scrapped qty will not update in the first operations QTY remaining and QTY to Produce Columns. All upstream operations, from before the scrap action will remain in a “Completed” status. In our production environment, if a scrap occurs, we must start over from Operation ID 0010.This means, we have completely lost visibility to a production order in the upstream work centers that is starting over in the production process due to scrap. This also means, we lose our Material transactions and labor cost associated to the rework of the product in the upstre

HI, I have created a business event that I want to archive every BOM but the latest one. Can any one give insight as to what the trigger conditions should be? My GI work fine and so does the import scenario, the Business Event is not firing. I also do not want it to archive the newest BOM such as A.  

When I do this in the Customer Payment Method, I get an error.   To explain further, I created an Import Scenario to Mass Update the Customer’s Payment Method as seen below but the IsDefault field is unchecked. 

My financial year starts 1 March, so March = Period 01.I built a 12-month rolling Trial Balance using ARM based on a Start Period/Financial Period parameter.Requirement:P&L accounts: show Turnover (period activity only) Balance Sheet accounts: show Ending Balance (cumulative)The monthly columns work correctly.However, the issue is with the YTD column:For P&L accounts, even if I set the column to Ending Balance, the YTD column shows only the previous month’s amount instead of the cumulative total.Example:Jan = 500Feb = 600Expected YTD = 1100But the report shows 500.Has anyone configured a rolling ARM trial balance like this, especially with a financial year starting in March, P&L Accounts should show Turn Over and Balance sheet Accounts Should show ending balance. How did you handle the YTD column for P&L accounts? I have attached my XML File for quick reference

I’m encountering an issue when creating a PO from the Inventory Planning Display screen. The demand is being generated for a specific Project. However, when the PO is created from the Planning screen, the Project field on the PO is defaulting to Project X instead of inheriting the actual Project associated with the demand.I’m trying to understand whether this behavior is driven by system setup/configuration or standard Acumatica functionality.Is there any setup or configuration that can prevent the PO from defaulting to Project X and instead carry over the correct Project from the originating demand? 

Hi, I'm experiencing an issue with Project Template security: I have assigned a Project Group to a Restriction Group to limit access. In the Project Templates (PM208000) screen, it works correctly (users outside the group cannot see the template). However, in the Projects (PM301000) screen, when clicking the Template selector, all templates are visible and selectable, regardless of the Restriction Group settings. Why the visibility restriction is not applied to the Template lookup field in the Projects screen?

Does Acumatica have integration with Stripe Payment Systems? Thanks

Hi, I am getting duplicates when printing a credit memo. What’s weird is it not happening to all credit memos and invoices. Only happens to some of them. I’ve attached the report file. Thanks for your help!  

Hi Community, I am in need of some help. We are currently booking some AR payments into a clearing account and then using the Bank Deposit feature to transfer those funds to the final bank account. However, we’ve found a couple instances where a payment that’s part of a bank deposit is returned. We would normally void the payment.How should we go about recognizing the returned payment since we shouldn’t be voiding payments that are part of a released deposit? We also need to be able to select the returned payment in the Process Bank Transactions for matching.Appreciate any insight.Thanks.

Hey, gang - I’ve reviewed a number of posts related to this issue, but wanted to get the team’s thoughts on my specific case.  I’ve got a client who wants to see total INTran Issue Quantities over the past 12 months, by month, as well as On Hand, Available, and a few other metrics related to the individual Stock Items, all in a single GI they can manipulate by date.  We usually get the System was not able to get record count warning, and I’m wondering if the community has some insight that’s tailored to this GI.  I’ve attached it for reference, too.  FWIW Somtimes, if I remove the grouping and re-add it, or if I change the date parameters, the warning goes away. This GI is really two parts - the first is the month-to-month data from INTran, conditioned by financial period.  Here, I aliased the MasterFinPeriod DAC 12 separate times using the DateAdd formula to reflect the month via the Joins.  The DateAdd formula is using a parameter, so all the months can change based on the selected [

Has anyone been able to get an import scenario to work for the Trial Balance screen?  No matter how I adjust the Commit checkboxes, the assignment of Import Number, or the Key assignment in the Data Provider among other things, the best I can do is get a single detail record saved and I wind up with the same number of trial balances created as I have records in the file.  I’ve tried using keys from the record (Branch, Ledger & Fiscal Period) and also an added field to the file to group the records by Key.  I currently have ‘<NEW>’ assigned to the Import Number field in the attached xml, but that isn’t the issue.  I haven’t had this issue with other import scenarios for screens that have a Master - Detail relationship.  Since I have about 15 companies and 13 trial balances that need loading per company, I’d rather use an import scenario over the grid import of the detail.  At this point, I haven’t even tackled the Validate step; I’d settle for just getting the detail records i

I’ve imported Employee records to the Employees EP2030PL screen with an Active history record.  I could use help creating an Import Scenario to create the PR203000 Employee Payroll Settings record. I’ve tried the out-of-the-box Import Scenario, Import Employees for new EmployeesPayroll without success.  I’m using version 2026 R1.It seems the Insert Action in the  Import Scenario does not open the Create Employee Payroll settings dialog, or the Create button isn’t getting clicked.Any suggestions will be greatly appreciated. 

Trying to import Production Orders and the first row went in, now the rest will not. Any tips?  

I have a client that has to create zero net pays once in while and they can’t release the transaction. It shows open and nothing hits the general ledger. Is there a special way you have to release a paycheck that has zero net pay? I have tried releasing it from paychecks and adjustments (inquiry), releasing through the paycheck transaction, and through process payroll documents. It is stuck in a open status and the only options you get are calculate. Since it did not hit the ledger then how do you continue with the transaction? Any comments would be appreciated. Thanks

When we use the Acumatica plug in within Outlook we aren’t able to link to any account. This has been functioning in the past but over the last week when Acumatica had an update it doesn’t work. For account and contact it only shows a list of employees and doesn’t allow us to search accounts in our Acumatica database. Please see screen shots below and offer answers as to how we can fix this issue. Thanks! 

in 25R1, what logic is used to archive sales orders?  shipments?  The help doc states that sales orders with a status of complete or canceled will be archived.I ran the archive process on sales orders and shipments.  The majority of the sales orders were archived but I still have sales orders that fall outside of the retention period with the completed status.  The archive process did not archive any of my 20k shipments that fall outside of the retention period.Any insights?

I have received some requirements from users. They want to display a QR code payment image that is generated as a base64-encoded PNG from an external API.I need to show this base64 image on an Acumatica form. Once the user scans the QR code and completes the payment, we will receive a response from the API and continue with the next process.Please guide me on how to display a dynamic base64 image in Acumatica 2025 R2, for both the Classic UI and the Modern UI.

Hi , In GL Module the tran description has 256 Characters where in Fixed asset Module in it 512 Characters so could you please validate and add the point

One of our clients recently went live on Acumatica and are struggling with easily logging time against multiple production orders at once. They are on 22.212.0046. The Multiple Clock Entry screen gets them close to what they need, but isn’t efficient for their shop floor team at all. They need to be able to select all production orders that are associated with a single sales order, clock into a work center, and then clock out of that work center. Ideally this could be done on the mobile app and via scanning, but that’s not supported. I tried exposing the Multiple Clock Entry screen on mobile but could not get it to be selectable when trying to add to a mobile workspace. (is there a step I’m missing here, or is this screen not supported on mobile?) With the browser interface, they can use column filters to select only the sales order and only the work centers they need, but they would still have to individually select all the lines to clock into -- there should be a “select all” option

Hi everyone,I'm looking for guidance on syncing color information from Acumatica to Shopify using the native Shopify Connector on 2026 R1.The requirementIn Acumatica, product color is stored as a descriptive name. On the Shopify side we're populating a Color metafield, which expects a hexadecimal value rather than the name:Black → #000000 White → #FFFFFF Smoke → #808080 Dark Smoke → #4A4A4AWhat I've triedCreated a Substitution List mapping the Acumatica color names to their hex values, and referenced it in the Shopify Entity Mapping. The substitution was not applied and no hex value was exported. Changed the Acumatica color field to store the hex value directly (for example, #000000) and re-synced the product. The Shopify color metafield still was not populated. Tried the following expression in the entity mapping: =SubstituteListed([shopify.color-pattern], 'Metacolor') — the expression editor returns an error that the function is undefined.My questionsIs there a supported way to trans

 Hi Everyone,I'm facing an issue with barcode scanning in Acumatica 2026 R1 and would appreciate any guidance.I have created a report that prints a Code128 barcode using the standard PictureBox barcode control.Current barcode settings:Source: Barcode Barcode Type: Code128 Value: =Trim([INLocation.LocationCD]) (also tested with LocationID) BarHeight: 1000 BarWidth: 10 WidthRatio: 3The barcode prints correctly and the human-readable text is displayed below it.However, when I try to scan the printed barcode using the Acumatica Mobile App, nothing happens—the app does not detect the barcode at all.To isolate the issue, I generated the same barcode using the TEC-IT online barcode generator with the same value (e.g., PACKING-AR), and the Acumatica Mobile App scans it successfully. This suggests the mobile app is working correctly and the issue is related to the barcode generated by the report.Has anyone experienced a similar issue?

Hi, How to delete UnAssigned Locations lines in Inventory Summary. In Inventory Summary data is not saving through direct tables.Can anyone Suggest me how to delete UnAssigned Location from Inventory Summary.Thanks,Giri.

Does Acumatica have a solution for tracking price/compare at price from Shopify on an order level?There are a number of reasons to use the ‘Compare At’ price function in Shopify. They can be utilized in more complex promos to avoid Shopify’s limited discount ‘slots’. They also offer a better customer experience with slashed pricing, an immediate view on the actual sales price, and no requirement to remember a code. The problem with this is that Acumatica is just receiving the price as compare at price so it doesn't look as if it has been discounted. E.g.Product X has a normal price of $50We use Shopify compare at functionality so that this now has an 'Is' price of $40 and a 'Was' price of $50 (which will shown a slashed pricing on the storefront).When this comes in to Acumatica the line item just shows a pricing of $40 but we want to be able to track the fact that this actually represents a $10 discount The compare at pricing isn't available through normal order JSON but is accessible