Solved

Hi  I am looking for a suggestion to include backorder items in the shipment confirmation report, Any suggestions?

I am currently working on an integration where I need to extract data from various tables in Acumatica. Right now, my process heavily relies on using OData via Generic Inquiries (GIs) or configuring Contract-Based REST API Endpoints.While this works, it is becoming very inconvenient and hard to maintain. Every time there is a new requirement to get data from a new table, I have to go back into Acumatica, create a new GI (or add the table to an existing one), expose it, and publish the project.I am looking for a much more dynamic approach.My ideal scenario is to have a single API setup where I can just pass the target Table Name (e.g., SOOrder or InventoryItem) and the Fields I want to retrieve as parameters in the request, and have Acumatica return the data. I want to build/configure it just once and use it universally for any table in the future.Has anyone encountered this requirement before? Is there any alternative approach, hidden feature, or a more dynamic solution to achieve this

Hi everyone!I’m trying to apply this patch 26.100.0175-2 but after begining the Starting UI compilation, this error comes up: [16:55:41 INF] Starting UI compilation[16:58:04 ERR] build failed with exit code 2 in C:\Program Files\Acumatica ERP\Demo26R1\FrontendSources\screen[16:58:04 ERR] build stderr:[webpack-cli] Failed to load 'C:\Program Files\Acumatica ERP\Demo26R1\FrontendSources\screen\webpack.config.ts' config[webpack-cli] webpack.config.ts(24,8): error TS2307: Cannot find module 'build-tools' or its corresponding type declarations.webpack.config.ts(28,8): error TS2307: Cannot find module 'build-tools/logger' or its corresponding type declarations.webpack.config.ts(31,8): error TS2307: Cannot find module 'transformers/logger' or its corresponding type declarations.webpack.config.ts(34,31): error TS2307: Cannot find module 'transformers/constants' or its corresponding type declarations.I ran the get npm run getmodules and it created the build-tools folder inside the FrontendSourc

Hi, please help me fix my import scenario in AR Import Invoice, I need it to work to be able to upload with multiple lines or inventory id.Here is my import scenarios XML.

I’m looking for cause or explanation on why DeviceHub would duplicated a print job The system is set to poll every 30 seconds and yet it finds the same document at 8:20:38 and 8:20:45 and processes both   

Which web service end point should I access in order to do a Move transaction?Move Entry seems to be incorrect? 

We recently purchased DRP (not MRP). We buy items in nested sets from our vendors. We need the individual items out of the nested set (disassembly), not the other way around. For example, if Item A is out of stock, we need to buy a nested set that contains Items A, B, and C. When we receive the nested set, we do a disassembly to break it into the individual items. We've already explored setting Source = Kit Assembly on the individual items, but that plans an assembly — consuming components to build the kit — which is the opposite of what we need. We need DRP to recognize that our individual items come FROM disassembling a purchased kit, not the other way around. Is there a way to handle this in DRP? How are others managing nested sets or bundled imports that get broken down for individual sale?

Hi guys, I just can’t figure out the issue. I follow the guide to set up the self-service portal. The user can’t checkout because of the buttons can’t click. I checked every steps and access rights. Anyone give me a hit? Thank you.   

What am I doing wrong here? I have an inquiry screen with custom grid row colors depending on Production Order Status. The style is being applied, but there is no more slight color change to indicate the current focus/selected row/cell. See the GIFs. With GetRowCss custom highlighting Without custom highlighting import { Messages as SysMessages } from "client-controls/services/messages";import { createCollection, createSingle, PXScreen, graphInfo, PXPageLoadBehavior, handleEvent, CustomEventType, RowCssHandlerArgs, CellCssHandlerArgs } from "client-controls";import { SWProdPlannerLineFilter, SWProdPlannerLineView } from "./views";@graphInfo({ graphType: "PVBMFGCustomizations.SWProdPlannerInq", primaryView: "Filter", pageLoadBehavior: PXPageLoadBehavior.PopulateSavedValues })export class SW401010 extends PXScreen { Filter = createSingle(SWProdPlannerLineFilter); Details = createCollection(SWProdPlannerLineView); @handleEvent(CustomEventType.GetRowCss, { view: 'Details'}) getDetailsRowC

Hi all,We have a custom Customer Portal screen with a toolbar button we want to style green, like a workflow primary action button (e.g. "Release"). Has anyone found a way to achieve this on a portal screen? Thanks!

I am new to Service Management, so thanks a lot whoever can help Tried to create an appointment to replace a component which is Serial Tracked. The setup for tracking requires to manually input the serial number on Usage.However, when i try to complete the appointment, the system is generating an error due to the fact that it requires the Serial Number. Tried to key it on the appointment, but the system is telling me Serial number is not found and won’t let me to continue.How should i record such instance? ThanksAngelo

We are trying to create a Material Return transaction through the Manufacturing REST API for a non-tracked inventory item and split the returned quantity into multiple Line Details records because each split line has a different custom Reason Code.The inventory item is NOT lot/serial tracked.Expected BehaviorWe want the Material Return transaction to create:Main Line:Quantity = -3.00Line Details / Allocations:Qty = 2.00 → ReasonCode = BALWOFF Qty = 1.00 → ReasonCode = CRWOFFSo the total allocated quantity should equal the document quantity (-3.00) without creating any additional allocation lines.Current ProblemWhen we send the payload below, Acumatica creates:the two intended split lines PLUS an extra allocation line with quantity = 3.00As a result:Total allocation quantity becomes incorrect An unwanted extra split line is created in Line DetailsScreenshot attached for reference.Current Payload{ "Hold": { "value": true }, "Details": [ { "ProductionNbr": {

I’m working on an Acumatica-based solution (via a vertical solution provider) for a fuels distribution business and am looking for guidance on how others are handling Weighted Average Cost (WAC) in scenarios where the true cost of inventory goes beyond just the base purchase price. Business Context:In our current system, WAC represents full landed cost, including:Supplier invoice cost (fuel) Vendor-charged taxes and regulatory fees Internal freight (marine, line haul, inter-terminal transfers) Allocations applied as fuel moves through the supply chain This cost structure is critical for:Inventory valuation Margin reporting Financial/audit alignment Challenge in Acumatica:From what we’ve seen so far, WAC appears to only reflect the base item cost at receipt, and additional costs (freight, taxes, etc.) are not automatically incorporated into the inventory cost in a way that recalculates WAC. Questions:1. How are others incorporating additional landed costs (freight, fees, taxes) into WAC

I am running into a scenario where I could really use the ability to segment approvals by a particular subaccount segment. 6 years ago Acumatica marked this idea as ‘unlikely’ to implement’. (see: “Approval maps: when subaccount is used as a condition, allow user to specify a segment value, not just the whole subaccount.”)I tried masking the segments with question marks and blanks, but the bill wouldn’t read either one. ‘???-???-100’ and  ‘   -   -100’To accomplish what I need to do, I would have to hardcode almost 75 different subaccounts into the conditions. (will import, but still - not very nice for long term maintenance).Is there a limit to the number of conditions in a particular rule of an approval map? 

Is there a way to select a template and change the default selection from before email body to after email body?

Hi all. I have  public abstract class PMProjectMaterialsLineSplittingExtension<TGraph, TPrimary> : LineSplittingExtension<TGraph, TPrimary, PMProjectMaterials, PMProjectMaterialsSplit>     where TGraph : PXGraph     where TPrimary : class, IBqlTable, new() public override void Initialize(){    base.Initialize();    Base.RowSelected.AddAbstractHandler<TPrimary>(EventHandler);    Base.RowUpdated.AddAbstractHandler<TPrimary>(EventHandler); PXCacheRights.Select);}When this Base.RowUpdated.AddAbstractHandler<TPrimary>(EventHandler); executed i have null reference exeption. I search code and find that proxy.InterceptedDelegate = null but default acumatica code try this:proxy.InterceptedDelegate.GetInvocationList().I use PMProjectMaterialsLineSplittingExtension for ProjectEntry. public class LineSplittingExtension : PMProjectMaterialsLineSplittingExtension<ProjectEntry, PMProject> { }I save that ProjectEntry not have RowUpdated method for PMProject. I think

Hi Acumatica Community,In Classic UI (ASPX), we can hide a field label using:SuppressLabel="True"For example, in the Sales Order screen, we have a field where only the value should be visible and the display name/label should be hidden.How can we achieve the same behavior in Modern UI (HTML/TypeScript customization)?Could someone provide solution

When I click a particular Payment on the Checks and Payments screen, then go to the AP Payment Register report, then click the Send button, I would like to have a simple email template which populates data from the AP Payment Register report. Specifically, I would like to use the Vendor Name and Email Address and the Amount. I would also like the User’s Name in the email signature.I have tried two things.I created an email template based on the Checks and Payments screen and specified that in the AP Payment Register Report Designer. But none of the Data Fields I select in the email template work. The AP Payment Register Report screen does not appear to be available for the basis of an email template. Next, I scrapped the email template idea and tried to enter the email in the Report Designer Mail Settings fields. The problems here include not finding the Vendor Email Address and not being able to create the email Body with the line breaks and formatting desired.The email template optio

Been struggling for a couple days to create a GI to extract Cash Receipts and Cash payments for projects.  Question is:"In Acumatica 25R1   I am building a Generic Inquiry joining PMProject, ARPayment, APPayment, PMTran and PRPayment. Getting error: Conversion failed when converting nvarchar value 'X' to data type int. Join is PMProject.ContractCD = ARPayment.ContractCD. What is the correct join field?"

Hi Acumatica Community,I created an Import scenario for 1-Step Transfer but encountered an error.is there a mapping that I need to include to proceed?Thank you!

Hello! Is it possible to still mass process orders that were on backorder status but now have enough qty for shipments? Currently, ‘process order’ screen is used to mass create shipments for orders in the system. Shipping rule is to allow back order, so when items have insufficient qty, those orders go on back order status. The issue is when those items are restocked, and now have qty for shipments to be created, users have to go find these orders individually in the system and create shipment. It would be nice if these backorder status orders could also show up in the process order screen so users can mass process all the orders that are in backorder status but now have enough qty. Any thoughts? Thank you!

When calculating the amount of daily bank funds transfers, sometimes mistakes are made.  The most easy fix would be to reverse the entire entry and start over.  However, Acumatica will not allow us to reverse a funds transfer entry.  Here is the error message:In the G/L #1001 is designated as a Cash Account as we use it for cash clearing.  Appreciate any ideas about what is stopping even our Admin from reversing a funds transfer.We only have 1 branch within Acumatica.

California has implemented a new waste recycling fee for Covered Battery-Embedded products (CBE waste recycling fee). We are required to collect the CBE waste recycling fee from your customers upon the purchase of a new or refurbished CBE product. The fee is 1.5 percent of the retail sales price for each CBE product sold or leased for use in California and should not exceed $15 per product.Additionally, the fee must be listed as a separate line item on the receipt and cannot be included in the sales tax calculation.Our VAR has recommended an approach but I imagine this would apply to a large number of Acumatica customers. How are others handling this? If it’s helpful, we use Avalara as our tax provider and will shortly upgrade to 2026R1.

Is there a way to have audit tracking on when changes are made to the Enable/Disable Features screen? I think this is important for proper tracking and error checking, in the event there are any bugs that come up.

I’m currently testing exporting Customers from Acumatica to Shopify (as Companies for B2B) and had a couple of questions:Is there a way to have the Company ID in Shopify match the Customer ID from Acumatica? Ideally, I’d like to keep them aligned for easier tracking and reconciliation. I enabled “Import Company Contacts as Customers” along with bidirectional sync. This successfully creates customers in Acumatica when they’re assigned to company locations in Shopify.However, I’m running into an issue with phone numbers:Shopify always includes the country code (e.g., +1) Acumatica’s phone input mask doesn’t accept this format This results in an error during import: “Object reference not set to an instance of an object”Has anyone dealt with this before?