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.
Best answer by lauraj46
Hi
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
+8Hi
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
+8Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
