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!
Item Receipt vs. PO Line Data Formula (Inventory Detail Status)
Have a request in to compare the line data on a PO vs the IR and then go into the inventory detail and filter out each respective quantity on the IR line by a good or bad status.
That, I can get to populate accurately.
Main line is set to false, FYI.
Where I am having trouble is performing a calculation to sum the total PO quantity for the line - the bad quantity to show the difference.
I tried a SUM with {appliedtotransaction.quantity}-(CASE WHEN {inventorydetail.status} = 'Bad' THEN {inventorydetail.quantity} ELSE NULL END)
But it's not close to accurate. I think it's taking the total of all lines on the PO, but I'm not sure.
0