Announcements
Hi:
On the A/P check stub generated from the Payment Journal, the "External Document No." does not display.
That's unfortunate, because this is the field that holds the actual invoice number of the vendor. The "Document No." field contains, instead, a system generated number. "Document No." appears on the check stub but is unhelpful for our vendors upon receiving their checks from us.
Ultimately, in the Payment Journal, "Document Date" should be the invoice date and "Document No." should be the vendor invoice number. Is it possible to make any of this "happen" for our needs?
Thanks!
John
Hi,
Add these fields by using report extension. this is missing in the standard report
Regards
Amit Sharma
www.erpconsultors.com
Did you try the setting in Purchases & Payables Setup, This is copy invoice no to payment reference
Not sure this resolves your issue but it's worth a try.
John,
Did you ever reach a solution? We are also struggling with getting External Document No on the ACH remittance advices. We had the Vendor Payment Receipts updated to include that information but I can't set that report as the ACH remittance advice. I've sent the error message to our MS partner but was hoping to find a solution in the forums.
If you choose to do so there is nothing in the system that will keep you from using the vendor invoice number as the document no.
It is not common but it is completely doable. The unique identification for the transaction will be the Entry no. in the ledger tables.
Using the document date as the date of the invoice from the vendor is pretty common. And in that case i use the posting date to control the accounting period the invoice will be posted to.
Hi, If you're talking about a standard report missing a field you need, you can use ReportExtension to add it.
More details:
Hope this will help.
Thanks.
ZHU
Is the value not in the message to recipient field? Extract it from there with a custom layout? I expect it is a modification if standard isn’t working for you
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156