Would it be possible to create a report showing th...
# generalu
7px
11/05/2020, 6:29 AMWould it be possible to create a report showing the annual sales of an item based on the vendor indicated on a Purchase Order?
n
Netsuite Tragic
11/05/2020, 9:32 PMWhat is the Inventory basis? If you have multiple vendors for an item, what is the relationship to the sale of that item? For instance, a serialized item we could exactly match the PO and the Sales. But for Qty 30 from Vendor A, Qty 50 from Vendor B and Sales of 47 how would you want to represent?
Netsuite Tragic
11/05/2020, 9:35 PMOne approach I would start with is a Saved Search of SO and PO, with Groupings by Name for SO & Vendor.name for PO, Order by Item. That will give you some initial numbers to start working out how to present it.
Netsuite Tragic
11/05/2020, 9:47 PMActually skip the grouping by Customer and you could get something to start like this :
3 Views