Create an inventory report that has MPN and Order in it

  • 1
  • Question
  • Updated 8 months ago
  • Answered
Hi there

I wish to create an inventory report combining two reports (the inventory item listing - which includes the MPN (Manufacturers Product Number) and Item Reorder report which marks which items are ready for reorder.  I have tried working with the filters on both reports and cannot get the result I require.  I am using Reckon Accounts Plus 2017

Many thanks for your help
Photo of Gabrielle Baudinette

Posted 8 months ago

  • 1
Photo of Shane

Shane, Employee

  • 7,128 Points 5k badge 2x thumb
Hi Gabe,

If you mean you want to see the "Order" column that shows a tick for the ones that need re-order, its not possible to get it on the same report as the MPN.  You could add the Reorder Point column to the item listing report, then export to Excel, and then use an IF statement to say if the reorder amount is more or equal to the quantity on hand, then reorder.  See the image below, it shows the formula I used and it is working for me.  Just enter the formula once for one item, and then you can drag it down for all other items.  Hope this helps.  Regards, Shane.