Format EDI ANSI ASC X12

Format: EDI ANSI ASC X12

Gennady Kim

Continue reading

Typical mapping issues: CTT-01 in X12 856

A typical issue – when an unexperienced developer works on the outbound X12 856 documents (ASNs/Ship Notices), they often populate CTT-01 with the number of products this Ship Notice contains. Partly because of its definition of

CTT-01 354 Number of Line Items
Total number of line items in the transaction set

But for X12 856 CTT-01 should contain the number of HL groups/loops. There is a note about it in the standard:

NOTES 3/010 Number of line items (CTT01) is the accumulation of the number of HL segments. If used, hash total (CTT02) is the sum of the value of units shipped (SN102) for each SN1 segment.

Gennady Kim

Typical mapping issues: Vendor Number

Decided to start publishing very short posts about typical issues/mistakes map developers make working on the maps.

And Vendor Number is one of the things (unexperienced) developers often do not understand. For some reasons they think it is some kind of an additional document identifier, like PO number – and map it (I witnessed it multiple times) to things like Sales Order number, End Customer PO number or even PO number itself.

The reality is that Vendor Numbers are IDs buyer/purchaser assigns to its vendors/suppliers, and it stays the same across the documents with the same sender/receiver ID.

Usually it comes in Purchase Orders (X12 850) as

REF*IA*12345'

and should be sent back in Invoices (X12 810) the same way

REF*IA*12345'

In some cases it might be even hardcoded in the outbound maps.
Gennady Kim