40
i have POs that are related to different vendor accounts and i can find the total of all POs but if i make payments to different vendor accts how do i find the balance for unpaid Purchase Orders?
*This post is locked for comments
You will also have to take PO Returns into consideration. I know I modfied the Received Not Invoiced report to take this into consideration. It is for GP 10. I could send you the package file.
Darry,
Can you please give us your definition of 'unpaid PO' in as much detail as you can?
yes it is for the total of all upaid PO's
Scenario:
Open POs:
Vendor A: $2000
Vendor B: $3000
Vendor C: $4000
Total on all POs: $9000
Make payments to following POs:
Vendor A : $2000
Vendor B: $1000
How do i generate a report to show that the total unpaid balance of outstanding POs to be $7000?
Not sure if this scenario helps
Francisco and Victoria, couldn't this be done with the PO Status report by modifying it in RW to add a vendor subtotal footer? Maybe I am misdirected as far as what the question is. I am assuming it is for the total of all unpaid PO's.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
Francisco, yes possibly. And the other half may be something like this view: victoriayudin.com/.../sql-view-what-check-paid-purchase-order
To me, the first step here should be defining the requirements very carefully based on the actual workflow in this organization. I have worked with more than one company that entered POs and receipts in POP, but entered the invoices directly in AP (or PM). Not how GP was designed to work exactly, but there are various reasons these companies had for doing it this way. In those cases, none of this logic works.
Victoria, could the Received not Invoice Report be kind of half of what the user needs?
If I am understanding the question correctly, part of the problem will be that GP out-of-the-box does not apply or link payments to PO's. So for example, if you need to prepay a PO, often there is no invoice, just a payment sitting on the Vendor account. Or there is an invoice, but it's not tied to the PO, since the PO has not been received/invoiced yet. Only when the PO is received and then invoiced and the payment is applied to that invoice can you see a relationship between payment and PO.
I think in most cases it should be possible to get this type of reporting done, but probably not with anything out-of-the-box in GP and not something generic that will work for all companies out there. This would have to be a custom report that takes into consideration the specific workflow of your organization. And it may require some changes (or at least standardization) to how transactions are entered to allow for accurate reporting.
I cannot think of a single report that would give this information, but I think it would be the total of the received not invoiced report and the total of all new, released and change order PO's( PO status report). These are all found under Reports>Purchasing/Analysis.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
