Sage 100

Cash Receipt Import - 2 issues 1. 3rd party vendor providing data for a cash receipts import is struggling, sigh, with getting me posting amounts for the invoice distribution 'amount posted' field. They are sending me the invoice amount, but if the invoice was not paid in full, it throws the distribution out of balance. If you don't import posted amount, import fails. I'd love to be able to invoke the auto-apply during a VI import, but don't see a way to handle this. 2. Same 3rd party vendor is sending me prepayments - I have a customer and amount but obviously no invoice detail. Can you get VI to 'auto' create a prepay? thanks for any ideas, suggestions.

And of course, you look like the village idiot in the client's eyes.... No immediate solution but you may need an intermediate program to fix it the way Sage needs to see it. I wonder if you could invoke a script to scrub data.

I was thinking about a script, or BOI, or just pointing the finger back at the vendor providing the data...

I'm with @JeffSchwenk you probably need an intermediate program to process the data from the 3rd party vendor. I've never had much luck getting the data provider to send anything other than data they capture from the original transaction (who, date, amt paid, and check number). Sometimes they can provide the distribution but not every customer provides a check stub with the payment distribution. If the payment comes in via ACH, there won't be any distribution info. As such, we generally have to do the calculation of the payment application via a logic routine and that logic is rarely the same between two customers. If your lucky, it will be a FIFO process. However, late fee's, open adjustments, and partial payments always get to be a challenge. On prepayments, are you using PO's? If so, your payment needs to go to a GL account rather than a prepaid invoice and the PO document needs to be updated. Workflow automation is always fun. The workflow and decision tree definition is the critical starting point.

I just did something like that for a Sage 300 customer and most of the programming time was spent working around stupid customer tricks (I wish my customers would pay invoices twice as much as theirs do, and Accpac will NOT let you overpay an invoice in cash receipts) and it still requires some manual intervention because some customers put info other than the invoice number in their ""invoice"" field on the stub, etc...

Thanks everyone for the input. If VI could only run if, then statements so much more could be done without resorting to an intermediate process. @ShawnSlavin - they are using a 'FIFO' payment distribution, are you saying have some logic for that? I'd great appreciate your insight. No, that aren't using POs, so no worries about deposits on orders, these are truly prepayments. What a pain @PhilMcIntosh - no overpayments in Sage 300? And I thought I was having a tough CR import...

Apparently, the Canadians do not make those silly overpayment mistakes....

If only pigs COULD fly, then a lot of things would happen!!

Just a follow-up I was able to get the 3rd party vendor to see the light and provide me with a file in the format for import.