MA540 - Month End Closing error message of "Date is before closing control date"

Interested in how other companies are handing month-end closing with EDI invoices coming in that are dated before the closing control date (from GL). We close AP and PO month-end on the first of the month. The file with invoices from EDI vendors dated on the first of the month then error out when the file is processed through MA540. My apologies if there is already a thread on this. I could not find one.

Ellen

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

unknown

I reached out to our AP analyst who has given this reply:
Our AP supervisor has a query template that dumps the header data from MA54 into Excel. She then changes the post date and uploads the change back to MA54. The whole process takes about 5 minutes.
At another Hospital, the system admin created a script for the EDI file to default the current date to the post date field. Hope that helps.

jon-athey

From brenth in a post in Infor Lawson Financials Group:

"KB 1541139 Set Default Invoice Posting Date
Summary
This enhancement to Infor S3 EDI for Supply Chain Management (ESCM) provides the ability to set the invoice posting data for ASC X12 810 electronic invoices processed through ESCM and loaded through MA540 to the date the 810 was processed."

KB 1541139

Background
Electronic invoices, EDI 810 invoices contain an invoice date not a posting date. If no posting date is specified when processing invoices, the invoice date is defaulted to the posting date. If an electronic invoice is processed after performing month end closing and the invoice date is in the closed period, the invoices cannot be loaded

Resolution:Change
Added a new ED40 Data Substitution record (SET_INV_POST_DATE) specific to trading partner id (tpid) or all trading partners. EDI for Supply Chain Management will check for the ED40 record and set the invoice posting date to the current processing date if enabled.

Setup: Add ED40 record

List Name: SET_INV_POST_DATE
Lawson Value: Y
External Value: trading partner id (tpid) or * (for all trading partners)

Product Version: 10.0.4.1 (Supports 10.0.x and 9.0.1.x applications)
Files: laws_inb_91, laws_inb_91_la4010, laws_inb_91_ghx
Requirements: Infor Lawson 10.0.x or 9.0.1.x
Reference(s): JT-605727

unknown

Jon A.

I am fairly new at building ED40 records. I feel like I have a pretty good handle on it, but I am a bit confused on one portion of your post. What exactly do I need to build if I want this substitution record "for all trading partners?" I am really excited about the possibility of not having to manually work all of these invoices out of MA54.8 in the future. It is a real pain

Appreciate any help.

unknown

External value = *

You set that field equal to asterisk in ED40

unknown

Great information. We are getting ready to upgrade from 10.0.2 to 10.0.6 and this will come in handy. Thank you for sharing.

unknown

Mary Beth,

I built this substitution table on March 3rd. It did not work for me. On 4/01, I had the same fatal errors in MA54.8. I built it just like your example. Am I missing something?

Thanks!

Copyright © 2025 Infor. All rights reserved.