Finance | Project Operations, Human Resources, ...

Sales tax amount is changing after transfer

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

I was asked to examine years of sales order history and to explain why the sales tax amount on an order is different than the sale tax amount on the corresponding invoice. Out of hundreds of thousands of orders being transferred to invoices I found 132 occurrences of this. They do have a custom program that takes orders off the web and inserts them into GP. These orders are then transferred to invoices. Nothing changes from the order to the invoice. The customer and address is the same as is the lines on the order. One thing I did not is that no sales tax schedule is assigned to the orders however if you zoom to the sales tax detail you will see the correct sales tax detail total and percentage amount. I do not have access to the custom code server but I was told they are using eConnect to import the orders. This is GP 2010.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Andrea Melroe 3,437 on at

Like (0)

Report

Hi Richard,

Microsoft Dynamics GP Support is not provide technical assistance/guidance on unsupported versions of Dynamics GP. Extended Support for 2010 expired on 10/13/2020.

However, we will leave this post available for anyone else in the community to assist.

Thank you!

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Yes, I know. I have been pleading for them to upgrade for over 10 years. I will use this as another reason. I have never seen this type of behavior before. Even going back to the days of eEnterprise.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

This is not so strange, we have a third party Service module and there are instances when the invoices are exported to GP tax is calculated.

We have some customers where they are regarded as zero-rated. The tax schedules are defined at the customer level so I think it has to do with the mapping to GP.

As you indicated you don't have access to the custom code, I think that may clear things up.

You said you noticed the tax amount at the detail level, to me it seems the user may have calculated the value and manually entered it.

Regards

Rosemary

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

The odd thing with with integration is there are no tax schedules on either the header or detail lines. The taxes only exist in the SOP10105 table.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Richard,

if they are using econnect to integrate the Sales Orders, I'd definitely check the code and the data that is pushed to GP, since there is a flag in the eConnect SP's to either use provided sales taxes or do the calculation on the fly as the SOP document gets created in GP.

docs.microsoft.com/.../aa973830(v=msdn.10)

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

It is just very strange to see the sales tax amount being one thing on the sales order and another on the corresponding sales invoice. Their code should have nothing to do with that. I am pleading to see the source code.

Was this reply helpful? Yes No