Running v10.1.17 i am able to see Supplier Invoice Number when i make payment from a single purchase invoice. But if I add multiple invoices to the payment entry it does not fetch supplier invoice number. Can anyone show me how to do this? Tried custom script but it does not seem to work.
I have the same issue. Did you figure out how to get supplier invoice number on payment entry reference child table from purchase invoice?
I am wanting to pull in bill_no and bill_date from purchase invoice to the payment entry references table which is the child table of payment entry. Is this all I need to do in custom script?
I also need to get party bill to address in the payment entry form as we print this on our checks to mail them. I’m clueless on how to get the party address.
Sure thing… I had a unique need as our checks are three part checks. Top is the actual check, next section is a listing of all invoices paid with this check and the bottom section tears off and we keep it for our records and it is a duplicate of the middle section.
So, I created a custom print format to display the supplier’s invoice number in a table the way I needed it. I gave up on the supplier invoice date. It wasn’t a necessity so I figured I would get that later possibly. For now, we just show the supplier invoice number and that works for us.
I also needed the address printed on the check. Here’s my code that does that. The first line is all I needed to get the supplier invoice number but I did add the field “bill_no” to the Payment Entry References table first.