Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 270
	Members: 0
	Total: 270

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

AP520

3 Replies

1 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Doreen

New Member

Posts: 2

3/11/2009 7:54 PM

Can someone help me locate or determine the steps required to upload invoices from our Food and Beverage system into Lawson. We are currently using LSF9+.Some of the information I have gathered is that we export the invoice data from our F&B system into a CSV file, then upload the CSV file into Lawson (via AP520?). My IT guy said he was able to "upload" 3 invoices out of F&B sys and into Lawson(???). However, when he attempted to run AP520, he got no information. Where did the files go?This part of Lawson is all new to me/us. We have been using Lawson for 5 years now trying to be more efficient using the systems we have. If anyone can assist me I would be grateful.

Roger French

Veteran Member

Posts: 549

3/12/2009 12:02 PM

There is documentation on the support website on how to do this.

Ruma Malhotra

Veteran Member

Posts: 412

3/12/2009 5:59 PM

Your upload files have to be in the format of AP52. AP52 is a program that loads non-lawson invoices into Lawson. Once you upload the invoices they go into AP52. You can then run AP520 in update mode to take these invoices into Lawson. Behind the scenes AP520 if successful then loads the invoices into AP20. On your AP520 output if you add 3 invoices you will get 3 records added. if there was an error on any of the fields while uploading you will get 3 records skipped.

John Henley

Posts: 3353

3/12/2009 6:18 PM

You would either be uploading via Excel Addins to the AP52.x forms -or- you would need to write directly into the database tables: APCINVOICE, APCDISTRIB, APCPAYMENT.