Hi guys,
I would like to ask for some expert help on a saved search/result needed.
So, we are exporters and we use the Estimate option in Netsuite to issue Sales contracts per the total quantity sold. Once we confirm all the details under the contract, we issue one Sales Order per booking of containers (one sales contract can have multiple sales orders in different period of time).
We are trying to build in a saved search to show all our contracts lists (with the entire quantity contracted) and what has been shipped, and how much remaining. I thought we could either do this as a report; or is there other way to bring this information on the sales contract based on the sales orders that were issued on that contract?
Example: we have a Sales contract for 1000MT and we issue a Sales Order for 250MT, and another one for 100MT. Once they're fulfilled it will be "shipped"=248.2MT and 99.5MT on the second one. What we would like to see on our saved search is:
CONTRACT QTY SHIPPED PENDING
SALESCONTRACT1 1000 347.7 652.3
I know we need to involve both Transactions on this but I cannot find the way of adding all the SO's if they were shipped under the same contract number.
Your help will be much appreciated.