Discussion Forums

I’m currently creating a generic inquiry to create a CSV upload report to a third party portal. CHEP (specially treated pallets that are ‘rented’ by our customers). Every week we upload a report to the third party with a count of these pallets with pertinent info - such as which customer and their CHEP account. This also includes quantity. The conundrum I have is that there are 8 item codes. One item code is for a single pallet - so this quantity is 1 to 1. The other 7 item codes are 1 pallet per unit - the unit count is different on them. Example: Customer orders 1 unit of CHEP - qty is 40. They also order RPCs (reusable plastic containers) that are stacked onto 1 CHEP pallet. The customer orders 10 units of the RPCs, so the qty of CHEP pallets is 10. Their total quantity is 50.Where I’m having the issue is coming up with the formula in the results grid to report the quantity of the CHEP for the invoice. I am using ARTran.Qty. I need to translate the unit counts of the 7 item codes to

Hi all, Apologies if this is in the wrong area, I couldn’t find a more apt one.  I’ll be attending not one, but TWO Acumatica UK Roadshow events this year.📍 Stratford-upon-Avon – May 14, 2025📍 London – September 16, 2025I’m looking forward to meeting other UK-based Acumatica members, so let me know if you’re attending one of the above and let’s connect! Thanks,Pete

Hi there! We have been facing an issue related to MYOB Advanced ERP (Accumatica) Filter($filter) option.When used $filter parameter in REST API, pass multiple conditions with 'or' operator.Like this in URL '$filter=CustomerID eq '21FEBUSER' or CurrencyRateType eq 'SPOT' which gives us this error:"exceptionMessage": "Only AND logical operator is supported","exceptionType": "System.NotSupportedException"Is there any solution/api/help available to get multiple record in single request to pass multiple condition from Acumatica ERP in REST URL.  

Hello, I'm new to API development and I need help with a specific query. In my current project, I can successfully retrieve all employees from the top list using $expand=Employees.My goal is to get the results from the bottom section (Overrides) which are linked to specific employees. In the UI form, when I click on Employee #1, the bottom window changes to show their specific overrides, and similarly for Employee #0.I've tried using $expand=Employees/EmployeesOverrides, but this returns Employee #0's overrides for Employee #1, which doesn't make sense.How can I properly query the API to get the correct overrides for each specific employee? I need to establish the proper parent-child relationship between each employee and their corresponding overrides.I've attached screenshots showing the UI interface and the API endpoint configuration for reference. Any guidance would be greatly appreciated!employee 0 overridesemployee 1 overrides 

Hello,I am working on a customization for the Stock Items Inventory. I am trying to add an action to the page that would create a new Purchase order and fill in the vendor fields and insert a line into the Details section for the Inventory Item. I have been able to open the form, and add the vendor, but cannot figure out how to insert the detail line.So I want to take the part that is circled in red in the first image and create a line where the red is in the second image.

I have an report in Acumatica that I have customized and when I run the report withing the Acumatica software the formatting is exactly as I designed it but as soon as I print it the formatting is lost. I am not sure if there is a setting that I need to change in order for the formatting to stay when the report is acually printed. Here is what the section looks like in the report writer:  Here is what it looks like when I run the report in the system: But as soon as I print it the red past due box and the yellow highlighting of past due amount is gone as is the formatting of my aging fields as shown below:  Am I missing a setting or something or is the report designer really limited in what can be formatted when the report is actually printed. Any help on this would be greatly appreciated. 

Hi Community,I’m working on a customization related to the Create Purchase Orders screen and need some guidance with vendor defaulting and updating custom fields on the POFixedDemand DAC.Customization Details:I’ve added the following custom fields to POFixedDemand: Shipping Destination Type Ship To Shipping Location Scenario: In the Sales Order, we have a Configurable item (parent) and IsSupplement (child) items. When creating a PO from this sales order: The Vendor and VendorName on the parent (Configurable) item in the POFixedDemand should default from the child item (where IsSupplement = true). and also on Parent Item (Configurable = true) What I’ve Tried: POFixedDemand_VendorID_FieldUpdated: I added logic here to assign values to the custom UDF fields. The values seem to be set in the code but do not reflect on the screen/UI. Overridden EnumerateAndPrepareFixedDemandRow delegate: I tried to default the vendor here based on the child (supplement) or stock item’

Can I use files of Different Customization Project into my current customized project?

During one of our Move transactions we received the following error.The label printed along with the attributes being passed through to the label and the associated Move transaction did release. This is the first time this has happened since our upgrade and our transaction volume is very high. Is this an error to be concerned about? If so what is needed to resolve this? 

Hi everyone! I wanted to share some thoughts about the challenges we’ve faced with syncing Template-Matrix items as Product-with-Variants in Shopify. As many of you know, we’ve run into a couple of limitations:Shopify can only support 3 options. There’s a cap of 100 variants per product.The first limitation has already been addressed in a previous discussion here. However, our Template item has 4 options and nearly 4,000 variants, which has been quite a challenge.We’ve tried breaking down the Template items into new ones with 3 options, but we’re still hitting the second limitation with some Template items exceeding 100 variants.The really exciting news is that Shopify has recently announced their new GraphQL product APIs, which now support up to 2,000 variants! 🎉 This is a game changer for us and anyone facing similar issues.I’m curious to know: when can we expect to see this new capability available in the Acumatica-Shopify connector? Any insights would be greatly appreciated!Thanks

PS D:\TCourseInstances\SmartFix_T290\FrontendSources\screen> npm run build-dev  modules=RS> screen@0.1.0 build-dev> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack --progress modules=RS[webpack-cli] 'modules=RS' is an invalid value for the --progress option. Only 'profile' is allowed. 

In report designer, is there a way to have a where clause of sorts on a parameter that is searchable?We have a report that sales reps run for their customer by selecting their customer as the parameter. I would like to limit the searchable parameter to only show them their customers instead of every customer.

Can you have the menu which appears on the top right of most screens, appear in the side panel view. These above menu options do not appear when screens like an invoices, purchase orders are viewed in the side panel. 

I am trying to add the customer order number on the add payments smart panel. I read that this can be done by using delegates, but I am struggling to get this to work.I added the dac: using PX.Data;using PX.Objects.CA;using PX.Objects.SO;namespace PX.Objects.CA{    public class PaymentInfoExt : PXCacheExtension<PaymentInfo>    {        #region UsrCustomerOrderNbr        [PXString(40)]        [PXUIField(DisplayName = "Customer Order Nbr", Enabled = false)]        public virtual string UsrCustomerOrderNbr { get; set; }        public abstract class usrCustomerOrderNbr : PX.Data.BQL.BqlString.Field<usrCustomerOrderNbr> { }        #endregion    }}  using PX.Data;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.SO;using System.Collections;namespace PX.Objects.CA{    public class CATranEntryExt : PXGraphExtension<CATranEntry>    {        [PXOverride]        public virtual IEnumerable payments(Func<IEnumerable> baseMethod)        {            foreach (PXResult&l

Hi Acu Community,Is there documentation on creating a Generic Inquiry showing the List of Pending for Approval, specifically for Workgroup Approval?Thank you!

Hello,As anyone overcome the challenge of Quickbooks’ subaccount functionality when converting to Acumatica?  Within QB, when one or more accounts is made a subaccount of another(i.e. parent) account then the balances of the subaccounts will roll up into the balance of the parent.  Many users of QB leverage this functionality for fund accounting especially with cash assets where they have a single interest bearing account at the bank but need to maintain separation for earmarks (e.g. restricted, capital projects, special events, etc).  The problem is not setting up the separate accounts in Acumatica or reporting but with reconciling to the bank statement.  From what I can tell, Acumatica only offers a one-to-relationship between a cash account and a GL account and therefore have not found a way to link the transactions in the fund accounts to the cash account.   

Dear All, I just joined the community and wanted to say Hello to everyone here. Heard great things about the community from others. Global PayEX is a Acumatica certified ISV that provides #Account Receivables and #Account Payables automation from an integrated platform. Customers can pick and choose components that serve their needs. We are JP Morgan invested B2BPayments finctech , we work very closely with VARs to bring combined value to our customers, and very importantly, we have live & happy Acumatica customers. I lead the business in the US, so feel free to reach out if you / your customers are looking to bring world-class automation in their B2BPayments areas i.e., Collect money faster, reduce #deductions and #disputes, apply cash faster to realize reduced DSOs and improved #Working Capital

I got this error when i validate a Default endpoint without any extension, same with Admin user.Why?Thanks 

Is there a way to set up Automatic Packaging by Vendor? Example, 5-gallon pails automatically select NONE for the Box ID as we stopped shipping them in boxes.Except, Amazon requires their order be shipped in a box. Is there somewhere I can set a filter that if the order is from Amazon, to use 5Gal as the Box ID? 

I have created a customization that adds a tab to the Stock Item screen. The tab contains a grid with a field with autonumber  attribute. Manually everything work find I can add multiple lines to the grid, but imports only add one line and then stop. The grid has a custom dac and view. Below is part of the dac:public class PAFactoryQuote : IBqlTable{  #region RefNbr  [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")]  [PXUIField(DisplayName = "Ref Nbr")]  [AutoNumber(typeof(PAQtSetup.numberingID), typeof(AccessInfo.businessDate))]  [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]  public virtual string RefNbr { get; set; }  public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { }  #endregion  #region InventoryID  [PXDBInt(IsKey = true)]  [PXDBDefault(typeof(InventoryItem.inventoryID))]  [PXParent(typeof(SelectFrom<InventoryItem>.              Where<InventoryItem.inventoryID.IsEqual<PAFactoryQuote.inventoryID.FromCurrent>>))] 

Hi, I need help.I have create Inventory ID and Linked with formula but when I want make production order I fill the code but cant pop-up    Thank you

Is the Source Restrictions tab on Import Scenarios ignored if the import scenario is fired by a business event?  I have an event that is triggered by an action on my GI.  The event can do two actions.  One of those actions isn’t always necessary (if the BE detects a cost discrepancy, it creates a cost adjustment).  I have the cost adjustment import scenario set with a Source Restriction of the cost difference field being anything but 0, but it continues to create $0 cost adjustments when the event fires.It’s not the end of the world; the $0 cost adjustment does nothing other than create unnecessary adjustment and batch documents.  But I’d like to have it stop doing that if it doesn’t need to create the adjustment.

I've created an import scenario to generate shipments to suppliers in connection with a business event, but it doesn't work. I also tried using a data supplier (Excel file) and got the same error message. However, the supplier has been created in the database, and I can create the shipment manually without any problem. 

Hello all.I have been working on ARM report & I have an individual GL Account that has figures in both Debit & Credit but different set of trxns. I’m looking to post the debit side of the amount under Expenses section & the later into Credits - Income. Kindly lmk how we can achieve this?

Hi Team,While releasing the “ Inventory Receipt”, I am getting the error ” GL Error: Missing Account Mapping for Branch 'CAPITAL ' and 'PRODWHOLE '” . Kindly suggest the missing one here.