Microsoft Dynamics GP (Archived)

Econnect not able to create tax distribution for Employee expense on PA10504

(0) Share

Report

Posted on by Prasanta

155

Hi,

I have a expense system, those expense need to integrate with the Dynamics GP using eConnect SDK.

I am able to create Header, Line and Tax based on below mention classes. But in Line item distribution it doesnt record for Tax, i can see the Tax item is missing on table PA10504, but not sure why it hasnt create, so in Distribution credit and debit amount are not same as tax hasn't created.

Header - taPAEmpExpenseHdrInsert

Line - taPAEmpExpenseLineInsert_ItemsTaPAEmpExpenseLineInsert

Tax - taPAEmpExpenseTaxInsert_ItemsTaPAEmpExpenseTaxInsert

Please help me, what parameter need to set extra as PAEmployeeExpenseType class doesn't have any property which i can set the manual distribution.

Thanks,

Prasanta

*This post is locked for comments

All responses (8)

Answers (2)

GeorgeT 245 on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Sanjay

Your unbilled account is showing $300 instead of $100 which is wrong.
Prasanta 155 on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Finally manage to put the tax on the Header and distribution.

There is an another extra tax node need to create with LINESEQ=0 to display tax on header.

Cheers,

Prasanta
Community Member Microsoft Employee on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Prasanta,

I would suggest you log on to GP and connect to the Fabricam company and check the tax setup. It will be easier to understand and configure rather than hunting tables. If you are not a finance person, I would talk to some one from accounting to set the tax codes .....TGIF

cheers!

Sanjay
Prasanta 155 on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Hi Sanjay,

Many thanks for respons.

You are right I can see the difference.

Is it possible if you can tell me the reference tables for both those fields

.ITMTSHID (Item tax schedule ID) USASTCITY-6*

.TAXDTLID (Tax detail ID). USASTE+PS6N0

I have checked in database but couldn't understand which tables are reference for those fields.

Thanks for your help :)

Thanks

Prasanta
Prasanta 155 on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Hi Sanjoy,

Many thanks for respons.

You are right I can see the difference.

Is it possible if you can tell me the reference tables for both those fields

.ITMTSHID (Item tax schedule ID) USASTCITY-6*

.TAXDTLID (Tax detail ID). USASTE+PS6N0

I have checked in database but couldn't understand which tables are reference for those fields.

Thanks for your help :)

Thanks

Prasanta
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Prasanta,

The only difference which I think matter is the

.ITMTSHID (Item tax schedule ID) USASTCITY-6*

.TAXDTLID (Tax detail ID). USASTE+PS6N0

You have both schedule and detail as same. Compare and contrast them with the set up to the two I have used at Fabricam, Inc

Cheers!

Sanjay
Prasanta 155 on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Hi Sanjoy,

Thanks for the response of my post.

I have tried the same, but still its missing the tax row on distribution.

Please find the below codes.

Please let me know if you can think of any changes on the code or setup in my account settings.

Thanks,

Prasanta
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Econnect not able to create tax distribution for Employee expense on PA10504

Hi Prasanta:

Here you go!

Setup your header as follows:

Setup your line as follows:

Set up tax as follows:

Send to create employee expense ....

With distribution ...

Cheers!

Sanjay