Solved

Access Inventory Attributes to Report According to Sales Order Status

T
Rank
Userlevel 3
Badge +1

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.

icon

Best answer by lauraj46 3 March 2023, 13:24

View original
3 Attachments

4 replies

lauraj46
Rank
Userlevel 7
Badge +7

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

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
T
Rank
Userlevel 3
Badge +1

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.

lauraj46
Rank
Userlevel 7
Badge +7

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 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
T
Rank
Userlevel 3
Badge +1

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