"Multiple lines found: PO#XXX, Line item XXXX" error message in POP Receivings Integration

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