Solved

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?

 Hi everyone,I’m now trying to do some modifications to the original screen without directly change it. I have defined a lot actions in the Graph ext, and I can see those actions if I choose to directly add the action definition in original ts file, but I need to keep those changes separately for further update. I tried to declare a new export class in an extension ts file and let it extends from the origin export class, but it did not work and I just can not see the action button here. Please let know if my idea is feasible or not? If it is feasible, how should I correct my code ? Screenshots about my current Code:Original Grid setting(Shipment Package):If I add my action on above class, it will shows in the Grid toolbar as expected:But if I choose to add my action in a new extension ts file in the extension folder of this screen like below, this button will not show up: 

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

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. 

Hello Acumatica Community! We’ve run into a not good experience, issue with the latest Shopify connector for Acumatica (25R1). I’m hoping to get some insights from others who might be experiencing the same or confirm if this is an isolated problem on our end.What we observedBackground: We rely on metafields in Shopify and map another metafield from a Stock Item attribute via the connector.Normal behavior (pre-25R1): If a value existed in Shopify for one metafield, and another metafield was mapped from a Stock Item attribute, the “unmapped” metafield retained its value while the “mapped” metafield was updated as expected. Current issue (25R1): The connector now tries to update each metafield. And if there’s no mapped attribute for a metafield, connector clears it. This results in unintended data loss across the board, not just the mapped fields. Has anyone else experienced metafield data being cleared or reset by the 25R1 Shopify connector?

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

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?

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! 

Hello Acumatica comunity,i have many customers. i have a question if somehow i need to increase customer number more than (10digit) 1000000000 + 1. how we can modify or the customerid field to accept more than 10.Currently acumatica with default settings accpets only 10 Digit CustomerID 

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

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