Dear All,
I am trying to make one customized report in which i will get the details of sales and quantity on hand together. Can anyone help me to reach to the goal?
Below are the field i am looking for
| Subsidiary | Data Type | Sales Date | Location | Customer ID | Serial Number | Item Name | Quantity | Price |
|---|
| Subsidiary | Sales (S) and Inventory (i ) | Date of Item sold | Fixed Location | Customer ID | Serial Number of Item | Name of Item | Quantity must be Fixed (1). If 10 Items are sold then there should be 10 single row for the same item With unique serial Number | Item Retail Price |
I have attached the report format for a reference. It will be a great help if someone can advise me how can i build above format of report in netsuite.
Thanks & Regards,
Shahid Ansari