You’re offline. This is a read only version of the page.
Good day everyone,
I have a Prepayment/Advanced Payment process where I have entered a Payment in "Edit Cheque" window, put in an amount in "Unapplied Amount'' field, posted it, which GP will generate a Payment Voucher/Check Remittance thereafter. Then I enter an Invoice in "Receivings Transaction Entry" window, posted. Next, I manually applied the Payment to the Invoice in "Apply Payables Documents" window, as usual there will be no report generated after that. I am trying to look for a Report that is able to show this particular Invoice was applied to which Payment. Does anyone can give me some idea?
Note: I know that I am able to get it in the Inquiry window, and I refuse to use Historical Aged Trial Balance because it is quite lengthy, as in I will need the Report to be attach with the Payment Voucher/Check Remittance, for filing purpose.
Appreciate for your help, thank you in advanced.
Vince
*This post is locked for comments
OK,
I played around with the tables a little because I was looking for when the apply information was written to the table. I couldn't get it out of the database until I closed the Apply window. In my head I'm thinking we could use modifier to add a button to the apply window and then print a report by referencing data on the window. Feel free to call me if you want to discuss some ideas about this. Are you an SSRS person? My phone number is in the signature line.
Kind regards,
Leslie
Hi Leslie,
Thank you for the idea, I would want this Report to be printed after I manually applied the Payment to the Invoice in Apply Payables Documents window, and only specific with that documents. Don't really need a range of records, because I will attached this so called Report (that I am looking for) with the Invoice I entered, to indicate this Invoice has already applied/fully applied with this Payment.
Hi Vince,
How about using an excel report to print something. You could use two of the worksheet cells to input the vendor ID and the check number and then the worksheet would fill with the information your looking for. When do you want to print this report? are you printing for specific vendors/documents, or are you wanting something that will do a range of records?
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (