Sage 100

I am trying to import AR Invoice adjustments using VI (MAS 90 4.5.5). I have defaulted the field ""H.Adjustment"" to Y for all records. When I run the job, the Header message is ""WARNING! Invoice number already used. Would you like to accept?"" The Line message is ""L record AddLine[] Failed. Missing or invalid header."" Any suggestions on how to correct this job? Thanks

Try importing the bare minimum like customer #, invoice #, sales code and qty to see if the error happens, also use a batch # too

What, exactly, are you trying to accomplish?

What I am trying to do is to import over 800 invoice adjustments to invoices that have a balance that will not be paid. We are bringing invoices to zero. The VI job was very simple; invoice#, div #, customer #, invoice date, item code, item type=3, extended amount, with type=IN, adjustment=Y. What was missing was the batch # field. Once I added that, all went perfect. Thanks Jim for mentioning the batch #.

That batch # is a killer!!!

It sure is. That's my #1 wish for VI - change the error message to tell you it's the batch number that's missing.

Have you posted it on the Idea web site (the number one source of Lori's ideas)? Let us know so we can stuff the ballot box.

Why not just do a zero dollar cash receips and zero out to bad debt or sales etc. You can highlight all those invoices in probably 10 seconds.