Sales Order Taxes For Dynamics GP

(0) Share

Report

Posted on by Charlie22

I need to set the tax on individual orders as taxable/non-taxable (cannot be done on customer record).

For some reason no matter what I pass into the CreateSalesOrder call for the web services, it will not save the tax information.

I've tried:

Using the CreateSalesInvoice policy which has had "Create Taxes Behavior" set to "Taxes will be provided"
Overrode policies using "Use Header Level Taxes Behavior" and "Create Taxes Behavior" all 4 modes have been tried.
Provided taxes as a total on the Sales Order
Provided taxes as a tax detail on the sales order
Provided taxes as a total on the line item
Provided taxes as a tax detail on the sales order
Set the TaxScheduleKey on the order
Set the TaxScheduleKey on the line items

Taxes just get blanked out in GP, it's infuriating... Any ideas? I do have access to the Dynamics database but I'd really rather not go that route if possible.

My research has led me to believe that this is broken (every thread on this subject ends with no answers) and Microsoft isn't going to fix it, but that really hurts automation something awful.

DGCustomerFirst

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you enter the order directly in GP exactly as you are importing it does sales tax get computed? Remember that sales tax computations are affected by the shipping method and delivery type.

Was this reply helpful? Yes No
Buzz2T 15 on at

Like (0)

Report
Copy link

Link copied!

Charlie22, years later I am struggling with this myself.

Do you recall ever finding a resolution to this?

Thanks for any insight!

Was this reply helpful? Yes No
SonnyPawchuk 116 on at

Like (0)

Report
Copy link

Link copied!

Hi Buzz2T

Look like this issue may have been resolved and just not closed.

Can you provide more details of your issue?

Was this reply helpful? Yes No
Buzz2T 15 on at

Like (0)

Report
Copy link

Link copied!

I have fallen into a maintenance role of some software that creates a sales order by calling CreateSalesOrder, sending the order details to our GP web service. Stepping through the code, I clearly see TaxAmount is set as desired on the SalesOrder just before the call to CreateSalesOrder. After, the order is in GP but tax is 0.

The OP tried a number of things with no success. I could repeat his dead-end work for myself but I am hoping to try something that has lead to success, not failure.

I thought I had the "ah ha!" moment when I learned there are policies and behaviors to be configured in the Dynamics Security Console, but then found the Create Sales Order Policy doesn't have a Create Taxes Behavior. Maybe it is there but just not exposed? But I have no real experience/justification for following this line of thinking.

Where is the GP web service code that is clearing the tax amount and what triggers that logic?

Any help is appreciated.

Was this reply helpful? Yes No
Buzz2T 15 on at

Like (0)

Report
Copy link

Link copied!

Could there be some built-in tax calculation that I don't know about that would clear the tax? Something I can disable or configure?

ANY suggestions are welcome.

Was this reply helpful? Yes No