Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
S3 Interfaces/Conversion
AP520 Interface Data update from External Systems
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
HireIQ
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5264
People Online:
Visitors:
501
Members:
0
Total:
501
Online Now:
New Topics
Lawson S3 Procurement
Tolerance Settings
3/31/2025 2:01 PM
I've been trying to set a tolerance for some t
Dealing with Lawson / Infor
Printing Solutions other than MHC
3/27/2025 1:00 PM
What are others using for printing solutions besid
Lawson S3 Procurement
Green check marks in Lawson 9.0.1
3/20/2025 4:55 PM
Hi, How to remove green check mark on items when o
Lawson S3 HR/Payroll/Benefits
Pay Rate History to Show All Positions
2/26/2025 3:34 PM
Does anyone know how to modify payratehistory.htm
Infor CloudSuite
How to build a Pre-Prod tenant
2/7/2025 1:28 AM
After we finished our implementation and ended our
Lawson S3 Procurement
Browser issue with RQC Shopping
1/28/2025 5:49 PM
Since the recent Chrome/Edge updates, our RQC shop
Lawson S3 Procurement
S3-Procurement New Company
1/22/2025 10:38 PM
My Accounting Department has created a new Company
S3 Customization/Development
JUSTIFIED RIGHT
1/15/2025 7:41 PM
Is there a way in Lawson COBOL to make a character
S3 Systems Administration
ADFS certificate - new cert
12/3/2024 9:38 PM
The certificates on the windows boxes expired and
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1375
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Integration / Customization
S3 Interfaces/Conversion
AP520 Interface Data update from External Systems
Please
login
to post a reply.
12 Replies
0
Subscribed to this topic
11 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Sri
New Member
Posts: 3
8/5/2010 2:26 PM
Hello Friends,
I am new to the Lawson system and forums. I am trying to Integrate Lawson system using BizTalk tool. I do not have access to Lawson system.
I am trying to create NonPo Invoice(AP520). Does Lawson expects two .CSV files one for header data and other for Detail data.
Thanks for the help.
With Regards
Sri
John Crudele
Veteran Member
Posts: 50
8/5/2010 3:52 PM
Split
You will need two files
1) Invoice data
2) Distribution data.
If you use distribution codes you can use just the invoice upload
Sri
New Member
Posts: 3
8/5/2010 4:06 PM
Split
Hello John ,
Thanks for the reply.
Can you give me reference to any help document from Lawson which explains the entire AP520 conversion process.
With Regards
Sri
Sam Simpson
Veteran Member
Posts: 239
8/5/2010 4:14 PM
Split
This is incredible!! You want to work with Lawson system but you have not any functional knowledge of the interface files needed by AP520. If you are an outside vendor then here are some option:
1. You can send one single csv file but you will need somebody in Lawson side to map you data into either two or three staging files that AP520 needed (depending on needs). OR..
2. You can create the staging files themselves as long as you know what the requirements are in Lawson:
APCINVOICE - Invoice data
APCDISTRIB - Distribution data and or
APCATTACH - Usually data to be used for check printing.
Good Luck
Ragu Raghavan
Veteran Member
Posts: 477
8/5/2010 4:26 PM
Split
Get yourself access to the Lawson support site. You will find tons of information there.
Sri
New Member
Posts: 3
8/5/2010 4:56 PM
Split
Hello Ragu,
Now I have access to mylawon.com and internal Laswon server also - I am looking for a document which can help me in understanding the entire process or transactions which I need to go in Lawson Portal.
Till now I figured out I need to conevrt data into .CSV format which lawson is expecting, dump the files into Lawson Directory, run the IMDBB job but still yet to figure out where to display or check the uploaded AP520 data.
Thanks for the help friends.
With Regards
Sri
Ragu Raghavan
Veteran Member
Posts: 477
8/5/2010 5:58 PM
Split
Go to the Get Support TaB, - Knowledgebase - enter AP520 in the Search Box and browse
Article ID: 130158 : Interfacing Invoice Data
may be a good place to start.
Patrick
Basic Member
Posts: 6
8/7/2010 3:36 AM
Split
Depending on your database, you may need to set switch fields on the APCINVOICE file to make the AP520 run correctly. (iSeries/DB2). As others have said on here, review the doc in mylawson.com.
Barry Ghotra
Veteran Member
Posts: 63
9/12/2010 3:59 AM
Split
I have a situation where I need to electronically bring invoices from another system or a 3rd party provider that handles reimbursement expenses. Some times these payments need to be processed from Lawson but in certain cases the payment might have been posted as a direct deposit by the 3rd party provider.
I understand that I can load the data into APCINVOIC APCDISTRIB and then run the AP520 to populate the application tables etc. But what about the pre-paid invoices. I also noticed the CVI-REC-STATUS and CVI-POSTING-STATUS fields and most likely these need to be set to 9 for the pre-paid invoices. But do I need to do anything else like run another interface (CB500, but we don't use cash ledger) or populate APCPAYMENT (I think this is only for split payments) to accomplish the same?
I would appreciate any help or pointers for this situation.
Thank You.
Mark F. Hardy
Veteran Member
Posts: 45
8/10/2011 5:01 PM
Split
We, too, will be using Biztalk to integrate with Lawson. Our project team has asked me about Acknowlegements back to Biztalk from Lawson once we drop the APCInvoice and APCDistrib. Anyone know where I can find more on this topic. Lawson support could not find the KB article mentioned above. Thanks!
Rob Conrad
Veteran Member
Posts: 73
9/23/2011 3:35 PM
Split
Hi Mark -
Lawson Process Flow Integrator is really a better tool to use for this interface - I've done several AP520 / GL165 and MA540 Financials interfaces with PFI and it's pretty easy to call "non-persistent" variables from a PFI Node object (like the APCINVOICE drop) and put that data into an email notification node. More importantly, you can also query the GEN database DURING the execution of the Interface to check AP520 job status make sure your AP520 is running without any errors.
Lawson PFI could not only handle the data mapping, but also provide you with some robust error handling and notification throughout the entire AP520 import process, not to mention kicking off the AP520 and providing end to end interface execution.
RC
Sam Simpson
Veteran Member
Posts: 239
9/23/2011 8:34 PM
Split
So here's what we do with those transactions that are processed by AP520.
1. Transactions can come from different source therefore, you get different input format.
2. We asked our source to send their files with unique file extension. The file extension indicates which source the files comes from.
3. We use ScanFileClient to watch for those file extension. If they are present then it trigger ProcessFlow depending on the extension.
3. Each process flow will map the input (using Mercator or DataStageTX) and create the APC staging files. Then sends an email to users that the file is ready for further processing.
4. If there is an error in the interface file, we send it back together with the error.
Srini Rao
Veteran Member
Posts: 149
10/3/2011 6:28 PM
Split
Sri - We do use the Biztalk to create our NO PO based EDI Invoices. Insted of creating the two or 3 CSV files, we execute the transaction services to AP52. It will create the Invoice and distrinution records and returns the errors like Invalid vendor etc., This will much easier for you insted of creating teh 3 CSv files and handling the errors in Lawson.
Srini
Please
login
to post a reply.