Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
redsoxfred 9/8/2019 10:57:26 AM

Bins for the item have already been assigned for the qty fulfilled on the line

Error: Bins for the item have already been assigned for the qty fulfilled on the line

 

the following gives me error 7220 even thought i have nothing in SOP10203.  Any ideas

 

<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items xsi:nil="true" />
<taSopMultiBin_Items>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200590                     </ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<BIN>20-B-02-D      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200840                     </ITEMNMBR>
<LNITMSEQ>32768</LNITMSEQ>
<BIN>20-C-01-A      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200790                     </ITEMNMBR>
<LNITMSEQ>49152</LNITMSEQ>
<BIN>20-C-01-D      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200850                     </ITEMNMBR>
<LNITMSEQ>65536</LNITMSEQ>
<BIN>20-C-01-B      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
</taSopMultiBin_Items>


<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200590                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>68.84000</UNITPRCE>
<XTNDPRCE>68.84000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-764.1.54.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>16384</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200840                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>61.47000</UNITPRCE>
<XTNDPRCE>61.47000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-758.1.54.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>32768</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200790                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>57.87000</UNITPRCE>
<XTNDPRCE>57.87000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-779.2.51.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>49152</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200850                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>61.47000</UNITPRCE>
<XTNDPRCE>61.47000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-758.2.54.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>65536</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items xsi:nil="true" />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined xsi:nil="true" />
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>6</SOPTYPE>
<DOCID>STD            </DOCID>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<ORIGNUMB>ORD01168131          </ORIGNUMB>
<ORIGTYPE>2</ORIGTYPE>
<TAXSCHID/>
<FRTSCHID/>
<MSCSCHID/>
<SHIPMTHD>NLICS          </SHIPMTHD>
<LOCNCODE>CDIR       </LOCNCODE>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<CUSTNAME>GROUPE VISUEL IRIS                                               </CUSTNAME>
<CSTPONBR>MERCH                </CSTPONBR>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<FAXNUMBR/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHNUMBR1/>
<PHNUMBR2/>
<SUBTOTAL>249.65000</SUBTOTAL>
<DOCAMNT>249.65000</DOCAMNT>
<SALSTERR/>
<SLPRSNID/>
<UPSZONE/>
<USER2ENT>pproulx        </USER2ENT>
<BACHNUMB>PK20190903     </BACHNUMB>
<PRBTADCD>PRINCIPALE     </PRBTADCD>
<PRSTADCD>131            </PRSTADCD>
<ORDRDATE>8/27/2019 12:00:00 AM</ORDRDATE>
<MSTRNUMB>3028362</MSTRNUMB>
<PYMTRMID>CO30 MS              </PYMTRMID>
<DUEDATE>8/27/2019 12:00:00 AM</DUEDATE>
<DISCDATE>1/1/1900 12:00:00 AM</DISCDATE>
<REFRENCE/>
<CURNCYID>CAD            </CURNCYID>
<RATETPID/>
<EXCHDATE>1/1/1900 12:00:00 AM</EXCHDATE>
<DYSTINCR>0</DYSTINCR>
<RTCLCMTD>0</RTCLCMTD>
<TIME1>1/1/1900 12:00:00 AM</TIME1>
<COMMNTID>ARRIVAGE       </COMMNTID>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<UpdateExisting>1</UpdateExisting>
<QUOEXPDA>1/1/1900 12:00:00 AM</QUOEXPDA>
<QUOTEDAT>1/1/1900 12:00:00 AM</QUOTEDAT>
<INVODATE>9/3/2019 12:00:00 AM</INVODATE>
<BACKDATE>1/1/1900 12:00:00 AM</BACKDATE>
<RETUDATE>1/1/1900 12:00:00 AM</RETUDATE>
<PRCLEVEL/>
<TAXEXMT1/>
<TAXEXMT2/>
<TXRGNNUM/>
<TRXFREQU>1</TRXFREQU>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>

Version: GP 2013
Section: eConnect








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables