Product: Dynamics GP (Enterprise)

Article Link: http://help.truecommerce.com/en/articles/6434431-dynamics-gp-enterprise-blackhole-odlfs

Whenever you're setting up a new partner for the first time, or configuring a new ODLF for an existing partner - it's often helpful to start with a base.

What is a Blackhole ODLF?

A Blackhole ODLF has a single purpose, to consume as much (hence the name!) from GP as it can to be sent to Transaction Manager. Since Transaction Manager has its own built in Mapping Manager having all this additional data is the easiest way to allow full control through our Mapping Manager, avoiding the hassle of mapping something in Mapping Manager to realize it's not on the file in the first place.

Invoice - Blackhole (810)

000000
810,004030
HDR
BIG,CCYYMMDD,YES,CCYYMMDD,YES,YES
CUR,BY,USD
REF,IA,FIND
REF,19,FIND
REF,DP,FIND
REF,CO,FIND
REF,BM,ASNBOL,,,,,,,,ITM
REF,CN,ASNPRO,,,,,,,,ITM
N1,FIND,ST,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,FIND,BS,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,FIND,BT,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,VENDORINFO,RI,YES
N2,VENDORINFO,YES
N3,VENDORINFO,YES,YES
N4,VENDORINFO,YES,YES,YES,YES
N1,FIND,SU,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,FIND,VN,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
ITD,01,3,YES,TERMSDUEDATE,YES,CCYYMMDD,YES,YES,,,,YES
DTM,ACTUALSHIPDATE,011,CCYYMMDD
FOB,YES
LNE
IT1,YES,YES,YES,YES,,ESIITMCMT1,ESIITMCMT1,ESIITMCMT2,ESIITMCMT2,ESIITMCMT3,ESIITMCMT3,ESIITMCMT4,ESIITMCMT4,ESIITMCMT5,ESIITMCMT5
PID,F,,,,YES
FTR
TDS,YES,YES,YES,YES
TXI,SP,YES
CAD,YES,OR,YES,YES,YES,,CN,BOLSOP
CTT,YES,YES

Advance Ship Notice - Blackhole (856)

000000
856,004030
SHP
BSN,00,YES,CCYYMMDD,HHMMSS,0001
HL,YES,,S
TD1,YES,YES,,,,G,YES,LB
TD5,,2,YES,YES,YES,,,,,,,G2
REF,BM,BOL,,,,,,,,ITM
REF,CN,PRO,,,,,,,,ITM
REF,21,BOLFRMSLSTRCKNUM,,,,,,,,ITM
DTM,ACTUALSHIPDATE,011,CCYYMMDD
N1,FIND,ST,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,FIND,BT,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,FIND,VN,YES,92,YES
N2,FIND,YES
N3,FIND,YES,YES
N4,FIND,YES,YES,YES,YES
N1,VENDORINFO,SF,YES
N3,VENDORINFO,YES,YES
N4,VENDORINFO,YES,YES,YES
ORD
HL,YES,YES,O
PRF,YES,,,CCYYMMDD
REF,IA,FIND
REF,CO,FIND
PAC
HL,YES,YES,P
MAN,GM,YES,,CP,ONEBOLFRMSLSTRCKNUM
ITM
HL,YES,YES,I
LIN,ITM,ESIITMCMT1,ESIITMCMT1,ESIITMCMT2,ESIITMCMT2,ESIITMCMT3,ESIITMCMT3,ESIITMCMT4,ESIITMCMT4,ESIITMCMT5,ESIITMCMT5
SN1,,YES,ESIPO1UOFM,,YES
PID,F,08,,,YES
DTM,EXPIRE_DATE,036,CCYYMMDD
FTR
CTT,YES

Purchase Order Acknowledgement - Blackhole (855)

000000
855,004030
SET
CHK,DQTY,DLACTHREQDATE,DQTYCANCEL
HDR
BAK,00,BAKRD2|AC0|,COL10|Customer PO Number,COL10|Document Date,,,,,,TBLHeader,,DAT84
N1,ST,COL8|ShipToName,,,,,,TBLLine
N3,COL5|Address 1,COL5|Address 2,,,TBLHeader
N4,COL6|City,COL6|State,COL6|Zip Code,US,,TBLHeader
ITM
PO1,LINECOUNT,COL15|QTY,COL15|U Of M,COL15|Unit Price,,VP,COL18|Item Number,UP,COL18|ESI UPC Number,,,,,,TBLLine,,,TBLESI_Inventory_XREF,TBLESI_Inventory_Global_XREF,SNDF3|2,QTY2
ACK,IA,COL10|QTY Allocated,EA,068,COL10|Requested Ship Date,,,,,TBLLine,,,,QTYALLOC,SNDF3|2,DAT85,QTY2
ACK,IB,COL10|QTY To Back Order,EA,068,COL10|Requested Ship Date,,,,DAT85,TBLLine,,SNDF3|2,,QTYBACKORDER,RNDR2|1,REM46|2
ACK,IC,COL10|QTY Canceled,EA,068,COL10|Requested Ship Date,,,,,TBLLine,,SNDF3|2,,QTYCANCEL,RNDR2|1,REM46|2,DAT85,QTY2
FTR
CTT,LINECOUNT

Inventory Report - Blackhole (846)

rev 8/1/22