DynDeveloper.com

Hi everyone,
I'm encountering a peculiar issue in the payables transaction approval process and would appreciate any insights or assistance. When I set a condition for the Distribution Type to be any specific value, it consistently defaults to 0 in the generated SQL query. This behavior is unexpected and seems to be an error.

I'm trying to understand the root cause of this issue and how to resolve it. To provide a clearer picture of what I'm experiencing, I've attached some screenshots below that illustrate the problem.

SQL QUERY:

SELECT 
    [PM10000].[BACHNUMB] AS [Batch Number_1]
    , [PM10000].[VCHNUMWK] AS [Voucher Number_2]
    , [PM10000].[VENDORID] AS [Vendor ID_3]
    , [PM10000].[DOCNUMBR] AS [Document Number_4]
    , [PM10000].[DOCTYPE] AS [Document Type_5]
    , [PM10000].[DOCAMNT] AS [Document Amount_6]
    , [PM10000].[DOCDATE] AS [Document Date_7]
    , [PM10000].[VADDCDPR] AS [Vendor Address Code - Primary_8]
    , [PM10000].[VADCDTRO] AS [Vendor Address Code - Remit To_9]
    , [PM10000].[PYMTRMID] AS [Payment Terms ID_10]
    , [PM10000].[DUEDATE] AS [Due Date_11]
    , [PM10000].[DISCDATE] AS [Discount Date_12]
    , [PM10000].[CHEKBKID] AS [Checkbook ID_13]
    , [PM10000].[TRXDSCRN] AS [Transaction Description_14]
    , [PM10000].[PORDNMBR] AS [P.O. Number_15]
    , [PM10000].[SHIPMTHD] AS [Shipping Method_16]
    , [PM10000].[CURTRXAM] AS [Current Trx Amount_17]
    , [PM10000].[CNTRLTYP] AS [Control Type_18]
    , [PM10000].[MODIFDT] AS [Modified Date_19]
    , [PM10000].[MDFUSRID] AS [Modified User ID_20]
    , [PM10000].[TEN99TYPE] AS [1099 Type_21]
    , [PM10000].[TEN99AMNT] AS [1099 Amount_22]
    , [PM10100].[DSTINDX] AS [Account_23]
    , [PM10100].[DISTTYPE] AS [Distribution Type_24]
    , [PM10100].[VCHRNMBR] AS [Voucher Number_25]
    , [PM00200].[COMMENT1] AS [Comment 1_26]
    , [PM00200].[COMMENT2] AS [Comment 2_27]
    , [PM00200].[VNDCLSID] AS [Vendor Class ID_28]
    , [PM00200].[ACNMVNDR] AS [Account Number With Vendor_29]
    , [PM00200].[PYMNTPRI] AS [Payment Priority_30]
FROM [PM10000] 
    INNER JOIN [PM00200] ON 
        [PM10000].[VENDORID] = [PM00200].[VENDORID] 
    INNER JOIN [PM10100] ON 
        [PM10000].[VCHNUMWK] = [PM10100].[VCHRNMBR] 
WHERE (
    [PM10100].[DISTTYPE] = 0 
 )

Hi,

Re: GP2018 econnect

What is the difference between the eConnect stored procedures taSopLot and taSopLotAuto? 

taSopLineIvcInsertComponent executes taSopLot.

taSopLotAuto is called through econnect (i.e., no separate dependencies).

We have found that both taSopLotAuto and taSopLot are executed when fulfilling kit components that have lot number tracking enabled. 

In our case, they both update IV00300.ATYALLOC with the update below, which results in this value being doubled.

UPDATE IV00300
                SET ATYALLOC=ATYALLOC+@QtyAvail, LTNUMSLD=CASE WHEN @QTYRECVD=@ATYALLOC+@QtyAvail+@QTYSOLD THEN 1 ELSE 0 END
                FROM IV00300(UPDLOCK)
                WHERE ITEMNMBR=@I_vITEMNMBR AND LOCNCODE=@I_vLOCNCODE AND LOTNUMBR=@I_vLOTNUMBR AND DATERECD=@I_vDATERECD AND DTSEQNUM=@DTSEQNUM AND QTYTYPE=@I_vQTYTYPE;

Thank you!

Our eConnect XML:

<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<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>
<taSopLotAuto>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067</SOPNUMBE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>CAP300</ITEMNMBR>
<LOCNCODE>WNC</LOCNCODE>
<QUANTITY>6.0</QUANTITY>
<BIN>2030</BIN>
<LOTNUMBR>01222024</LOTNUMBR>
<CMPNTSEQ>16384</CMPNTSEQ>
</taSopLotAuto>
</taSopLotAuto_Items>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067            </SOPNUMBE>
<CUSTNMBR>CENTERSU0001   </CUSTNMBR>
<DOCDATE>1/23/2024 12:00:00 AM</DOCDATE>
<LOCNCODE>WNC</LOCNCODE>
<ITEMNMBR>KIT-CAP300                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>20.00000</UNITPRCE>
<XTNDPRCE>20.00000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID>               </COMMNTID>
<PRCLEVEL>RETAIL     </PRCLEVEL>
<ITEMDESC>Kit Item 1                                                                                           </ITEMDESC>
<LNITMSEQ>16384</LNITMSEQ>
<SALSTERR>TERRITORY 4    </SALSTERR>
<SLPRSNID>SANDRA M.      </SLPRSNID>
<ITMTSHID>               </ITMTSHID>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID>USASTCITY-6*   </TAXSCHID>
<PRSTADCD>PRIMARY        </PRSTADCD>
<ShipToName>Center Suite Hotel                                               </ShipToName>
<CNTCPRSN>Mitch Payne                                                  </CNTCPRSN>
<ADDRESS1>8765 51 Ave S                                                </ADDRESS1>
<ADDRESS2>                                                             </ADDRESS2>
<ADDRESS3>                                                             </ADDRESS3>
<CITY>Minneapolis                        </CITY>
<STATE>MN                           </STATE>
<ZIPCODE>55401-7694 </ZIPCODE>
<COUNTRY>USA                                                          </COUNTRY>
<PHONE1>80055501190000       </PHONE1>
<PHONE2>61255501190000       </PHONE2>
<PHONE3>                     </PHONE3>
<FAXNUMBR>61255501190000       </FAXNUMBR>
<ReqShipDate>1/23/2024 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>GROUND         </SHIPMTHD>
<INVINDX>000-1300-01                                                                                                                      </INVINDX>
<CSLSINDX>000-4510-01                                                                                                                      </CSLSINDX>
<SLSINDX>000-4110-01                                                                                                                      </SLSINDX>
<MKDNINDX>000-4180-00                                                                                                                      </MKDNINDX>
<RTNSINDX>000-1330-01                                                                                                                      </RTNSINDX>
<INUSINDX>000-1520-00                                                                                                                      </INUSINDX>
<INSRINDX>000-1300-01                                                                                                                      </INSRINDX>
<DMGDINDX>000-4700-00                                                                                                                      </DMGDINDX>
<GPSFOINTEGRATIONID>                               </GPSFOINTEGRATIONID>
<INTEGRATIONID>                               </INTEGRATIONID>
<QTYFULFI>1.00000</QTYFULFI>
<UpdateIfExists>1</UpdateIfExists>
<CURNCYID>Z-US$          </CURNCYID>
<UOFM>Each     </UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items>
<taSopLineIvcInsertComponent>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067            </SOPNUMBE>
<LOCNCODE>WNC</LOCNCODE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>CAP300</ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<QUANTITY>6.0</QUANTITY>
<QTYFULFI>6.0</QTYFULFI>
<CUSTNMBR>CENTERSU0001   </CUSTNMBR>
<DOCID>SPECINV        </DOCID>
<AUTOALLOCATELOT>1</AUTOALLOCATELOT>
<CMPNTSEQ>16384</CMPNTSEQ>
<CMPITUOM>Each     </CMPITUOM>
<UpdateIfExists>1</UpdateIfExists>
</taSopLineIvcInsertComponent>
</taSopLineIvcInsertComponent_Items>
<taSopTrackingNum_Items>
<taSopTrackingNum>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067            </SOPNUMBE>
<Tracking_Number>12345</Tracking_Number>
</taSopTrackingNum>
</taSopTrackingNum_Items>
<taSopCommissions_Items xsi:nil="true"/>
<taSopLineIvcTaxInsert_Items xsi:nil="true"/>
<taCreateSopPaymentInsertRecord_Items xsi:nil="true"/>
<taSopUserDefined>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INVSP1067            </SOPNUMBE>
<USERDEF2>DN</USERDEF2>
<USRDEF05>1.0 - 1.1</USRDEF05>
</taSopUserDefined>
<taSopDistribution_Items xsi:nil="true"/>
<taAnalyticsDistribution_Items xsi:nil="true"/>
<taSopMultiBin_Items/>
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>SPECINV        </DOCID>
<SOPNUMBE>INVSP1067            </SOPNUMBE>
<SHIPMTHD>GROUND         </SHIPMTHD>
<DOCDATE>1/23/2024 12:00:00 AM</DOCDATE>
<CUSTNMBR>CENTERSU0001   </CUSTNMBR>
<CSTPONBR>                     </CSTPONBR>
<ADDRESS1>8765 51 Ave S                                                </ADDRESS1>
<ADDRESS2>                                                             </ADDRESS2>
<ADDRESS3>                                                             </ADDRESS3>
<CNTCPRSN>Mitch Payne                                                  </CNTCPRSN>
<FAXNUMBR>61255501190000       </FAXNUMBR>
<CITY>Minneapolis                        </CITY>
<STATE>MN                           </STATE>
<ZIPCODE>55401-7694 </ZIPCODE>
<COUNTRY>USA                                                          </COUNTRY>
<PHNUMBR1>80055501190000       </PHNUMBR1>
<PHNUMBR2>61255501190000       </PHNUMBR2>
<PHNUMBR3>                     </PHNUMBR3>
<SALSTERR>TERRITORY 4    </SALSTERR>
<SLPRSNID>SANDRA M.      </SLPRSNID>
<UPSZONE>   </UPSZONE>
<BACHNUMB>INVOICES       </BACHNUMB>
<PRBTADCD>PRIMARY        </PRBTADCD>
<PRSTADCD>PRIMARY        </PRSTADCD>
<PYMTRMID>Net 30               </PYMTRMID>
<ReqShipDate>1/23/2024 12:00:00 AM</ReqShipDate>
<UpdateExisting>1</UpdateExisting>
<PRCLEVEL>RETAIL     </PRCLEVEL>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true"/>
<taSopUpdateCreateProcessHold xsi:nil="true"/>
<taCreateSOPTrackingInfo xsi:nil="true"/>
<taMdaUpdate_Items xsi:nil="true"/>
</SOPTransactionType>
</eConnect>

Hi all

How do I get the next voucher number to pass to @I_vVCHNUMWK for taPMTransactionInsert?

Any help will be appreciated.

Thank you.