Solved

 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! 

I think I must be missing something when I create a new wiki, my user is unable to open it even though I have all required permissions but another user with a different role that has the same access rights can open and edit.When I attempt to open the wiki I get: I have Wiki Admin and Administrator roles for my user A user with the LLC Department Manager role is able to access it, no other roles I’ve tested were able to.This is my first attempt to create a Wiki, but I can’t find any reason that it couldn’t be accessed.

I’ve done several complicated modifications to out-of-box screens now, but I’ve encountered one I can’t solve.I need to replace the ‘Phone1’ field of the ‘Contacts’ fieldset on the Contacts screen with another version with an additional button in the same row.The complication of this task is that the ‘Contacts’ fieldset is a predefined template that is ‘included’. CR302000.html - The ‘Details’ tab is ‘included’ from an extension (‘tabGeneral’):<qp-tabbar id="ContactCurrent_tab" class="label-size-m" wg-container> <qp-tab id="tabGeneral" caption="General" ref="tabGeneral_Content"></qp-tab>CR302000_General.html - ‘Contacts’ is ‘included’ from the template form:<template id="tabGeneral_Content"> <qp-template id="Details-form" name="1-1"> <div slot="A"> <qp-include url="src/screens/common/form-contact-person/form-contact-person.html" fs-id="tabDetails_Contact" contact-view="ContactCurrent"

Hello Community,  I am working to try and modify the ItemInfo view on the “Add Items” button of the sales order screen and running into some trouble and hoping someone can point me in the right direction. I understand I needed to extend the graph “PXGraphExtension<SOOrderSiteStatusLookupExt, SOOrderEntry>” but the ItemInfo view seems much different to modify vs other views in various forms. The goal is to limit what items can show up in the view based on some criteria entered in the sales order header. Is it possible to say, only show items where in another view? Maybe I just need to rebuild the ItemInfo view in the initialize of the graph extension? Is that possible? Thanks,Adam

I am testing Seasonality Replenishment The help is a bit vague - it says useed to reduce of increase repl qtyI am finding the factor shown below is reducing the repl qty Is this correct ?  

Hello Support Team,I’m working on a Generic Inquiry named “DB-StorageDetails” (Screen ID: IN408050) and trying to rename the column currently showing as “Site Last Modified Date” to “LastModifiedDateofWarehouseQty.”However, when I attempt to rename it, I receive the following error:“A field with the name LastModifiedDateofWarehouseQty cannot be found.”Additionally, the Caption / Display Name field does not appear anywhere in the column editor. The column is based on the field INSiteStatus.LastModifiedDateTime (and may be part of a calculated field), so I’m unable to edit its visible label.Could you please advise how to properly rename this column in the Generic Inquiry results grid or through customization?If this limitation exists for calculated or expression-based fields, please confirm whether it can be done via the Alias property or through a customization project.Thank you,Namrata  

I want to move the User Defined Field ‘Billable Expense’ from the User Defined Field tab to the first column of the Document tab.  Is there an easy way to do this? 

When we try to export the line details from the Sales Order Entry screen we get an error:  Object reference not set to an instance of an object.  Is there a way to correct this?Thank you 

I am trying to round the formula below to nearest whole number. Every way I’ve tried it get a syntax error. I am not sure where I am going wrong.  Original formula:=iif([PMBudget.Type] = 'I',[PMBudget.Amount],0) + iif([PMBudget.Type] = 'I',[PMBudget.ChangeOrderAmount],0) Here is what I entered using the round function.  When I am in the formula editor box it passes validation but then I get a syntax error after I save it.  =iif([PMBudget.Type] = 'I',(Round(([PMBudget.Amount],0) + iif([PMBudget.Type] = 'I'), 0)),[PMBudget.ChangeOrderAmount],0)