News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... eConnect for invoice m...

Finance | Project Operations, Human Resources, ...

Answered

eConnect for invoice matching against a PO

(0) Share

Report

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Derek Albaugh on at

Like (0)

Report

RE: eConnect for invoice matching against a PO

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

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 601 Most Valuable Professional

#2

Abhilash Warrier 416

#3

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans