Purchase Orders - Partial Receipts and $ Amount Outstanding

RobK
RobK Member Posts: 3 ✭

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

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,191 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    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

    [email protected]

    https://accounted4.com.au

    (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!)
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,065 ✭✭✭

    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