Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Compute value of lot quantity received from IR in saved search
I have a summary saved search looking at Item Receipts, and have the value at the line level. My user wants to see this value at the lot level. How do I set up the formula so that I can allocate the amount from the line to each of the multiple lots entered. when I group by lot, the value is 0. How do I properly set the formula for
(max({amount})/max{quantity}))*{inventorydetail.itemcount}
or
max({amount})/{inventorydetail.itemcount}
I have
and want to see lot qty amount or 24,806.40*(2340/2560) = 22,674.60 for the first lot, and 24,806.40*(220/2560) = 2,131.80
Here is my search results
Tagged:
0