eConnect for invoice matching against a PO

(0) Share

Report

Posted on by Community Member

I created an eConnect integration to match Receipts against Purchase Orders in Dynamics GP. The integration works fine when there is no tax.

But when there is tax I get Error Code 4805 which is "taPopEnterMatchInvHdr, Tax detail amount does not match the header tax amounts, POPRCTNM, TAXAMNT FRTTXAMT MSCTXAMT,"

There is no Freight Tax or Misc Tax.

I'm using these two eConnect stored procedures (from within TIBCO Scribe): taPopRcptHdrInsert and taPopRcpLineInsert

I'm testing with one header record and one detail record. I verified that the Tax Amount is the same in both the header and detail.

Do I also need to use: taPopRcptLineTaxInsert?

We're on version 2018 of Dynamics GP.

Thank you.

-Michael

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Looking at this error information in the taPopEnterMatchInvHdr procedure:

select @TAXAMNTH = (isnull(sum(TXDTOTTX),0)) from POP10360 (nolock) where POPRCTNM = @I_vPOPRCTNM and RCPTLNNM <> 0 and BKOUTTAX = 0

if (@TAXAMNTH <> @I_vTAXAMNT + @I_vFRTTXAMT + @I_vMSCTXAMT)

begin

select @O_iErrorState = 4805

It does look like these values have to be manually entered, which is what I verified speaking with my resources as well.

The taPopIvcTaxInsert procedure you mentioned does have these values in it, that you can specify, so may be what you want to look at:

@I_vTAXAMNT numeric (19,5)=0,

@I_vFRTTXAMT numeric (19,5)=0,

@I_vMSCTXAMT numeric(19,5)=0,

Thanks

Was this reply helpful? Yes No