Discussion Forums

My company is needing to mass create sales orders with the CM type. We have a tax customization that throws an error unless I over ride the tax zone from “TAXABLE” to Null (or blank)My current import scenario only completes this for every other record.  Attached is the XML.The only other possible work around I can think of is, is there a setting that will make all CMs “null” for the tax zone by default?

Mid-market Commercial Construction company new to Acumatica - Live 1/1/25.  1 Entity with 7 Branches.  We are struggling a bit in learning Acumatica and recovering some operating efficiencies, particularly in project accounting - budgeting - subcontracting workflows- and accounts payable management.  Interested in a connection-conversation with a construction company a little further down the road using Acumatica Construction Edition happily and successfuly to manage project finance, or those who have been down our path and done something different for project accounting (Procore Integration?)

Can’t delete a sub account. Can’t figure out where to find the rest of them so i can delete them.  2/3/2022 6:54:58 PM Warning at ParentDeletingHandler.cs:159:RaiseConstaintViolationException():Subaccount (00  -   -) cannot be deleted because it is referenced in multiple tables. 1: Currency (USD) - Foreign key Currency(aRProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 2: Currency (USD) - Foreign key Currency(aPProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 3: Location (118, MAIN) - Foreign key Location(cSalesSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 4: Location (118, MAIN) - Foreign key Location(cDiscountSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 5: Location (118, MAIN) - Foreign key Location(cRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 

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 Taha Yab Ali - Acumatica Community Featured Member for May 2025Meet Taha Yab Ali our Acumatica Community Featured Member for May 2025. It’s great to have you as part of the Acumatica Community ​@tahayabali! Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumatica User Group, NorCal Acumatica User Group Request to join today!All Acumatica User Groups How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds,

(Obviously) this is a test order from our sandbox tenant.  We’re trying to come to grips with the process here, but we are stuck.  This order at “Released” status, but the ellipsis menu is pretty much all greyed out, and we can’t add a labor transaction.  Can you help us solve the mystery?  

Before I recreate the wheel, does anyone have anything like this?We have a lot of variables in our product lines.  When customers request a new Length/Width/Material/etc we have to create a new Stock Item, Build a BOM, etc.Right now, we have ~5 spreadsheets with our product lines that have to be maintained to provide a quote for the customer.  This is also sent to the Product Manager to build the Item and BOM.I want to build a New Item page that would have variables depending on Product Type, in which certain dropdowns would be available or options in those dropdowns would be selectable.  Based on those parameters selected, it could build the Inventory Item, BOM, and provide a more accurate Quote. 

I created a user defined field [Location.AttributeCHILDACCT] that is of type String ( nvarchar)In my generic inquiry if [Location.AttributeCHILDACCT] is blank then I want it to pull in the Project Customer [PMProject.CustomerID] otherwise I want it to pull the string in [Location.AttributeCHILDACCT]Here is my formula: =iif(([Location.AttributeCHILDACCT]=' '),[PMProject.CustomerID],[Location.AttributeCHILDACCT]) I keep getting the error message below.  The C002452 is the [Location.AttributeCHILDACCT] field. The issue is definitely with my condition in the iif statement. Are you able to set a string to a condition of blank in a GI?  I think I just don’t have the correct syntax for the empty condition.  

Hello,  Does anyone know how to convert a decimal values to inches in report designer?Example: Customer orders 12.50 feet in ACU on the sales order screen but want the value displayed on the report as 12ft 6inches.  Thanks

We use Acumatica in retail, receiving inventory and matching bills later to receipts. How to reconcile balance at the end of the month of clearing account to Balance Sheet? I cannot see any generic reports that will allow me to do that. Any ideas? 

Hello Everyone, Please advise on how to hide the list of other tenants from the customer portal login screen?Thank you,Jennifer

Hello! I am trying to use an input mask to allow for numerical entry only where the number has two decimal places. For instance, we manufacture parts that have dimensions such as 68.50” and 82.25”. I tried using the input masks ##.##” and 90.99” on the attribute itself but when I enter the values above I get the following results:68.50” → 68._5”82.25” → 82._2”. I had figured out that we could use something such as 90.99#” but it then returns values as: 82.25” → 82._25” This isn’t ideal and could get confusing. Is there anyway to force a number right after the decimal?Also, I believe I found a bug in the system when it comes to these input masks. Using the 90.99#” input mask above, it registers the number but every time I click on the attribute and click off it reduces the number and adds a space. Thank you!

If you all have any good tried and true examples for Customer Statement forms in Acumatica please post them here. We are a pool company who does Sales, Field Service, Equipment Service Contracts, and Projects (New Pools and Renovations). Our Customers are constantly complaining about our Statement Form. We are currently using a modified version of the “Open Item” Customer Statement. We want to be able to show a clear snapshot of everything that occurred for a Customer on one form. Both for the Month and a specified period of time. Any suggestions?

Hi, I am adding a few custom fields to ARInvoice and ARPayment. How can I prevent these fields from being picked up in the copy/paste functionality? I tried redefining the data view in a graph extension with a new PXCopyPasteHiddenFields attribute, but it did not work.

I created a generic inquiry that pulls data from the Purchase order module. I pull that data into excel and use with an import scenario to create records in the equipment module.Now that the report is created and import scenario is mapped and setup, I would like to have another dept at the company do the import monthly but I am concerned about giving them full access to the import scenarios.  Is there a way to limit access so they can run this one scenario but not have access to others?

We had an invoice 400.94 and our customer paid 400.95 what is the best way to correct this in our system? Do we create a credit memo on the invoice or can we do a -.01 in the write off amount?

I have a mobile App that has a custom action which will redirect to an external Web Page.It was working a week ago. The customer was playing with creating their own customization, and mucked things up and asked our admin to restore a snapshot. When they did this, the customization that calls the external web site stopped working.I cannot figure out why.The call to the Redirect is: // Everything is gathered up. Time to send it var redirectException = new PXRedirectToUrlException(fullURL, PXBaseRedirectException.WindowMode.NewWindow, "This is a Message, which gets ignored in this case", false); throw redirectException; // call URLThis works when run from the browser. However, not from the mobile device.In the Customization, this action is defined like this:update screen FS300200 { update container "AppointmentRecords" { add recordAction "ASGExtForms" { behavior = v

We are planning to introduce a custom frame order for our Online store on Shopify. The customers will pick the pre-configured sizes for their custom orders. Right now, our staff will create a custom Sales Order in Acumatica then create a Production Order. Wondering if it's possible for the custom orders to be auto create as Production Orders once they have synced to Acumatica? 

A custom field was added to AMProdItem and am trying to update via import scenario, but I only see a handful of field on the table. Is my syntax wrong or does it need to be exposed via another method? 

Does Acumatica or any partner have documented best practices for managing the publishing of customizations that can be shared with me?  I am looking for a customer facing document to explain the need for discipline and coordination where customizations are created by multiple sources. Edit, I did find this blog post https://www.augforums.com/publishing-an-acumatica-customization-project/.  However, may main point is that I need to reinforce rule #2.

Today all our PUT requests regarding Appointments seem to have stopped working via the REST API.  We’re using a custom endpoint.  Has anybody seen an error like this before?  We are a bit stuck, as all the endpoints were previously working."message": "An error has occurred.","exceptionMessage": "Sequence contains more than one matching element","exceptionType": "System.InvalidOperationException","stackTrace": at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)at PX.Api.ContractBased.EntityExportContextBuilder.GetDescriptorKeys(EntityImpl entity, String baseMappingKey, Boolean includeNulls) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityExportContextBuilder.cs:line 2064at PX.Api.ContractBased.EntityExportContextBuilder.TryDetermineDescriptorFromValues(EntityImpl entity, String baseMappingKey, EntityDescriptor& entityDescriptor, Boolean includeNulls) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityExportContextBuil

I have a custom field UsrLotNumber in the POLine table.  I want to update that field to the PO Number.  Please don’t ask why the customer wants to do this…The issue is that the PO Number is “<NEW>” until after you save the PO.I put code in the RowPersisting handler of the POLine table.However, the OrderNbr field is “<NEW>” at this point.  I tried putting the code in the POOrder rowpersisting, but it still doesn’t save to the DB.This is my POOrderRowPersisting code.  It shows the value in the grid after saving, but no update to the DB.protected void POOrder_RowPersisting(PXCache cache, PXRowPersistingEventArgs e){ var row = (POOrder)e.Row; foreach (POLine line in Base.Transactions.Select()) { BSPOLineExt ext = line.GetExtension<BSPOLineExt>(); if (ext == null) return; InventoryItem inventory = SelectFrom<InventoryItem>.Where<InventoryItem.inventoryID.IsEqual<@P.AsInt>>.View.Select(Base, line.InventoryID); if (inventory == null) return; INLotSerCl

Hi We would like to know how to business manages with Blank PO,  Essentially we would like to have a lean process of which everyone goes througe a request process, and then it is the purchasing department that manages the rest. In certain cases, there are blank PO that are arranged with certain supplyers. What i would like to know is from the request, is there a way to link that request line to a blank PO Line, to it would deduct the total quantityfrom the blank PO. The inly way i have found for now is that from the request, i would have a quantity with a price of 1$. We thansform the request to a purchase requsition, and then a purchase order. From that order, we put the item price at 0 so there is no cost involved in that line transaction, and then in the same PO, in add the blank PO Line, and input the same quantity as the Request line, but at a 1$ unit price. This gives me the final amount identical from the request, and the “infant” PO is still attached to the request (so i have a

Hello! We have created few customers, and we have created transactions against these customers as well. But now we are required to establish these customer IDs as companies. We want to have the same ID for both Customer, Company and in created transactions. Is there any way of doing this? Best Regards Amanda

Hi everyone,I'm working on a customer invoice import scenario, and I’d like to know if it’s possible to use the "InvoiceNbr" field as a unique key to identify invoices.At the same time, I would like to keep the automatic numbering for the RefNbr field, and use InvoiceNbr to detect duplicates too.Ideally, if an invoice with the same InvoiceNbr already exists in the system, the import scenario should raise an error and prevent the duplicate from being imported.how can it be configured?

RS201000.ts codes:import {    PXScreen, graphInfo, createCollection,    PXView,PXFieldState,    gridConfig,PXFieldOptions,GridPreset } from "client-controls"; @gridConfig({    preset:GridPreset.Primary})export class RSSVRepairService extends PXView{    ServiceCD : PXFieldState;    Description : PXFieldState;    Active : PXFieldState;    WalkInService : PXFieldState<PXFieldOptions.CommitChanges>;    Prepayment : PXFieldState;    PreliminaryCheck : PXFieldState<PXFieldOptions.CommitChanges>;} @graphInfo({    graphType:"PhoneRepairShop.RSSVRepairServiceMaint",    primaryView:"RepairService",    hideFilesIndicator:true,    hideNotesIndicator:true})export class RS201000 extends PXScreen{    RepairService=createCollection(RSSVRepairService)}RS201000.html Codes:<template>    <qp-grid id="grid-RepairService" view-bind="RepairService"></qp-grid></template>