Solved

Hello Experts                      Until now (2025R2) or before, is there a way to set the sales Price for FIFO item based on its layer cost.  Like for item A, we are having 3 cost layers on hand.   Like $10,$11, $9. Can we set fixed markup like $3. When the $10 stocks are sold out, the system will change the price from (10+3) to (9+3)?

  I have tried to login to Report Designer but get below error message. I have download ERP from below which match with Acumatica cloud login.Online VersionDownload Builder VersionRole enabled Report Designererror messagelogin, Copied URL when login in online and delete the ScreenID, User name is my USername@tenantname 

 Hi, there is a custom field in Invoices and Memos screen called ‘Rental Agreement Nbr’ and this is also added in Application History tab of Payments and Applications screen. When sorting this column, I get the error: Unknown column 'ARRegister.UsrRANbr' in 'order clause' even though I have set the AllowSort to True. How do I allow sorting on this column?  

Hi,How can I make an OData call to a Generic Inquiry with multiple values for a filter?  For example, OrderID is 1001, 1003, or 1004.I know OData v3 does not support the “IN” filter clause.  But can I user parameters or OData v4 to retrieve multiple records based on an array of filter values?Thanks!

Hi Community,I have two configuration- related questions regarding Production Order behavior1.Default Status when creating a New Production Order: when creating a new Production Order, it automatically goes to Planned Status. Is there a way to make it default to Hold status first?2. In the Production Order Maintenance – Reference tab- when using an Inventory ID that already has a BOM assigned, should the system automatically pull the BOM ID and Revision? Is there any way both BOM ID and BOM Revision can be left blank by default? I’m trying to understand if this is standard system behavior or controlled by configuration.

Hi there,We need to add the Address Line 1, 2 and Postal Code fields to the “Select Parent Account” popup screen. Usually if a field is not available to add (via the Gear icon) I can edit the underlying GI to make the field avaialble but I can’t seem to track that down. Does anyone know the name of the GI for this screen? Or would adding those fields require a customization project? Thank you!Jon HunsickerJones School Supply

Hi Everyone, I’m trying to add the Bank Deposit (CA305000) to a custom endpoint, however I’m struggling with getting the payment details to populate.I have no issue with adding the Header or the charges, but I’ve tried a bunch of different ways of adding the payments without any success.Below is how I have the endpoint at the moment however I have tried it with the AddPaymentDetail not being nested within AddPayment as well as trying to add the payments directly through Payments.When I submit a request the record will create however the payment detail will be emptyThe closest I can got to having it look like it is trying to add the payments is if I omit the DocModule property of $.AddPayment.Payments[*] then I receive the following error.Any help here would be greatly appreciated.

We want to use the SendGrid integration to track opens, clicks, etc. for emails from Acumatica. This includes emails sent: From the Mass Emails screen.  Through Notifications, e.g. sales order notifications, invoice notifications, etc. I configured a system email account to integrate with SendGrid and set it to track opens, etc. by default. When I create an individual email from a business account, those settings populate through to the email, but when I created emails via the mass emails screen and the Print Statements screen, the settings to track opens and clicks (“Track Email Opens” and “Track Clicks in Email”) were not checked on the email activity. Do we need to do something more with our configuration, or does the SendGrid tracking not work for mass emails and notifications?

Hi everyone,I’m looking for guidance on how to create dashboard widgets in Acumatica that display the following: Top 10 Customers by Sales ($ Amount) Ranked by total sales revenue Displayed in a graph (e.g., bar or column chart) Top 10 Items Sold Ranked by quantity sold and/or total sales amount Graph should display the item name and description Should show both quantity and price (or total sales $) Additionally, I’d like both widgets to be filterable by: Weekly Monthly Quarterly Ideally, users should be able to adjust the date range dynamically from the dashboard.My questions: Is this best accomplished using Generic Inquiries (GIs) as the data source for the widgets? What tables and joins would you recommend for pulling accurate sales totals (ARInvoice, ARTran, SOOrder, etc.)? What’s the best way to structure the GI to allow dynamic date filtering (week/month/quarter)? How can I ensure the item description appears correctly in the graph labels? If an

Good day,User can’t login from Outlook from the ACM Icon.  They are getting the attached message. The direction seem inconsistent. On each role?Any suggestions?EvanStep 1: Verify and set up access rights:Sign in to Acumatica as an administrator. Navigate to the Access Rights by Screen (SM201020) form. In the tree, select Hidden > Outlook Add-In Read Mode. Set up access rights for the needed roles, or reset access rights by selecting Not Set in the Access Rights column for the Administrator role. Save your changes.Step 2: If access rights are set correctly and the issue persists, a corrective script should be applied. Please submit a case to Acumatica Support to receive the script and any assistance you may need with running the script.

In 25R1, we noticed a change in behavior related to paused Appointments.When an Appointment is paused, the system is not updating the Employee Time Activity/Time Card immediately. The time activity only gets updated after the Appointment is completed.However, in 23R2, the Employee Time Activity was updated immediately when the Appointment was paused.Has this behavior changed in 25R1 (or in any 2024 version)?Is this an intentional system change, or has anyone else experienced the same issue?I reviewed the all the release notes from 24R1 to 25R2 but there is no change noticed.  

Hi everyone,I’m working on a custom screen in Acumatica 25R2 Modern UI and I’m facing an issue with a qp-panel containing a qp-grid.The scenario: I have a primary view for "Pick Lists" and a SmartPanel to "Add Shipments". When I click the action button to open the popup, the grid inside the panel remains empty. It only shows the data after I manually click the "Refresh" button inside the grid's toolbar.What I've tried: I tried using syncState: true or syncChanges: true in the topBarItems configuration within views.ts, but I get a compilation error: TS2353: Object literal may only specify known properties. It seems these properties are not available in the IToolBarItem type for 25R2. I added auto-load="true" to the qp-grid in the HTML, but it still doesn't trigger the initial fetch. I implemented a @handleEvent in the .ts file to call this.view.refresh(), but the grid still initializes empty when the panel opens.  View definition (C#):public SelectFrom<SOOrderShipment>    .Inn

For exmaple,Vendor Lead Time as 100 days for Warehouse 1Vendor Lead Time as 200 days for Warehouse 2  etc...

Hi there, For any GI results page like the stock Sales Order screen (SO3010PL), why do some fields allow you to filter by checking or unchecking specific values like the Status column does……while other fields like Order Type only list generic operators and prompt you for a filter value?What determines this distinction? Is this something that is editable such that we could make the Order Type field filterable in the same way as the Status field is? Thanks! Jon HunsickerJones School Supply

Does anyone know of a way to handle the new CO Retail Delivery Fee ($.27 beginning July 1, 2022) either with Avatax or without? Avalara had sent out communications regarding this which stated to perform the following: Merchants subject to this fee will need to add a $0 line item to their orders with the OF400000 tax code. I’m unsure as to how this would be done in Acumatica. Perhaps someone from Acumatica may know if there will be something released in a new build perhaps? 

How do we give someone access to SHARE COLUMN CONFIGURATIONS? I can only get it to run when I give someone admin rights, but these are managers for specific segments, not admins. Where do I enable SHARE COLUMN CONFIGURATIONS for these users? I swear I’m just blind, it has to be somewhere in Access Rights, but I’m not seeing it under hidden, system management, configuration, etc. Thank you in advance to whoever has the eagle eyes to find this setting!

We have setup a Pending Approval Notification in Purchase Orders Preferences that whenever a purchase order goes for approval, the approver gets an email that there is a PO that needs to be approved.  There is also Mailing & Printing to notify that the PO has been created. Is there a way to notify the requestor that the PO has been approved without creating a business event or another email template? Probably an auto-generated email that PO has been approved. Thanks so much for your time. 

Hi All,As per our requirement I have created a new COA 20040 - while creating the same selected use default sub account check box and saved.  At the same time while creating Non Stock Items selected this sales account and updating  default sub account.  it is not allowing me to save and showing an error as below 'Sales Sub.' cannot be found in the system. Please verify whether you have proper access rights to this object.  I have verified all access rights and provided necessary accounts.  Stil showing same error.  Please help me how to fix this issue.  

Hi,Building an integration with Shopify for a client. I am using custom fields to store the order ID keys and there is a PXCheckUnique in place on this field to prevent duplication. #region UsrMAXXShopifyOrderID [PXDBString(30)] [PXCheckUnique( Where = typeof(Where<SOOrderExt.usrMAXXShopifyOrderID, Equal<Current<SOOrderExt.usrMAXXShopifyOrderID>>>))] [PXUIField(DisplayName = "Shopify Order ID", Enabled = false)] public string UsrMAXXShopifyOrderID { get; set; } public abstract class usrMAXXShopifyOrderID : PX.Data.BQL.BqlString.Field<usrMAXXShopifyOrderID> { } #endregionThis validation works as expected in the UIHowever, if an identical request is made then in the response all Usr fields that are on the SOOrder object are null and the order is created without any of these fields created. (There is a Usr field on the SOLine that is still populated)I have done integrations for other clients

Hi,I wanted to see if there were separate rules for INSiteStatus vs. INLocationStatus’ QtyAvail fields?INSiteStatus returns a value for QtyAvail that matches the INventory Allocation summary in that it deducts ON Issue, Allocated and BAckordered - which are defined in our default calculation rules.For INLocationStatus, it is only deducting the on issue amount but not allocated / backordered. is this an incorrect behavior that we need to correct or done on purpose?ThanksJoseph

I’m trying to pull one character out of the PMProject.ContractCD field in Report Designer.  Using this expression...=Substring(CStr([PMProject.ContractCD]), 5, 1)...a “0” is always shown no matter what number is in the numeric 8 position field.  This expression DOES work in a GI, however, and pulls the correct digit.  How can I get this to work in Report Designer?   

I have this GI that is looking at SO Lines. I am wanting to restrict which SO Line is showed based on the site ID. I heard (correct me if I am wrong) that if I can filter via the relations table, the GI can run faster (vs using the conditions tab or creating filters in the user facing GI). But I can’t seem to make it work. I’ve tried every variation I know (hence lines 2 and 3 are different in the child field. If creating this filter in the conditions tab will the direction I should go, then I don’t even need to link the SOLine and INSite tables.

Hello Community,Could you help me with code that allows me to create a discount code and then apply it to a sales order?I am creating the discount code, and it is being created correctly — all the data is saved properly in both the header and the details. However, when I try to apply it to a sales order, the discount code is not applied: the sequence ID is not generated automatically, and when I set the sequence ID manually, the type is not set. By contrast, if I create the same discount manually and apply it to a sales order, all the fields are saved correctly.  

Hi All,Acumatica's Production Cycle for a manufactured product consists of 2 major steps: 1) produce volume first and then 2) subsequently, pack the volume into the required SKU.In such a scenario, is there a way to ensure that there is full availability of all materials required for producing a specific volume of a product, prior to confirming a Production Order? If yes, how and where can this be implemented/checked? In other words, a Production Order should not be allowed to proceed further (any subsequent steps) if there is either no or not enough material as required to produce a specific volume of the manufactured product.The same applies to the 2nd part above i.e. to again ensure that all packaging material required is available in full quantity during a request for Packaging Materials. Since this is a separate TR request (Inter Warehouse Transfer), how to ensure that this TR request is tied to the Production Order from step 1 above? The reason being, in our case we use some comm

Hello Community,I want these changes on the original screens. For my custom screens, this worked when I added actionsConfig: { exportToExcel: { hidden: true } } in the @gridConfig of the .ts file.