i want to build one report show the following : item opening balance quantity receipt from purchase order and column for quantity receipt from customer return and column for sales and column for net sales using suite analytics

AI generated answer (using internal Slack threads):

To build a report showing item opening balance, quantity receipt from purchase order, quantity receipt from customer return, sales, and net sales using Suite Analytics, you would need to create a custom report or saved search. Here's a general guideline on how you could approach this: 1. Item Opening Balance: This could be calculated by subtracting the quantity sold from the quantity on hand. You can get these details from the item record. 2. Quantity Receipt from Purchase Order: You can create a saved search on the transaction type 'Item Receipt' and filter by the source type 'Purchase Order'. Sum the quantity for each item. 3. Quantity Receipt from Customer Return: Similar to the above, create a saved search on the transaction type 'Item Receipt' but this time filter by the source type 'Return Authorization'. Sum the quantity for each item. 4. Sales: Create a saved search on the 'Sales Order' transaction type and sum the quantity for each item. 5. Net Sales: This could be calculated by subtracting the quantity of customer returns from the quantity of sales. Remember to group your results by item in each of these saved searches to get item-wise details. Once you have these saved searches, you can use SuiteAnalytics Workbook to combine these searches into one report. You can join these searches based on the common field 'Item'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******