Invoice import from non-Lawson system

We have a need to import nonLawson invoices into the BL20 for creating, printing and posting. Most of the invoices have comments and from what we can tell there is not a good way to bring this data into Lawson (either by addin or import routine, especially the comments piece). Do any of you do this? Is there some "secret" that we are missing? Any advice would be much appreciated.

We are S3, Windows, Oracle DB and v10. Thank you,

Wendy

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Comments

unknown

You can import invoices into AP using the importdb command. They would be imported into APCINVOICE, APCATTAC AND APCDISTRIB, but I don't know if BL has the same process.

unknown

Although my current employer does not use it, I have heard from other Infor Lawson clients that the Microsoft Add-ins are a very good solution. Perhaps someone who knows more about Add-Ins can say how it works to enter an invoice with comments?

info

I believe it takes 5 different files and then I still think it doesn't include the comments. We haven't found this to be feasible but it would load parts of it. Thank you for your response.

elaine-stookey

Wendy, we interface to the billing from a 3rd party system using the OIINVOICE,OIINVCCOMM, OIINVCMISC & OIINVCLINE tables. We have comments in the interface & write to the tables then run BL520 to pull them in Lawson

info

Do they come in as "historical" only? Are you able to run the BL122 to generate the invoices from that? Thank you for your help.

elaine-stookey

Wendy, we just went live on V10 on 10/17 I'm still addressing issues. Once things calm down I get you some answers. thanks

unknown

Would you be willing to share your process on loading the tables for this interface? We have created 2 flat files, 1 with header info and 1 with line detail but our IT team is stumped on how to load the header, pull back the invoice # and then load the lines. We use automatic invoice numbering (based on the process level) in our billing system and maybe that is the issue. Any help would be greatly appreciated.

jreese

Kelly, are you looking to import into AP or BL? I can assist with AP but have never used BL.

Ford GTL.pdf

unknown

BL. We currently use the AP interface. I wish Billing was as easy as the AP module.

Copyright © 2025 Infor. All rights reserved.