Skip to main content

Hi, we have customized the SO641010 (Sales Order) report. We are accessing attributes from the Stock Items Screen according to the inventory item in the sales order line. There is a new requirement, that if a Sales Order is in open or closed state then these Attribute Values can't change (should be the previously set value) if that particular Stock Item's attributes are changed to a new value. How can this requirement be satisfied?

The join used is attached below.

Hi @TharidhiP ,

The stock item attributes are saved with the stock item, not the sales order line.  I think to meet this requirement you would need to create a user defined field on the SOOrderLine table and a customization to copy the stock item attribute from the stock item when the line is created.

Hope this helps!

Laura

Thanks @lauraj46 for the suggestion, will this ensure that the previous value is picked and not the current value given to the Attribute in the Stock Item screen? The customer wants to retrieve the old value they use in the attribute.

Hi @TharidhiP ,

Yes, if you create a customization to create and populate a user defined field on SOLine.  You would need to copy the attribute value from the stock item to the sales order line.  Then your reports could use the value that is saved on SOLine.

Laura 

Hi @lauraj46,

Thank you for the clarification!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved