Hi Microsoft GP blog community,
please could you advise with the table name where Invoice Number and Cheque number assigned to it shown on the same lane for Payable Invoices.
Thank you
Larisa
*This post is locked for comments
Hi Leslie,
you clarified it to the perfect point. I wouldn't suggest what exact table to take from the list. And you made it clear! I appreciate a lot!
Hi Babu,
thank you so much!
To find out what checks paid down your invoice, you need to look in the 'apply' tables. Bear in mind that it isn't necessarily a one-to-one relationship. You could have any number of checks assigned to a vendor invoice. As Babu suggested, Victoria Yudin's web site will provide the exact SQL Statement you need to create a view showing the vendor invoice and all checks applied thereto. Also keep in mind that a single check can be applied to multiple invoices.
Kind regards,
Leslie
Hi Larisa,
Best place to look GP table is Victoria website, please have a look at the below link.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
