Print checks in Vendor Invoice number order

bhagan

Has anyone had the request to have the remittance information on checks to show in vendor invoice number order?

NavStudent

define remittance and what table/field is this comming from?

Savatage

In The Report 1401 Check i see the PrintSettleLoop with DataItemTableView: SORTING(Number)

looking at my check it definately prints all credit first then all invoices
but either TYPE is not in Document No Order.

**Misc Bonus Info**
http://www.mibuso.com/forum/viewtopic.php?t=13580

I've never tried to change to order - I really never thought about making the person I have to pay's life easier

bhagan

We are not doing it to make the vendor's life easier, but because our A/P sometimes has to put the same invoice number on several PO's, so they use the vendor's invoice number with an ending of "A", "B", etc.

When we send the checks over to be signed, the signer wants the invoice numbers in order.

I have changed the "Suggest Vendor Payments" to put the Vendor ledger entry into the G/L entry's "External document no.", then put a key on that field to allow us to print.

Now the problem is that when we use "Suggest vendor Payment, all entries post with the "Check for Vendor XXXX" instead of the vendor's name. Also, the G/L entry does not refer to the vendor number except in the description.

Does anyone else have these problems? How do they fix it?

Savatage

bhagan wrote:

Also, the G/L entry does not refer to the vendor number except in the description.

What's your Source No. then?