Using Importdb to import invoices from various vendors

Legacy Contributor

We have multiple vendors that aren't supported via EDI, but have lots of inovices, so they send us an Excel spreadsheet of their invoices. We have a spreadsheet that we got from someone at Lawson - although we don't know who - that helps us put our data in the correct columns and prepares it for IMDBB (version 9.0.1). The problem is we now want to start adding freight charges to this upload and need to add he following fields: AOC-FC, AOC-CODE, AOC-AMOUNT. Lawson isn't able to tell us what columns this data should go into. Can anyone out there help us out? I've attached the file we use for the IMDBB import. (NOTE: This is not for MA540.)

Legacy Contributor

We have a spreadsheet that we use to upload NON PO invoices into APCINVOICE and APCDISTRIB. This is updated as of 9.0.1. I dont see any columns related to AOC except column AO PO AOC Code and is two digit field on the APCDISTRIB tab. You can email me - karen.b.pierson@healthpartners.com