Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
3rd party Order-to-Pay To Lawson Interface
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Paula Manning
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5269
People Online:
Visitors:
431
Members:
0
Total:
431
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
Financial Management
Lawson S3 Financials
3rd party Order-to-Pay To Lawson Interface
Please
login
to post a reply.
6 Replies
0
Subscribed to this topic
43 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
RajR
Posts: 5
6/8/2010 1:21 PM
Is there a way where we can interface our 3rd part software Order-to-Pay system and interface it to Lawson for Electronic payment?
The idea is to pay electronically using our Order-to-Pay system and send over the transaction to Lawson AP for record purposes? Also I should be able to send info of Discount Codes from the Order-to-Pay system to Lawson.
There won't be any transaction happening in Lawson, but I should be able to pull up the info in Lawson, if I have to see what electronic payments were made for any particular Vendor.
Can it be done? Thanks in advance for sharing your thoughts and details.
mark.cook
Veteran Member
Posts: 444
6/8/2010 5:44 PM
Split
It sounds like you are looking to pull invoice detail into the system as historical so no transactions are happening but the invoice detail is there for viewing. You could do this with the AP520 loading invoices as historical. Enter the payment information so you can see any transaction history on the payment side. This is similar to converting historical invoices at go-live.
Let me know if that is what your looking for
Rob Conrad
Veteran Member
Posts: 73
6/9/2010 8:36 PM
Split
Yes. Mark is correct - AP520 would be used and you can add the account distribution vs. using MA540. I just built such a flow using AP520 with PFI - the flow actually uses a script to poll a 3rd Party Invoice FTP Site, retrieves the APCINVOICE and APCDISTRIB into an internal directory and then uses BCI (scan file client) to kick off PFI on the internal file capture event. I created a virtual directory on IIS to present the APCDISTRIB and APCINVOICE data into a dynamic HTML file which is displayed in an Inbasket for an appropriate approver, so they can see the data before running AP520. On the Approve - the AP520 job kicks off from the WebRun node - I run in report mode first, review and then run in update mode with error handling thrown into the mix. You can get exotic with the approvals / category filtering and/or additioanl individual Invoice Approval if you need to do that as well.
Let me know if you want more details - I'm testing and promoting this into Production next week for a client.
Ruma Malhotra
Veteran Member
Posts: 412
6/11/2010 12:48 PM
Split
If you want to electronically pay the invoices without running the payment cycle you can also use CB150 to rlease the invoices that are interfaced not into AP52 but into AP55 and then run CB554 to pay the invoices automatically by setting up electronic payments as the check type and a new cash code and bank code for the bank account from where the invoice will be ppaid.
The cash code with be an EFT type code.
Barry Ghotra
Veteran Member
Posts: 63
9/10/2010 8:14 PM
Split
Rob,
Thank you for sharing the great work that you are doing. I am doing something similar, interfacing the AP data from a third party provider. This third party is used to bring in the employee expense and amex transactions. But in some cases where the third party pays or does a direct deposit for the customer, I still need to show a payment posting record into lawson. Any idea on how you are handling that. how you are actually creating electronic trx that gets done via AP55.1/AP55.2 manually? Any insight would be helpful.
also sharing bit more details on how you use the BCI to get data into APCINVOICE & APCDISTRIB would be very much appreciated.
Regards,
Barry Ghotra
Barry Ghotra
Veteran Member
Posts: 63
9/24/2010 5:49 PM
Split
Anyone wants to chime in??
Barry Ghotra
Veteran Member
Posts: 63
10/13/2010 1:52 PM
Split
Can someone please shed some light on this. If I were to get the invoice data using AP520 as posted/closed/paid invoices and then run GL165 for the GL data via GLTRANSREL, will that accomplish the same results electronically as one would do by first creating an invoice in AP20, post payment in AP55.1 and then use AP55.2 TO RELEASE and eventually running AP265?
Any feedback would be appreciated.
Regards.
Please
login
to post a reply.