Inventory - Reporting sale evaluations
WE NEED TO BE ABLE TO GET MONTHLY SALES TOTALS OF THE INDIVIDUEL PRODUCT ID CODES
IS THERE CURRENTLY ANY WAY TO DO THIS
WE HAVE THREE WAREHOUSE LOCATIONS PREFIXED WITH WAREHOUSES CODE AND 20 VARIATIONS OF PRODUCT IN SIZES AND TYPES AND WE NEED TO SEE EASILY WHAT IS SELLING MOST ETC IN EACH OF THOSE PRODUCT CODES
IS THIS POSSIBLE
PETER J FCA
PETER JONES
shared this idea
HI team, returning to the idea here we will mark this as delivered. As noted in my last update - With the Inventory item Summary report you'll be able to filter to only select the items you're wanting to view and can add columns to view Opening & Closing Balance or Quantities, as well as those sold in the period the reports being run.
Alternatively, you could run the Receivable Invoice Detail report. This'll only include sales of items, and the report includes the Item Code column by default.
You could also set the report up to Group by Item Code, so sales of each item are listed together, complete with totals for the date range.
-
PETER JONES
commented
need to be able to see total sales of each inventory item description