SUMMARY
You receive a 'Multiple Lines found: PO#XXX, Line item XXXX' error messagewhen you runan SQL Optimized POP Receivings Integration. You do not recieve the error message when you manually enter a transaction.
CAUSE
You are integrating the same inventory item more than once on the same receivings document.
MORE INFORMATION
TheSQL Optimizedprovider usesSQL insert statements to insert the data. The key fields in the POP_PO_Line file are the PO Number, the Item number, and the Sequence Number. If the PO Number and the Item Number are the same, in order to insert the record, the Sequence Number must be different.
You must modifyyour source file to include a sequence number in it. The sequence number will increment in multiples of 16384. If your PO has two lines that have the same item number, the first one will be sequence number 16384, and the second will be 32768.
For example, yoursource file shouldlook like this:
PO Number Item Number Sequence Number
PO100 100XLG 16384
PO100 128 DRAM 32768
PO100 24X IDE 49152
PO101 256 SDRAM 16384
PO101 256 SDRAM 32768
PO102 32 SDRAM 16384
PO102 32X IDE 32768
Noticethat the sequence number starts over every time the PO number changes.
In your destination mapping in the Integration Manager, go to the mapping for the Lines. In the mapping there is a spot to map your sequence number. Map this to the new column you have created in your source field. Now the integration will bring in duplicate item numbers for thesame PO number.
This article was TechKnowledge Document ID:29284
You receive a 'Multiple Lines found: PO#XXX, Line item XXXX' error messagewhen you runan SQL Optimized POP Receivings Integration. You do not recieve the error message when you manually enter a transaction.
CAUSE
You are integrating the same inventory item more than once on the same receivings document.
MORE INFORMATION
TheSQL Optimizedprovider usesSQL insert statements to insert the data. The key fields in the POP_PO_Line file are the PO Number, the Item number, and the Sequence Number. If the PO Number and the Item Number are the same, in order to insert the record, the Sequence Number must be different.
You must modifyyour source file to include a sequence number in it. The sequence number will increment in multiples of 16384. If your PO has two lines that have the same item number, the first one will be sequence number 16384, and the second will be 32768.
For example, yoursource file shouldlook like this:
PO Number Item Number Sequence Number
PO100 100XLG 16384
PO100 128 DRAM 32768
PO100 24X IDE 49152
PO101 256 SDRAM 16384
PO101 256 SDRAM 32768
PO102 32 SDRAM 16384
PO102 32X IDE 32768
Noticethat the sequence number starts over every time the PO number changes.
In your destination mapping in the Integration Manager, go to the mapping for the Lines. In the mapping there is a spot to map your sequence number. Map this to the new column you have created in your source field. Now the integration will bring in duplicate item numbers for thesame PO number.
This article was TechKnowledge Document ID:29284