Sage 100

Has anyone successfully written a VI job to import adjustments to a SO invoice via the AR Invoices file? Have a client who didn't notice a problem on an import and now we need to import line changes to existing invoices. Having no luck so far.

Beth, We typically export the entire file into Excel, make the adjustments in Excel and then import the entire Excel file back in. Make sure you have good backups of everything.

Meaning you import into the HISTORY file directly? I wanted to do it via data entry because then it will correctly fix the AR_OpenInvoice file, AR_Transaction file, history file, etc. I don't need just one file fixed - the whole schmear needs to be fixed.

Beth, No we export out the data entry file make the changes in Excel, delete the existing data entry file and import in the file from Excel.

File was already updated.

Forgot to add :-(

Beth, Please fee free to call me at 913-312-8999 Ext 4.

Kim - Will have to be later - leaving now for an on-site

Beth, I believe you can import into SO_InvoiceHeader with the invoice type = AD (adjustment) for all invoices that need to be adjusted.

Hi Beth - What version are you working with?

I'm back. Version is 4.40. Didn't know there was a type AD in SO Invoice - I know if I try to manually enter an invoice number that has been used in SO, it bounces me out and doesn't let me choose the adjustment, which is why I was doing it via AR Invoice Entry.

I've used AR Invoice Entry for simple changes, but if you have line item changes, I don't think AR is the way to go (since inventory items can't be entered there). You may be better off importing changes as CR or DR memo's in SO...or just credit them out completely and reimport as new invoices.

Client had to do it manually due to time constrictions, but I'm still curious about being able to do it. Here was this situation - invoices imported thru SO in this case used /CREDIT as line item (so doesn't matter if SO or AR). The invoices also import in the deposit field because they are all paid (or debited in this case) by credit card so we want a zero balance. BUT the folks who create the file for importing screwed up this file and the field that was used for the line Extension was accidentally 0. So the invoices imported with a /CREDIT line with 0 amount, but imported in the full (negative) deposit. The invoices are sitting in AR with a balance because of the deposit field. So what I wanted to do was to import just a /CREDIT line with the appropriate extension as an adjustment on the invoice, so it would zero the balance in AR (and also post correctly in GL, since we had a posting to AR when we shouldn't have had one, had the balances been zero). But any import I tried told me either I had to have lines, or something about the invoice number being invalid, although it also showed me that it was a duplicate invoice number. I had Adjustments set to Y, but obviously that didn't matter (I moved it to the very first field, too, just in case). Have another client where it would be helpful in AP on a mass adjustment basis, too, to be able to import in AP Invoice Data Entry adjustments, not new invoices. Since the Adjustment field is available, I don't see why they haven't correctly written the imports to allow you do to this.

Don't have access to it now, but a client on 4.3 imports invoices into AR. Occassionally, they duplicate the import and without any special consideration, the duplicates appear as adjustments (doubling the original invoice). They don't own SO, but I'm thinking that maybe the same will occur if you just import normally.

Not in 4.4. Dang that old 4.4. I'm pretty sure I used to have the same thing in prior versions, but 4.4 is being stubborn.