Ordering volume across all sites

Richard Besgrove

• February 03, 2020 00:00

Hi My customer would like to be able to run a report in Inventory (R9) showing units ordered across all locations, of a particular product, within a specified time period. Can anyone help? Additionally, seeing volumes ordered by supplier would be useful. Many thanks!

0

Download Our App

Comments

3 comments

Sort by Date Votes

• 

  Richard Besgrove

  • February 03, 2020 00:00

  Update, found a super way to do this in Fourth Analytics. Purchasing dashboard > Total Purchases by Supplier 

  =)

  0
• 

  Anonymous User

  • February 05, 2020 00:00

  Hi Rikki,

   

  I understand you want to know how to do this within Inventory itself. There is no easy way to see this, as in a report, but there is something you could do that would give you what you need with a little extra effort.

   

  Go to Master Data > find & select product > Deliv. & Transfers tab > select the top level for the Organisation filter > enter From/To dates > Search

   

  

   

  Please note:

  1. This will include transfers to sites and accounts, not just deliveries, so those records would need to be discounted
  2. This will show on screen but could be copied and pasted into an Excel file, allowing the user to add filters
  3. This can only be done for 1 product at a time
  4.  

  0
• 

  Richard Besgrove

  • February 06, 2020 00:00

  That's great, thank you!

  0

Please sign in to leave a comment.