Need help understanding MA540 and how the data looks in Lawson MA54 screens

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Lawson Newbie
New Member Send Private Message
Posts: 1
New Member
All,
I'm an EDI Analyst and trying to find some independent consultant work.
I am desperately looking for a documentation that shows what each fields are in MA540 (I think its the .csv) file and how does the MA540 data looks once it is translated in Lawson MA54 screens.

Any documentation specific to MA540 would be highly appreciated.

Thanks,

Eric
Mark Larochelle
Basic Member Send Private Message
Posts: 9
Basic Member
Here are the instructions for obtaining that information from Lawson Support:

We use this interface here in the State of NH. It is one of the more complex ones, and it differs between production versions.

Invoice Matching File Layouts for version 9.0.0 and 9.0.1

Article ID:5351441


Description:
Where can I find the Invoice Matching (MA) file layouts for versions 9.0.0 and 9.0.1?

Resolution:
To find the Invoice Matching file layouts on mylawson.com, go to the Get Support tab, click on Knowledge Base and then Product Documentation. In the Product field select Invoice Matching; in the Release field select 9.x, 9.0.* or 9.0.1; in the Search for field enter file layout; then click on Search. A list of documents will populate which include the file layouts. Note that there is a Part Number assigned to each document. You can search by Part Number as well.

Additional Information:

Keywords:
layout MA530 MA531 MA540 MACINVOICE MACAPDTL MACINVDTL MACRECADJ MACRECLINE MACRECAOC MACINVAOC

Bill Ianni
Veteran Member Send Private Message
Posts: 111
Veteran Member

John,
Can you Post this reply up under this topic.  It's a solution crosswalk for MA540.
 
 




Error Message

Solution


Unit cost required when entering invoice

Check for No Charge flag on PO line. 
Enter cost on MA54.3


PO number is required

Enter PO number and PO Code on MA54.1 MAIN


PO number does not exist

Wrong PO number or PO Code on MA54.1 MAIN


Vendor different from PO vendor

Compare PO Vendor with Vendor on MA54.1 MAIN.  They must be the same.  Use Pay To Vendor if payment needs to be routed differently.


Invoice is required

Enter Invoice number on MA54.1 MAIN


Vendor does not match vendor from header

Compare PO Vendor with Vendor on MA54.1 MAIN.  They must be the same.  Use Pay To Vendor if payment needs to be routed differently


Item is required

Item number is missing, on wrong line or potential substitute.  Verify/enter item number on MA54.3


Missing invoice amount

Enter Invoice amount on MA54.1 MAIN


Item found on multiple PO lines - line skipped

Edit line number on MA54.3


Line number not valid for PO - line skipped

Edit line number on MA54.3


Item is not on PO line - line skipped

Item number is missing, on wrong line or potential substitute.  Verify/enter item number on MA54.3


Vendor item not valid, ignored

Wrong line number or potential substitute.  Verify/enter item number on MA54.3


PO line is closed - line skipped

Compare PO line number with line number on MA54.3.  PO line may be cancelled or vendor has previously invoiced this line


Purchase order is not released

Buyer needs to fix PO


PO invoice already exists

Duplicate invoice – delete record


Duplicate invoice record found

Duplicate invoice – delete record


Item quantity required

Enter item quantity on MA54.3


Cannot enter item different from existing

Wrong line number or potential substitute.  Verify/enter item number on MA54.3


Cannot convert entered UOM to VPRI UOM

Buyer needs to add UOM in IC11


Invalid UOM for this Item

Buyer needs to add UOM in IC11


Add on cost code not valid

Delete MACINVAOC line and new line with valid AOC Code

Bill Ianni (321) 961-1739
Leslie Zvitt
New Member Send Private Message
Posts: 1
New Member
Just wanted to add one note to this article, since I've been using it quite frequently.

There is a difference between the error "Invoice already exists" and "Duplicate invoice record found". "Invoice already exists" means an unreleased invoice exists with that invoice number/vendor/company key combination, where "Duplicate invoice record found" indicates the invoice has already been processed and released.

Thanks for the great information!
SSmith
Basic Member Send Private Message
Posts: 9
Basic Member

What are the steps in using Pay To Vendor for the following error message? Please advise. Thanks!

Error Msg: Vendor different from PO vendor
Solution: Compare PO Vendor with Vendor on MA54.1 MAIN.  They must be the same.  Use Pay To Vendor if payment needs to be routed differently.