I'm customizing a report layout for checks and want to get the invoice's external document number/vendor invoice number to print on the check stub. When we pay a given vendor, I should be able to show our invoice number and their invoice number on the check stub. However, I can't seem to find that field in the rdlc layout (which is terribly unhelpful just seeing /expr/ for every field). Even when I opened the layout in VSC, I couldn't find this field anywhere. Do we need to create a custom field or have an extension for this? I feel like someone's done this before because it's very common to send the vendor's invoice number on the check stub...
If you can find Payment Reference field in your RDL editor, then go to Purchase & Payables setup and select the option to Copy Ext. Document No. to Payment Reference (if Payment Reference is blank). This will put the Vendor Invoice Number entered when invoicing to the payment reference field.
Let me know if this solves your problem.
Thanks, Cynthia
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.