web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / taPAMiscLogLineInsert ...
Microsoft Dynamics GP (Archived)

taPAMiscLogLineInsert Error Description = You can not adjust an item that does not exist in history Node Identifier Parameters: taPAMiscLogLineInsert

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,306

Hello Friends,

I am getting following error while integrating PA Misc Log using eConnect for type "Reference".  I can add data manually without any issue but while using eConnect error occured.

FYI - 

"taPAMiscLogLineInsert Error Description = You can not adjust an item that does not exist in history

Node Identifier Parameters: taPAMiscLogLineInsert"

Below is xml file for your reference.

<?xml version="1.0" encoding="UTF-8"?>

<eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance"><PAMiscLogExpenseType><eConnectProcessInfo xsi:nil="true"/><tarequestertrxdisabler_items xmlns:xsi="www.w3.org/.../XMLSchema-instance" xsi:nil="true"><taRequesterTrxDisabler_Items xsi:nil="true"/><tapamiscloglineinsert_items><taPAMiscLogLineInsert_Items><taPAMiscLogLineInsert><PSMISCLTRXTYPE>1</PSMISCLTRXTYPE>

<PAMISCLDOCNO>ML000000000000007</PAMISCLDOCNO>

<PADOCDT>19-04-2018</PADOCDT>

<PSMISCID>GENEXP</PSMISCID>

<PAREPD>17</PAREPD>

<PAREPDT>22-04-2018</PAREPDT>

<CURNCYID>Z-US$</CURNCYID>

<LNITMSEQ>120</LNITMSEQ>

<PADT>22-04-2018</PADT>

<PAPROJNUMBER>COHONETNETWI</PAPROJNUMBER>

<PACOSTCATID>COMMUNICATION </PACOSTCATID>

<PAQtyQ>10</PAQtyQ>

<PAUNITCOST>20</PAUNITCOST>

<PATOTCST>200</PATOTCST>

</taPAMiscLogLineInsert></taPAMiscLogLineInsert_Items><taPAMiscLogHdrInsert>

<PSMISCLTRXTYPE>1</PSMISCLTRXTYPE>

<PAMISCLDOCNO>ML000000000000007</PAMISCLDOCNO>

<PADOCDT>19-04-2018</PADOCDT>

<BACHNUMB>TEST</BACHNUMB>

<PSMISCID>GENEXP</PSMISCID>

<PAREPD>17</PAREPD>

<PAREPDT>22-04-2018</PAREPDT>

<CURNCYID>Z-US$</CURNCYID>

<PATQTY>10</PATQTY>

<PAtotcosts>200</PAtotcosts>

<RATEEXPR>0</RATEEXPR>

<DYSTINCR>0</DYSTINCR>

<TRXDTDEF>0</TRXDTDEF>

<RTCLCMTD>0</RTCLCMTD>

</taPAMiscLogHdrInsert></PAMiscLogExpenseType></eConnect>

*This post is locked for comments

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Sandip,

    Are you getting an error 1079 from eConnect

    If so, looking at that procedure, this error is caused by the following:

    if (@I_vPSMISCLTRXTYPE=2)

    begin

    if (@PAReference_Line_Seq_N='')

    begin

    if not exists(select 1 from PA30301 (nolock) where PAPROJNUMBER=@I_vPAPROJNUMBER and PACOSTCATID = @I_vPACOSTCATID

    and PADT=@I_vPADT and PAREFNO=@I_vPAREFNO)

    begin

    select @O_iErrorState = 1079  

    Hope that helps

  • Community Member Profile Picture
    Community Member on at

    I am getting Error  

    Error Number = 1924  Stored Procedure= taPAEmpExpenseLineInsert  Error Description = Reference Document Number does not exist in the Line History table
    Node Identifier Parameters: taPAEmpExpenseLineInsert
    PAerdocnumber = EE000000000000102
    LNITMSEQ = 100
    Related Error Code Parameters for Node : taPAEmpExpenseLineInsert
    PAertrxtype = 2

    Thanks

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    For error 1924 on this taPAEmpExpenseLineInsert procedure, the script it is looking at, is the following:

    if not exists(select 1 from PA30501 (nolock) where PAerdocnumber = @I_vPAREFNO and  PAPROJNUMBER = @I_vPAPROJNUMBER and PADT=@I_vPADT)

    If this script doesn't return anything it will generate a 1924 error message.

    In the XML above, I see a @I_vPAPROJNUMBER value and a @I_vPADT value, but I don't see any @I_vPAREFNO value, so that may be causing this error if this value isn't being passed to the eConnect procedure.......

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans