Sage 100

Using DFDM in MAS200 4.5.4 on the AR_OpenInvoice file and can't get it to directly pull up the invoice I am looking for. I put the customer number in and get their first open invoice and then have to scroll through them. If I put the customer and invoice number (with or without the period) in it takes me to the first invoice for the next customer in the file. That damn period that shows between the customer number and invoice number seems to be screwing things up. Can anyone tell me what I'm missing?

The key is ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType, so you're probably missing invoice type to get to it directly. I generally put in the customer number, then click on the lookup. The lookup will start with that customer.

Unless the CustomerNo you entered is exactly 7 digits long what you saw is the way it works. E.g. if your ARDivisionNo = ""00"" and CustomerNo = ""A024"" and you entered ""00A0241234567"" (where 1234567 is the Invoice No and with or w/o the dots) the behavior you describe happens because the real customerNo has 3 trailing null characters (null padded). In short either do what @MichaelNottoli said or just change the Key No from KPRIMARY to KINVOICENO and then type in 1234567 and it will instantly retrieve your InvoiceNo (but now you have watch the InvoiceType and CustomerNo)

You need to define and use the Key Column Separator and you can enter the exact info and get to the specific record. If you use the separator you don't need to pad the entries with spaces.

Example, if you enter 00:BELLA:0000071 would bring up 00BELLA.0000071IN The period seems to be a system assigned default separator

Good stuff Mike!

Wow, yeah, @MikeBrown - I never knew and it's always been annoying!

Thanks for the feedback everyone and especially @Mike Brown for the tip to get around that damn period!