Trying to Build a report for Unvouchered PO Receipts

Follow

Cpinto

• December 16, 2020 22:28

Is there a way to build a report of Unvouchered receipts (PO Receipts where the Vendor Invoice has not yet been received) from the PO Line object?  

any suggestions?

0

• 

  Rebecca Ralls

  • December 17, 2020 16:21

  I usually do it from a transaction report on the vouchers payable GL account.

  Depending on whether you are using LLP or HLP, you need to create a formula field on the transaction that brings in the PO (HLP) or PO Line (LLP) from both the payable transactions and the purchase order inventory movement transactions. Then you can group your report by product and then by po/po line to see where you have a balance.

  If you also create a formula on the transaction that says what type of record created the transaction- AP, PIM, AR, JE, etc you can group the columns by that and very easily see where you have a balance in the AP column that is not offset by the PIM column or vice-versa.

  You can contact me at rebeccaralls (at) gmail.com if you’d like some help setting it up.

  0

  Comment actions Permalink
• 

  Rebecca Ralls

  • December 17, 2020 16:23

  Alternatively, if you don’t want to set up any formula fields, you can still do a transaction report on the VP GL and group it by product and see which products have a balance. - you just have to do more digging to figure out why the balance is there.

  0

  Comment actions Permalink
• 

  Cpinto

  • December 17, 2020 17:56

  Thanks Rebecca, I've got this partially built using the Transactions object and the GL Account and summarizing by Product as suggested.  I discovered they have HLP as the setting so I may need to get that changed to LLP I will look into creating the formula for the trx type.  I did something similar for another client by creating Debit and Credit columns so the report would have a more pleasing presentation.  Thanks.

   

  0

  Comment actions Permalink

Please sign in to leave a comment.