Discussion Forums

When I try to release an issue (IN302000), I get PXLockViolationException error:Question: does the tstamp in each ARTran row in the database need to match the PXCache somehow?  Which object in the cache do I need to look for?

I'm facing an issue with Acumatica 2026 R1 (Build 26.100.0175) while implementing hyperlink navigation in a custom Modern UI screen.ScenarioI have a custom screen generated using the Modern UI Generator. The OrderNbr column is displayed as a hyperlink using @linkCommand. @linkCommand("OrderSO")@columnConfig({    width: 250})OrderNbr: PXFieldState<PXFieldOptions.CommitChanges>; public PXAction<TSSOHistoricalData> OrderSO;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Order SO",    MapEnableRights = PXCacheRights.Select,    MapViewRights = PXCacheRights.Select,    Visible = false)]protected virtual IEnumerable orderSO(PXAdapter adapter){    Dictionary<string, string> parameters = new Dictionary<string, string>    {        { "OrderNbr", DetailsView.Current.OrderNbr }    };    throw new PXRedirectToGIRequiredException("OrderSOGITest", parameters)    {        Mode = PXBaseRedirectException.WindowMode.Layer    };}works fine in Classic UI facing issue in Mod

I’m getting this error when attempting to export a GI to an excel file using the Excel export button.  Any idea how to avoid getting this error AND get my Excel file?

Hello Everyone, so I want to release the Translation Worksheet and there is an error“Inserting 'GL Transaction' record raised at least one error. Please review the errors. The currency assigned to the denominated GL account (112001) is different from the transaction currency”. I know the error because I set the currency on Chart of Account (COA) because the COA was uses to set up Cash Account. The Chart of Accounts (COA) entry we configured for the Cash Account requires a currency setting; is there a way to set up a cash account without specifying a currency?So we can remove the currency in the COA?Please help me to solve this, I have been explored and try to create use AMR for the reporting, but it doesn’t work because when entering the formula, I can't directly pull the rate from Currencies Rate.Our Base Currency is IDR and we want to Conversion to USD.If you guys have any suggestion or advice, that would be very useful, I really appreciate you kindness. Thank you. 

I have a working import scenario that imports purchase receipt, but when there are multiple receipts for the same PO line number with different lot numbers then only the last receipt for that line is imported.Any ideas? 

Good,The issue is that when you create a quote with the same item number, say three times with different costs and then create the project the items are aggregated on one line.  (Operations has set a reduction protocol that reduces the the rate based on the amount of tools runs; 1st run at full price, 2nd run at half off, etc.)  I know I can make additional items numbers based on the protocol or make a discount code based on the rate.  We have over 10 different types of tools. The quote is provided to the customer based on the number runs.  This might change when the project begins either adding of deleting some. Questions,  How do I make the conversion to quote keep all the duplicate items on separate lines?  I don’t want them to aggregate.  Is this a billing rule?  Or Allocation update.  I am sort at a loss who to make Project Quote to Project conversion keep the lines separate without aggregating them.Thank you for your assistance.Evan

 I'd like to know why I'm getting this error, since I've only run the following commands:*npm run getmodules*npm run build-devand when I tried to compile my screen with the following command:npm run build-dev --- --env customFolder=development screenIds=AR303020, it showed an error in the tsconfig.json file.Can you guide me on how to fix this? Thanks in advance. This is my version of ts 

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! If you’re interested in participating, please complete this short qualification questionnaire.  This will allow us to consider you for the program. We will review your submission and get back to you within 5 business days to confirm your qualification. Improve 

Has anyone had any success in updating product availability to Amazon for multi locations? For example we have an East and West coast warehouse. We have Amazon setup with these two locations and specific shipping templates. However we have been unsuccessful in updating inventory in Amazon from Acumatica to account what is in each location accordingly. Amazon telling us this can be done, but no one seeks to know how in Acumatica

Is it possible to override the default WIP account in a production order when using a labor transaction? I need to hit a COGS for shop labor GL and not a manufactured products/material GL account. Reason being, the GL account for labor is in the account group for a labor line in the project cost budget. The default WIP is linked to the the materials line item in the cost budget. So I am having to post an extra project transaction that reclasses from materials line to labor. I would like to avoid this if possible. If there is a better way to get hours/dollars into production orders and accomplish the same, I’m open to that as well. I feel like it shouldn’t be this hard and I’m fighting the system. 

The fiscal year starts in June, set up correctly in the Master Financial Calendar. But @YearStart in GI/dashboard filters still resolves to 01/01, not the fiscal year start  it seems tied to calendar year, not the Master Financial Calendar.@PeriodStart/@QuarterStart seem to respect the fiscal calendar fine  just no fiscal-year equivalent.Is there a supported macro for this, or is filtering on GLTran.FinPeriodID (e.g. Period 01 of current FY) the recommended workaround?

Hi AllI’m setting up Employee Timecars & I want users to Enter their AL (Annual Leave)However I don’t want the AL Earning Type to be associated with a Labor Item. Hence I’m runing into this error.Is there a way around this.  

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  

Hey all,Having an issue relating to the Roles of Relations attached to records. I have a customization that adds the custom set we’d like to use, but am unable to remove the default set, even when setting them as inactive in the customization project. I thought it might be due to some superseding project, so I looked and did find a single one above it, but even inactivating one option there and publishing did not remove any options. I was trying to stick to the low/no code options for simplicity since there explicitly is an option, but no dice. Any options to try?The only other thread I saw with the same issue was just due to not publishing, but these definitely have been. Published customization options: Result:  

Since the upgrade to 2026R1, if you view the ERP via http (some functionality isn’t available in the app, such as SO copying, etc), the decimal is now missing (used to show up next to the zero) from the numeric keyboard to enter cents into the field.  This makes the web interface difficult for any currency transactions the aren’t whole numbers.  There is a workaround in that you can enter a number into the field and when you leave the field it will add the decimalization to the whole number (.00) (to make 1 into 1.00) and then you can use your finger to go back into it to edit the cents and/or remove the whole number.  Hoping this is fixed in an update! 

Hi, in AR Clerk default dashboard, there is a DSO (Days Sales Outstanding). Its purpose is to understand how long it takes in average for customers pay their outstanding.On the other side, there is a default AP Clerk dashboard but I can’t find its equivalent which should be the DPO (Days Payables Outstanding). I understand AR Clerk displays something actionable, but it would be good to maintain good vendor relationship as well by understanding how long in average does it take to pay the suppliers. Has anyone built a GI for this? I am unable to find the equivalent/appropriate tables for this. Thank you in advance!

We are using Acumatica 2025 R2 and the contract-based REST API.We created a custom endpoint exposing:Shipment → ShipmentDetail → AllocationsWe need to split one component of a non-stock kit across two warehouse locations while keeping everything on one shipment line.Example:Shipment line: KIT-001, Shipped Qty. 2 COMPONENT-A requirement: 4 units at BIN-A COMPONENT-B requirement: 2 units at BIN-BDesired result:COMPONENT-A: 2 units at BIN-A and 2 units at BIN-C COMPONENT-B: 2 units at BIN-B, either as one allocation or two allocations of 1 each Kit shipment line remains at Shipped Qty. 2The equivalent operation works manually on the Shipments screen.Non-kit control testUsing the custom endpoint, we successfully split a regular stock-item shipment line by:Reducing the existing allocation quantity. Inserting a second allocation. Updating the newly assigned SplitLineNbr to the desired location in a second PUT.The request uses:PUT /entity/WMS/24.200.001/Shipment?$expand=ShipmentDetail/Allocat

The PO receipt screen used to show the $ of the receipt so our purchaser could verify both $ and qty.  Now only the qty is there.  Why was the $ removed and can it be included again?

Hi, I created a GI to show approval maps (XML attached). How do I set the sorting of Steps and Rules in ascending? Note that sorting of Rule description to ‘ascending’ won’t work. Also, how do I show the Entity and Field name from schema instead of DAC name?Approval Maps Steps and RulesShowing DAC name instead of SchemaSchema name 

Hello,We recently encountered an issue where production order variances are being attributed to the incorrect branch. Our current set up is a two tenant, two branch instance.Our production orders for both sites are manually closed by a site admin, who has a profile at one branch but not both. In this case, the work order variances are being attributed to the branch the site admin’s profile belongs to. I’ve checked the warehouse profile and there are no GL accounts populated at all throughout the list. I guess the question is, will the user’s profile who is manually closing the orders play a role in determining what branch the variances are posted to? Especially if the warehouse profile GL accounts aren’t set up. 

Wrapping up Chart-of-Accounts design on a 2026 R1 build (clean-slate migration off a legacy ERP whose chart had grown past 400 accounts) and would like outside eyes on the overall shape before we lock the sub-account segment layout — that part is effectively set-once (segments can be appended later but not removed, reordered, or shortened). Company profile: single CAD legal entity, USD as a meaningful secondary transaction currency, ~15–20 ERP users, business mix of distribution + light assembly + full manufacturing across roughly 7–8 product families. Chart: 55 GL accounts total (roughly 14 Asset / 9 Liability / 4 Equity / 2 Revenue / 10 COGS / 8 Operating Expense / 7 Other Income-Expense / 1 Income Tax). Design philosophy throughout: push repeatable detail into a sub-account dimension or the relevant sub-ledger module rather than adding GL accounts — e.g. Fixed Asset CCA classes live in the FA module per-asset rather than as separate GL lines; product-family detail on COGS/Revenue li

Hi All, we have an old setup of 20231R1 which is highly customised with lots of GI’s, business events  and APIs and due to our heavy usage we have a lot of performance issues and bugs.  Recently we have decided with the help from MYOB Support to upgrade in the coming months straight from 2023R1 to 2026R1 sequentially.  My concern here is, how can I make sure each of our customisation will work and not break.  Or has anyone done this and face any major dramas between the  version which they then had to change their customisation?  One thing I have already pickup is the API authentication protocol between the two version is big reduced as 2026R1 does not support URL encoded anymore.

Hello everyone, so one of my clients they have transactions using other currency. We already set up module currency management, rate transaction, etc, but why there is no menu for Financials Statement or budget report using other currency. Do we need to add customization report in Acumatica to display the menu?Our base currency is IDR and the other currency we want to added for the report is USD.Please help me to solve this, I really appreciate, thank you. 

I did have an import scenario that worked and then the upgrade to 2026 R1 appears to have broken it. 

26R1 25R2  Does anyone else also have this issue, I can’t export/import approval maps in 26R1