Solved

We changed a stock item's posting class. One year later, it still uses the GL defined in the old one. Why?  The item and posting class Gl accounts are defined with the new accounts.  I’ve looked at the bill of material, the sales order, warehouse, location.  Nothing suggests that the old accounts should be hit.  This is happening for issues out of the warehouse but does not appear to affect receipts.

Hello,Just installed report designer. My first project is to figure out why the PDF file of a report has a data set that the bounced excel file does not. I came across this linkhttps://www.augforums.com/forums/acumatica-report-designer/export-report-to-excel-totally-skews-report-but-it-pdf-looks-perfect/I totally understand this. However, I don't understand how the row/column layout works regarding this. From the link i get what the green box shows. but how do multiple data values use the same “excel cell”, but when pushed to excel they’re not actually those values. For example, wouldn’t my ‘warehouse’ value lay on 7,7? that’s where it lies on the excel sheet.I’m trying to get “SOLine.InventoryID_description” to show on excel.

I am fill created by field by some user. But when document saved “created by” filled by user which run process screen. 

Hi there,i hope you can help.We’re imorting the objects customer, customer location and order from Shopify. The import of the objects customer and customer location was successfully and i can see the data in the ERP, but i do get this error message for some orders: The record cannot be synchronized because it does not exist in the ERP and external system.I do not understand what’s the issue of those orders. The items and IDs of the products exist in the ERP and other orders with the same products were succesfully imported.I see in the synch overview that the external ID exists and it forwards me to the correct order in shopify.Any ideas how i can proceed in getting those orders imported?

Does any body know how to delete Employee time activities with status hold and Open. I have created import scenario but unable to map the Delete Action.   

When I create credit return it show the error message like this.

Hi Acumatica Community,I created a Purchase Order with the following info  50 PHP = 1 USD with 50 % DP to Supplier  Processed the Prepayment with the same currency rate in Purchase Order500 PHP = 10 USD (@50PHP per 1 USD)When i tried to Purchase Receipts based on Purchase Order.I noticed that the currency field is not editableIs there a way to change this rate, based on what i set up in Purchase Order?This should be 50 PHP per 1 USD. I should received this inventory at the amount of 500 PHP.Seeking your assistance for this concern.Thank you!

When importing Stock Items I am getting a message: “Please confirm if you want to update current Item settings with thee Inventory Class Defaults.The import scenario will not p[roceed without a response.How do I get past this message?

 In the Shopify Stores(BC201010) and BigCommerce Stores(BC201000) form, the user can choose the option to show the discounts in Acumatica Sales Order as a Line Discount or Document Discount when orders are imported from External System. It cannot be both.  When Show Discount In: Document Discount The order Level and item level discount from external system will be shown in the Discount Details tab in the document level in Acumatica Sales Order. This is the order created in BigCommerce.  This is the Sales Order in Acumatica  Also, When the Document Discount is selected the Discount Amount revenue will be recorded against the Discount Accounts as shown below. When Show Discount In: Line Discount The order Level and item level discount from external system will be shown in the line item in  Acumatica Sales Order. When Line Discount is selected, by default, the discount amounts are not recorded against the discount amount  But if Post Line Discount Separately is selected in the Order Type

Hi there,We are looking to find a solution where we can set up overtime pay items that incur superannuation up to 76 hours a fortnight, so we don’t have to review each staff member every pay cycle manually.Does anyone have a solution or suggestion on how to set this up?Appreciate everyone’s thoughts on this.Cheers,Matt 

Hello,          I have designed a report to show the items customer bought in last 90 days. The report run properly when it is run on its own screen with the parameters like below.        However, when I trying to run it from SOInvoice screen with the passing parameter below, it gets empty results.   How should I correct. Thank you.

I get this error when creating a receipt transfer from a SO transfer. The SO transfer is created with 1 SO line item and 4 lot nr. Using the Create Shipment action the SO creates 4 ship lines for the same item each with its own lot nr. Using the API I create a transfer receipt with a TransferOrderLineNbr of 1 for each item/lot nr combination. I get the error “Incorrect value. The value to be entered must be less than or equal to 234.00.; receiptQty: Incorrect value. The value to be entered must be less than or equal to 234.00” I attached the SO and shipment that are created and the Json for the receipt transfer and the Json response from Postman Tested on Default endpoint 23.200.001 and 22.200.001, same result

We are unable to close a production order. It might have been forcefully completed or a move transaction deleted. Need guidance to resolve this and close the production order. Inventory module cannot be closed due to this error.Missing Move Transaction: When I click one of the move transaction numbers, it doesn’t react. It seems like it was forcefully deleted. Production order status: Completed.How can I resolve this to close the books?

How can I print the time when an ARM report was printed in a column set.  Like this:  12/15/2025 11:53:25 a.m. 

Does anyone know of a way to bring a “filter” into conditions?I’m trying to filter “First Invoice Date” and i’m using SOInvoice.DocDate to do so. however, this catches all invoices. I can filter, but that only happens after my information has been pulled and it does not achieve what i am trying to do.^this is the “Drilldown” filter that gets applied when going from the Sales Manager Dashboard. It shows the exact info I need, but i cannot set this up as a business event; it drops the filter.  This is how I have attempted to create the filter; but it still shows me old customers because their invoice date is still included in this filter.I get my information perfectly but I cannot, ‘filter’, for a better word, my First Invoice Date down without bringing in other customers who have also had invoices created within the last month, or using a separate filter after the GI has been ran. I post here as a last report and my google abilities have ran dry now that AI has taken over their algos. I

Hello all,I would like to confirm whether it is a native Acumatica functionality that when a metafield in Shopify is not mapped in Acumatica, any data exported from Acumatica to Shopify will result in a blank value being passed to that unmapped metafield, even if there is data present in the corresponding field?Thanks.

I need to add my custom field for user selector.#region Creator        [PXDBString]        [PXUIField(DisplayName = Messages.Creator, Required = true, Enabled = true, Visibility = PXUIVisibility.SelectorVisible)]        [PXSelector(            typeof(Search<Users.username, Where<Users.isHidden, Equal<False>>>)        )]        public virtual string Creator { get; set; }        public abstract class creator : PX.Data.BQL.BqlString.Field<creator> { }        #endregion I have some problem

In version 2020r2 v205 (I know…  ) I have a couple of GIs that I’ve created that are using the InventoryCD value as my parameter with standard parameters allowing for the display of all items if the parameter is Null.  When I open the Inquiry, either from the UI or using the View Inquiry action from the Generic Inquiries screen, Acumatica is inserting the <NEW> value, as though it’s expecting me to create a new record.   Has anyone seen this before?

We are unable to find a screen in Acumatica like we use in our current system. The screen is a tab in the customer record and shows all activity such Quotes, Sales Orders, Invoice, Credits, Payments etc. See screenshot.Thanks

Client wants to Back up the data in their production environment to the test instance of Acumatica. Currently we use a single instance multi tenant environment which has production, UAT & test intance for this client. Production is under tenent id 2 and Test instance is under tenant id 3.We need to clarify would there be any issues if we perform this process of creating a snapshot of live environment and restoring it in the test instance and what impact would it have in the whole system since we run a single instance multi tenant environment.What will be the impact that would have on the data that are already in the test environment would they get override when we do the restoration or would they be duplicated and the would there be any impact in the current configurations/Customizations  of the production environment? 

If I want to modify the html for a custom field in a grid view, I am not sure where to do it.Example scenario:I created a custom field in the GLTran table UsrNSCustomer.  In the Modern UI editor (in Project Editor), I add the field to the view.This is the field I added as it shows in the editor. the typescript file is generated.  Now the field shows in the grid when I publish the customization. import { PXFieldState} from "client-controls";import { GL301000, GLTran } from "src/screens/GL/GL301000/GL301000";export interface GL301000_GreenSparkGLUDF_generated extends GL301000 {}export class GL301000_GreenSparkGLUDF_generated {}export interface GLTran_GreenSparkGLUDF_generated extends GLTran {}export class GLTran_GreenSparkGLUDF_generated { UsrNSCustomer: PXFieldState;}The html in the editor does the job of pulling this field onto the grid using the gridDetails id. <qp-tab id="tabTransactions" caption="Details"> <qp-grid id="gridDetails" view.bind="GLTranModuleBatNbr" w

Hi,I’m trying to retrieve more detailed information about the items in a shipment.The REST API endpoint /entity/Default/23.200.001/Shipment/<shipmentNbr> returns the InventoryID.This InventoryID can then be used to fetch item data through either /entity/Default/23.200.001/NonStockItem/<InventoryID> or /entity/Default/23.200.001/StockItem/<InventoryID>.However, I’m not sure which endpoint should be used in this case. Could you provide some advice? Thanks in advance  

Hello,I am trying to drop ship an item that is serial tracked.  I have checked the Required for Drop-ship box in the Lot/Serial Class. I still cannot open Line Details to enter the serial number on the Sales Order screen, and get this error. The first place I can enter a serial number is on the Purchase Receipt. Is there a way to enter the serial number on the Sales Order screen for a drop ship item?

When trying to edit the ASPX of the Vendors screen in Acumatica 25R2, I get the following error: 'You have insufficient rights to access the object (GraphAspxEdit).' This is preventing me from customizing the ASPX for the screen to fit my needs. Is there a reason that this is happening? I'm logged in as the administrator and have had access to this feature in previous versions of Acumatica. Any assistance would be welcome.

Hey Looking for any insight on this, I am currently trying to Prepare the Data for integration on the Import by Scenario screen of about 40,000 entries, but whenever I prepare the data before import I receive an error as it is processing. The Error is “Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks. Parameter name: ticks” Thanks!