Discussion Forums

Hi,Client have updated the Acumatica Non-stock Item master weights for some ittems (They are only doing the Drop-Shipping) and seeking a solution to update the weights in some documents (Ex: Sales Orders, etc) which are created before the weight update. Someone kindly advise in this regard. 

Meet Samvel Petrosov our Acumatica Community Featured Member for April 2025. It’s great to have you as part of the Acumatica Community ​​@Samvel Petrosov!Hi everyone! I’m Samvel Petrosov, Senior Analyst at Information Integration Group, Inc. I have been with IIG for almost 10 years now. I started as a developer and got recognized as developer MVP since 2019. Currently, I still have some development projects, but most of the time I am working on system implementations and custom solutions design.I enjoy solving complicated cases and finding solutions to everyday challenges coming with the variety of projects.On a more personal note, I live in Glendale, CA with my wife and our frenchie “Lady”.I enjoy playing chess and recently started looking into golf.We love traveling and recently came back from Cairo, Egypt. 

How can we setup a different description that would appear on customer-facing forms (sales orders, invoices, etc.)? We have some stock items that have slightly different configurations but we would like them to have the same description on a SO or invoice. We do however need the additional detail for our team to be able to differentiate which stock item we are putting on the transaction. 

I am trying to create process for users here to use Activity Tasks for order/quote follow up.  I keep getting an error stating  Custom Week cannot be found. Custom Week's must be generated with date greater than 4/24/2025.  What am I doing wrong? 

HI, I am trying to add total of each colum at the end of the report. But report is just populating 0 instead of sum of all values. Can any one give me idea on how to add it? I use variable of total end qty. But its nor working. Even its repeating again and again for every row. I have attached the report 

Hi,I've been using Acumatica for a year, and I still don't understand if the system will look for the .rpx or .ca.rpx report, or a mixture of the two. The sitemap always points to the .rpx but I see that "often" I have to make my changes on the .ca.rpx in order to see them.In the actual case I want to modify the report from site map AR64100 which point in the sitemap on ~/Frames/ReportLauncher.aspx?ID=AR641000.rpx so logically, i need to customize the .RPX but it seems to use .CA.RPX . I’m confused.I found very little documentation on this topic.Can anyone explain to me how it works?THANKS

Hello,Is there a way to have the production order you create via the MRP display screen automatically linked to the sales order creating the demand?Or is it required that you manually create the linkage?Thanks,Larry

i did a customization to my training tenant.  but after publish it,some how it looks like it have affect our live tenant.how do i resolve this 

Hello all,I am wondering aside from the lengthy guid kind of value that is assigned to ExpenseRefNbr when an Expense Receipt is created though the Bank Feed, does Acumatica keeps any other reference to other tables to differentiate Expense Receipts created manually from those through the Bank Feed?

Hello All,I have a multi-step approval map set up. With the first layer as a lab tech. They submit the requisition and their manager approves it, it then goes to the Lab Manager who then approves it. The last step is to go to our purchasing department where the PO is set up. I don’t think I’m understanding how everything is supposed to work at each step.Step one → Goes to manager (set up as Next step, always)Step Two → Goes to the lab manager (Next Step, always)Step Three → Goes to Purchasing ( Approve Document, Always)So should each step have an approve button? Or, will it step through the process? Right now, the first manager can approve, the second manager approves bidding, and then Purchasing sets up the PO. I want to make sure this is all correct prior to moving forward.  Brent

Hi everyone, I’ve always struggled with how to pull two address types into a single GI, and right now I really need it. The GI I’m working on needs the Default Address (or shipping address) and the Billing Address info. Attached is an XML from my test environment. The problem I’m having is either no Billing Address info pulls through, or it pulls the same address as default. If I change Billing Address on customer it doesn’t show in the GI. Would really appreciate the help!

We have an issue where we will receive more of an item than what’s on the PO, however we don’t want our receiving team to be able add that to the receipt.Is there a way to prevent adding items or QTY that’s not on the PO? 

Hello, I have a customisation which is already published on one tenant and I would like to publish it to other tenants. The customisation contains files, sql scripts, generic inquires and site maps, and if I install on the current tenant I understand that:Files (such as dlls) are stored central and will affect all tenants.Sql scripts will affect the database which all tenants share.Generic inquiries and site maps will only affect the current tenant, and not be seen on other tenants. This is all quite painful and sharing dll files across a live and test tenant makes testing in a test tenant very difficult. But that’s how it is.The site has about 20 customisations, and I want to publish one of them to the other tenants. The only option seems to be to use the ‘Publish to Multiple Tenants’. When I click this I see the following pop up window. But I’m not sure what happens next, the screen allows me to select Tenants, but I’ve not been able select which Customisations will be published to t

Good dayI have created my Import Scenario based on the Move screen AM302000 and I am getting the following error message.“OperationID” cannot be found in the system However if I create the transaction from the system I can pick it as per the screenshot belowI need to import a number of Move transactions from a historical Tenant as I have changed my base currency.How can I resolve this issue?

While importing AR Payments, I am getting an error “Input sring was not in correct format”    

I’m been trying to add a condition to the workflow of SOShipmentEntry (SO302000) so that it will make other parts of the workflow easier to configure. My code compiles but the condition doesn’t appear within the editor.I’m guessing that I have a parameter incorrect. I’ve leaned heavily on this post but to no avail.Can anyone see something obvious?using PX.Data;using PX.Data.WorkflowAPI;using PX.Objects.SO;using static PX.Data.WorkflowAPI.BoundedTo<PX.Objects.SO.SOShipmentEntry, PX.Objects.SO.SOShipment>;using PX.Data.BQL;namespace CustomerOEMods.Workflow{ public class SOShipmentEntryWorkFlowExt : PXGraphExtension<PX.Objects.SO.SOShipmentEntry_Workflow, SOShipmentEntry_Extension, SOShipmentEntry> { public class shipViaPickup : BqlString.Constant<shipViaPickup> { public shipViaPickup() : base("PICKUP") { } } #region Conditions public class Conditions : Condition.Pack { public Condition IsCustomerPICKUPOrder => GetOrCreate(b => b

In Pivot Table , the time is not showing properly . It showing as Integer .For example below GI based Time sheet report for Equipment / Employee Time . This is showing correctlybut when we make a Pivot table using the same data the time is showing as integer , any option to show it as proper time . Tried “Format” option on Pivot table but it does not helped. 

Hi All,Is there a way to retrieve the Supplier Balance, Prepayment Balance, and Retained Balance details (as shown in the attached image) for a particular supplier through a Postman call?Any guidance or suggestions would be greatly appreciated.Thanks,Lalith

Hi There,I’m trying to release a AP batch payment, but system only allow to export. When I hit export, an error message came up . “CA Error: The batch cannot be exported. An export scenario is not specified for the payment method.” Could you please advice how can I release the payment in Acumatica ? Thank you.  

Hi,We are working on customizations to the Sales Order screen. I have added several new fields and overridden a few methods, such as PrepareInvoice and CreateShipment, to ensure that some of the custom fields flow through to shipments and invoices However, we are encountering an error with the following message:Error: Inserting 'Billing Address' record raised at least one error. Please review the errors. Error: 'RevisionID' cannot be empty.  We are unable to pinpoint exactly when this error occurs. Sometimes, it happens when adding a non-stock item, and at other times, it occurs when saving values in the new custom fields. The error disappears after refreshing the page, but this is not a practical solution as all entered data is lost upon refresh. I have attached the SOOrderEntry code and the Customization Projectfor your reference. Could you help identify what we might be doing wrong or missing? Any help would be greatly appreciated. Thank you.Ramitha Manathunga.SOOrderEntry Code #reg

Hi, I need to construct request that will update/create the cross-reference description.I tried this and many other variations, but it did not work 

Hi Team, I am creating a custom screen, and I have an issue with a column and actions . I added a screen ID "Details," but the standard actions like "Insert" and others are not working when I click them. Please provide a solution.Regards,Sagar    <asp:Content ID="cont3" ContentPlaceHolderID="phG" Runat="Server">    <px:PXTab ID="tab" runat="server" Width="100%" Height="150px" DataSourceID="ds" AllowAutoHide="false">        <Items>            <px:PXTabItem Text="Details">                <Template>                    <px:PXGrid runat="server" ID="CstPXGrid10" KeepPosition="True" DataSourceID="ds" SkinID="DetailsInTab" SyncPosition="True">                        <Levels>                            <px:PXGridLevel DataMember="detailsqltyresponse" >                                <Columns>                                    <px:PXGridColumn DataField="Cod" Width="70" />                                    <px:PXGridColumn DataFie

Hello! While developing a customization project to extend a webservice to migrate data from our legacy ERP into Acumatica, I have discovered that while there is a standard ‘CustomerLocation’ object where we can access and modify customer location entries, there is no equivalent VendorLocation object. I tried to create a VendorLocation endpoint by mimicking how the Customer Location fields were all mapped, but there do not appear to be equivalent mappings in order for me to accomplish this. Additionally, if I just select all fields from the Vendor Location Summary, it corrupts things so badly that we start getting stack overflows when trying to push a Sales Order into Acumatica:And when we try to pull the VendorLocation data via Postman, it would throw errors relating to the Address information we had mapped directly from the Vendor Location Summary (here’s a small snip of that error):"message": "An error has occurred.",    "exceptionMessage": "The multi-part identifier \"BAccountID!Add

I need to add a new segment type to Lot/Serial classes but running into an issue because of a static method.  In class INLotSerClassMaint, the persist method is overridden to do validation on the segments. Here is the method from standard Acumatica.   public override void Persist() { foreach (INLotSerClass lsclass in lotserclass.Cache.Inserted) { lsclass.LotSerFormatStr = INLotSerialNbrAttribute.MakeFormatStr(lotserclass.Cache, lsclass); if (lsclass.LotSerTrack != INLotSerTrack.NotNumbered && lsclass.AutoNextNbr == true) { int NumbericCount = 0; foreach (INLotSerSegment lssegment in lotsersegments.View.SelectMultiBound(new object[] { lsclass })) { if (lssegment.SegmentType == INLotSerSegmentType.NumericVal) { NumbericCount++; } } if (NumbericCount == 0) { throw new PXException(Messages.NumericLotSerSegmentNotExists, Messages.NumericVal); } else if (NumbericCount > 1) { throw new PXE

I am developing a new processing to process web orders that can be pushed straight through to creating a shipment.  I have the process set up that assigns the owner and creates the shipment but I’m not sure how to automatically send the shipment confirmation report to a specific printer on devicehub.The code I have which works to the point of creating the shipment and storing the shipment number is below.using System;using PX.Data;using PX.Objects.SO;using PX.Data.BQL.Fluent;using PX.TM;using PX.Common;using System.Collections.Generic;using PX.Objects.CR;using PX.SM;using PX.Reports;namespace PPCustomOrderProcess{ public class AIProcessOrdersCust : PXGraph<AIProcessOrdersCust> { public class wOOrderType: PX.Data.BQL.BqlString.Constant<wOOrderType> { public wOOrderType() : base("WO") { } } public class paymentMethodAFFIRM: PX.Data.BQL.BqlString.Constant<paymentMethodAFFIRM> { public paymentMethodAFFIRM() : base("AFFIRM") { } } public class pa