News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Tax by UOM by value (n...

Small and medium business | Business Central, N...

Suggested answer

Tax by UOM by value (not percentage)

(0) Share

Report

Report

Posted on by Rob Roberts

30

I have a need, for excise tax on fuel, to calculate the excise tax on the UOM (Gallons) and use a value rather than a percentage (e.g. diesel taxed at $.20/gallon.)

I understand this is also an issue for CBD dispensaries that have to post tax dollars by the ounce.

Has anyone come up with a solution to this? Client is too small for Avatax at this time.

I thought, given their limited distribution, I could utilize a Sales BOM concept, but that doesn't appear to help without significant production/routing configuration (client is not a manufacturer.)

Any suggestions appreciated.

Rob

Categories:

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Tax by UOM by value (not percentage)

Rob,

This one very hard out-of-the-box since Sales Tax is % based but has maximum amount features, which will not help. I would recommend, given what you are trying to do, look at Avalara AvaTax to assist here:

www.avalara.com/.../calculating-sales-and-excise-tax-on-the-same-invoice.html

They will calculate and post the correct Excise Tax for Fuel. This stays away from a customization/extension and you will be compliant for Sales/Use/Excise tax.

Hope this helps.

Thanks,

Steve

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

YUN ZHU 499 Super User 2025 Season 1

#2

Sagar Dangar, MCP 373

#3

Mansi Soni 327

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans