Purchase Orders - Partial Receipts and $ Amount Outstanding
I use 3 reports for managing job materials
1 All purchase orders by job (I call it a Procurement Status Report)
2 Open purchase orders by job
3 Job Cost Report
When there is a partial delivery on a PO then $amount showing on both reports is total qty x unit price. This makes it difficult to know the $amount of outstanding POs
I can download the reports to excel and add columns to calculate the true outstanding amount of open POs.
Also, in theory you could calculate the difference between value of reports 1 & 3 above but we do not use POs for every expense on a job.
The other work around is to add a line to the PO every time you have a partial delivery to reflect the outstanding qty for the item (ie. split received and outstanding qty's).
All of the above is incredibly time consuming and frustrating when you have a lot of jobs and POs. Our Project Managers are continually unhappy about this. In the current supply chain environment - partial deliveries are becoming common.
Am I missing something in being able to add $ values for materials received and open items on these reports? I have also looked at trying to build a custom report without success.
- All Categories
- 6.7K Accounts Hosted
- 6K Reckon Accounts (Desktop)
- 3.2K Reckon One
- 137 Reckon Payroll Upgrade for Reckon One 🚀
- 10 Reckon Invoices App
- 939 Reckon Payroll App & Web
- 21 Payroll App - Help Videos
- 18 Reckon Mate App
- 14 Reckon Insights
- 107 Reckon API
- 952 Payroll Premier
- 120 Payroll Premier upgrade to Reckon Payroll ⤴️
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 68 About Reckon Community