Purchase Orders - Partial Receipts and $ Amount Outstanding
Hi,
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.
thanks
Rob
Comments
-
Hmm ... I've just had a play around with the reports - including like you, creating a custom one from scratch - to display the open qty & $ amounts - & it looks like you're right Rob ... The "Open" (& manual customisation to show only "Open") actually only displays the PO line total $ amounts! ๐ฃ๐ One would expect an "Open ..." PO report to actually display the "Open" amounts!
I'd recommend voting (if someone 's already listed it) or otherwise, adding this, to the Ideas/Wish List: https://ideas.reckon.com/
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
1 -
This requires RAH /API/SDK work ,if you need, any thing to do with Unused PO COSTING etc
Even Intuit version does not have it their Quckbooks version is far more advanced then what we have!
Yes , this can be done using above tool
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 ๐ข Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 ๐ข Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 36 ๐ข Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos ๐ฅ
- 28 Reckon Mate App
- 2.7K Reckon One
- 12 ๐ข Reckon One - Announcements
- 12 Reckon Invoices App
- 22 Reckon Insights
- 100 Reckon API
- 309 Point of Sale
- 1.9K Personal Plus and Home & Business
- 69 About Reckon Community