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

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

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

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!

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.