Create an inventory report that has MPN and Order in it
Gabrielle Baudinette
Member Posts: 17 ✭
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
Gabe
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
Gabe
0
Comments
-
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.
0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community