Tax Codes and Imaging Solution into AP20.2

We have been importing invoices into Lawson for several years now. What we do is create a csv file in the format for APCINVOICE and APCDISTRIB. We then a importdb job and run AP520 to import the files. We bring them into AP20 as unreleased, our AP staff can then do any maintenance on the invoices.

Bill -

The Invoice Tax impact can easily get complicated, depending on how your organization handles the Tax. Taxes not flowing into the AP520 - would first want to insure the correct tax codes are being mapped in the Perceptive file. Second, you should review your tax rate setups - TX02, TX03 etc. and insure they are setup for Invoice. There are choices to make with regard to the whether you add Tax to the Invoice or Accrue the tax. Check that. Additionally, review the Tax Point and the Tax Terms to see how / when the application will calculate the tax - ie: on a Payment, after Terms Calculation are applied on the Invoice etc. You might want to also review the AP00.4 company setup tax tolerance tabs for any adjustments. Anyhow, don't know too much about your setup, but these are some places to start your investigation. You might also consider moving to MA540 for importing these invoices as that Invoice Interface is really better suited for handling the taxation issue, especially with the tax override code and PO Tax etc.

I appreciate the responses. Rob, unfortunately the companies that we are setting up have decided against using PO's...which would have made this much easier. I guess the issue that we are really having is the fact that I have set up the Sales Tax to be a Calculated Rate, Invoiced Tax. When we do the calculation and then try to go back and add the additional Use Tax (set up as an accrued), we get the tax distribution out of balance message. Is there anything that we are missing in regards of the set up for these?