Discussion Forums

Hi all,Is it possible to create a BOM for a non-stock item? As my team described it to me, they want to do this as it’s not an “item” per se but more of a “service” with no on-hand inventory levels. Is this possible? Any docs/tutorials on this if it is possible?

Acumatica allows expired materials to be used in production despite the fact that an expiration date is set. No warning to user or hard stop.Does anyone have a workaround for this other than a custom inquiry that allows to find expired material and remove it from the shelves?We are in a regulated industry (medical device) and current feedback from Quality is that the workaround is not sufficient and an active warning, if not a stop, from the system is the minimum that has to be implemented.

StateColumn property of PXToolBarButton, it disable the custom action button on grid header based on assign field value true/false, in Modern UI is there any substitute code or solution 

A previous discussion identified the Cash Account Balance on the Reconciliation Statement Report as the “Cash Account Balance on bank Statement date”.  I would expect that to tie to the ending balance per the Trial Balance, but it does not.  Do I have an error somewhere, or just a misunderstanding?Thanks 

Hi, I've joined the APInvoice table with the APTran table to display the line-level tax amounts in the Project Transaction Register report.However, I’m encountering duplicate records, and I’m unsure which join might be missing or if there’s an additional table that needs to be included to eliminate the duplicates.I’ve attached project transaction register report for your referenceIf anyone has any insights, I would appreciate your help.   

Hi Community,Is there any way to get a side panel on this Inventory Allocations screen via Customization projects? It does not seem to have the option under the Action Types. Thanks,RJ

Hello, I’m looking for a way to make matrix items with only one variable. I have a product that comes in 4 colours, but doesn’t have any other variables. Is this doable? 

I am trying to create a Sales Invoice with a Payment but i get the following error: "An error occurred during processing of the field CuryAdjdAmt: Nullable object must have a value.."I am using the /Default/23.200.001/SalesInvoice endpoint and this is my request:What am I missing or do i need to create first the Sales Invoice, then the Payment and then apply it? {     "ReferenceNbr": {         "value": "<NEW>"     },    "CustomerID": {        "value": "ABAKERY"    },     "ExternalRef": {        "value": "801PM00000DhqGnYAJ"    },       "Type": {        "value": "Invoice"    },    "IsSpecialOrder": {        "value": false    },    "Date": {        "value": "2024-04-22"    },       "ShipToAddressLine1": {        "value": "Test"    },    "ShipToOverrideAddress": {        "value": true    },    "ShipToOverrideContact": {        "value": true    },    "ShipToCity": {        "value": "Test"    },    "ShipToCountry": {        "value": "US"    },    "ShipToPostalCode": {        "value":

Hi Community I have never seen this before, but what would cause the Owner field to show in every other tab except for the Conditions tab?  I need this APQuickCheck.OwnerID as a Condition, but it does not show up. I can see it in the Parameters, Results Grid, and everywhere else.   Thanks,RJ  

I'm experiencing an issue when updating a custom field (usrDebitAccount) on the Transfers screen (IN304000) within the Transfer Details grid, specifically in a Released document. In the INTran_RowSelected event, I’ve enabled the custom field usrDebitAccount  when the row is released, like this. I have also enabled the field from workflow as well.protected void INTran_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler){ InvokeBaseHandler?.Invoke(cache, e); var row = (INTran)e.Row; if (row == null) { return; } if (row.Released == true) { Base.transfer.Cache.AllowUpdate = true; Base.transactions.Cache.AllowUpdate = true; PXUIFieldAttribute.SetEnabled<INTranExt.usrDebitAccount>(cache, row, true); }}The issue is: When I change the value of usrDebitAccount on a single row and try to save, the Save button appears enabled but it shows the below error message         If I click ok button of above pop up

🚀𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐢𝐧𝐠 𝐀𝐜𝐮𝐒𝐡𝐚𝐫𝐩 – 𝐘𝐨𝐮𝐫 𝐍𝐞𝐰 𝐅𝐨𝐮𝐧𝐝𝐚𝐭𝐢𝐨𝐧 𝐟𝐨𝐫 𝐇𝐢𝐠𝐡-𝐐𝐮𝐚𝐥𝐢𝐭𝐲 𝐀𝐜𝐮𝐦𝐚𝐭𝐢𝐜𝐚 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭  🚀Today, I'm proud to introduce 𝐀𝐜𝐮𝐒𝐡𝐚𝐫𝐩: a focused, practical, and community-driven helper library designed to bring real efficiency and structure to Acumatica customization projects.🔹 What is AcuSharp?AcuSharp is not just a set of random utilities — it's the beginning of a structured toolkit that saves time, reduces bugs, and raises the standard of Acumatica development.The first release already includes:𝐀𝐂𝐒𝐏𝐀𝐮𝐝𝐢𝐭𝐚𝐛𝐥𝐞𝐃𝐀𝐂: A standardized base class for DACs, automatically handling audit fields (CreatedByID, CreatedDateTime, LastModifiedDateTime, Tstamp) so you never forget them again, and you won't have to copy and paste these fields every time.𝐀𝐂𝐒𝐏𝐑𝐞𝐬𝐭𝐒𝐡𝐚𝐫𝐩: A lightweight, fluent wrapper around RestSharp for effortless REST API calls in your Acumatica projects.𝐀𝐂𝐒𝐏𝐖𝐞𝐛𝐡𝐨𝐨𝐤𝐇𝐚𝐧𝐝𝐥𝐞

Hi,I configured an automation schedule for the Run Project Billing process. However, several of the projects that were completed still generated an invoice even though the items were billed already. I did know for several line items this happened on after Run Billing was done the completed % column like below increased from 100% to 200% causing an invoice to happen. The billing rule is set to Time & Material .Here is the billing rule for Time & Material: This billing rule also includes a progress billing:  Could the billing rules be causing an issue. Some parts of the revenue are T&E and others progress. Let me know or if you need more detail.Thanks,Frances

Hello all,I’m trying to find a way to import multiple corporate cards at once. My company has a lot of employees and each of them have a card that needs to be in the system. I see where you can enter each individual card, but I can’t find a way to mass-import all of these. Any help on this would be appreciated.Thank you.

Hi All,since our business have some PO with dropship type we have to manually tick the freight line to complete (dropship freight is a non-stock item) to able to receipts the whole PO). is it possibility for the freight dropship to be auto-complete?

Hi, I am trying to print lines for an Invoice Print using the report designer. It works fine when the invoice is a single page, however it does not when the invoice is multiple pages. The lines get drawn to the end of the page … I’d appreciate any ideas… Thank you,Bhavesh

Hello Everyone, I have an import scenario and business event that create a new project from an SO Quote. There is an attribute on the project to bring in the quote number. After the project is created I have another import and business event that is supposed to insert the projectID and taskIDs back into the quote. I keep getting an error that says the ‘project task’ cannot be empty. Here is my most recent import mapping: As additional info, I made the taskID = the LineNbr on the quote of the original import that creates the project. Anyone have an idea on why this one is erroring out? Thanks

We’re running 2023R2 and I’m trying to update the UnitPrice to equal the UnitCost when entering items in a “No Charge” Sales Order.  Using the following code:namespace PX.Objects.SO{  public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>  {     // Update prices when order quantities updated    protected void _(Events.FieldUpdated<SOLine.orderQty> e)  {    var order = Base.Document.Current;    var line = e.Row;    if (order?.CustomerOrderNbr?.Contains("SE") == true && line != null)    {        // Use SetValueExt to ensure all business logic and UI updates occur        e.Cache.SetValueExt<SOLine.curyUnitPrice>(line, line.CuryUnitCost);    }  }    // Update prices when CustomerOrdNbr changes    protected void _(Events.FieldUpdated<SOOrder.customerOrderNbr> e)    {        if (e.NewValue?.ToString().Contains("SE") == true)        {            foreach (SOLine line in Base.Transactions.Select())            {           if (line.CuryU

Hello Community, We are having an issue when attempting to confirm a shipment and receiving the following message:On the shipment, we are not trying to delete any items, simply clicking the “Confirm Shipment” button and receiving that error. The quantity lines are as follows:These are serialized items, and all have a serial selected so no unassigned quantities. No duplicate shipments were sitting out there, and the lines are all allocated correctly. The order itself shows the lines as open for shipment and every line is marked “back order allowed”. Has anyone seen this error before? 

We’ve recently found out that the accounts created for our customers to use the customer portal have access to our main Acumatica database as well. Is there a way to ensure that customers only have access to the portal and nothing else?

We are currently exploring options to streamline the process of converting business accounts (BAs) to customers in Acumatica, ensuring efficiency and maintaining control over the conversions. Our client relations team receives calls from customers who wish to place orders over the phone and pay with a credit card. In order to proceed, the client relations team adds these customers as new Business Accounts (BAs). The BAs are then converted to customers to conduct business, but only our accounts receivable team has the ability to convert BAs.Is there a way to create an exception in Acumatica where our customer service team can ONLY convert BAs to a specific customer class, such as "Credit Card Customer," which automatically assigns them credit card terms? This would enable our customer service team to securely utilize Acumatica payments for credit card purchases. We are seeking advice on how to implement this exception effectively to ensure our customer service team can manage credit car

Hello! We have a scenario where we define the Sales Prices in Non-Base Currency (USD) but require it to be converted to Base Currency (LKR) in some instances. Specifically, if the customer is USD the USD prices need to be loaded and if the customer is LKR, we have to convert the USD price to LKR on an agreed rate. There is an option to convert Base currency prices to a non-base but any possibility of other way around?Best Regards!

Is it possible to merge lots of inventory within Acumatica?

I'm trying to create a Generic Inquiry that identifies sales orders where a required TaxID is missing, based on the Customer Tax Zone. Here’s what I want: If the TaxZoneID is STNRETAILR, the order should have both TNOTP66SALES and TNSTEX If the TaxZoneID is MSRETAILR, the order should have both MSOTPEXS and MSSTEX If either is missing, I want to show that order in the results so it can be corrected Below condition is working fine . But When i tick all together it shows 0 Records Means condition is not working when i active all. 

Within the Payables section I’d like to be able to produce a report that shows only the Vendor Name and Payment Method.  Is this at all possible?I do not want to see anything else. Such as addresses or GL codes.  

Hello,We have a blanket sales order.Multiple lines each with the same inventory ID.When we create child orders from the blanket, we need each line to be it’s own new SO sales order.Acumatica consolidates all lines into 1 new sales order of type SO. The only way we can see to keep Acumatica from consolidating all lines in 1 SO sales order is to use a different location on the BL line item.I cannot find a preference or setting that says “Do not consolidate” or anything like that.  And the only way we have found top prevent the consolidation is by using different locations on the line, which we do not want to do. Any thoughts or suggestions?