EDI Invoice Line Consolidation

Hi All, We are getting ready to do EDI Invoicing with our customers. During testing, I discovered that split lines on the Sales Order for an Item Number are not consolidated for the EDI invoice in the R42565 UBE. Has anyone come across the fix for this issue? I am in a time crunch to go live with EDI Invoicing and could use any hints or help you can provide.

Thanks,

Jer

Jer,

We use our mapping query tool to summarize the split lines via SQL. Our mapping toolset is Mercator 6.7. Depending upon the toolset you're using, perhaps you can utilize similar functionality. If not, you could probably create a separate report that would run over the F47047 table and consolidate the lines.

Hi,
Yes, we came across the same issue. Setting the ProcOpt to consolidate only works for the printed invoice. EDI still goes out with all lines because the consolidation happens AFTER EDI. It checks for consolidation after EDI but before it writes to the F42565.
Quick Fix (and it worked for us...) move the EDI code below the inserts to the F42565 in the Phase 1 section.
Mike Kissel EntOne... XE AS400