# Business Central shipping lines **URL:** \ **Category:** Questions\ **Tags:** litium-7\ **Created:** [October 31, 2022, 9:02am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746 "2022-10-31T09:02:20Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jt-exsitec](https://avatars.discourse-cdn.com/v4/letter/j/6a8cbe/32.png) [@jt-exsitec](https://forum.litium.com/u/jt-exsitec)\ **Post date:** [October 31, 2022, 9:02am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/1 "2022-10-31T09:02:20Z")
Hello, Currently working with a client that uses Business Central (ERP) and we’re having some issues with shipping orderlines. Litium calculates Shipping VAT according to [https://docs.litium.com/documentation/previous-versions/litium-7/litium-documentation/sales/pricing\_rules\_1/calculating\_vat](https://docs.litium.com/documentation/previous-versions/litium-7/litium-documentation/sales/pricing_rules_1/calculating_vat#:~:text=Include%20VAT.-,VAT%20on%20delivery%20and%20fees,-VAT%20on%20delivery). Meaning the VAT percentage for shipping/delivery can vary depending what products (VAT rates) you have in the cart. Like in the example below, the shipping VAT percentage is 15%. However, when sending the orderlines to Business Central, they are expecting the two orderlines for shipping. One orderline for “SHIPPING12” and another for “SHIPPING25”. ### Sample Data - All excluding vat **Subtotal:** 2 069,00 SEK **Shipping:** 693,36 SEK **Totals:** 2 762,36 SEK **12% VAT:** 183,72 SEK **25% VAT:** 134,50 SEK **15% Shipping VAT:** 106,64 SEK **Totals with VAT:** 3 187,22 SEK ### What we need help with Basically, we need to determine how much of the shipping cost _(693,36 SEK)_ should be on the “SHIPPING12” orderline and how much that should be on the “SHIPPING25” orderline. I have a couple of ideas myself on how to calculate these values, but I have no clue if either of them are correct. Has anyone worked with Business Central before and know how to calculate these values? **Litium version:** 7.7.0 ---
**Author:** ![Spotonkastebo](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/spotonkastebo/32/717_2.png) [@Spotonkastebo](https://forum.litium.com/u/Spotonkastebo)\ **Post date:** [October 31, 2022, 9:33am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/2 "2022-10-31T09:33:15Z")
I don’t know the rules or laws around this but logically you do it in the same way as litium calculated the 15% VAT for the shipping. Look at the products total value for each VAT-bracket compared to order-total-product-value. if you have a total value of product on 1000SEK, 750SEK is goods with 12% VAT and 250SEK in gods with 25% VAT then 75% of the delivery VAT should be in **12% VAT** and 25% in **25% VAT:** ---
**Author:** ![jt-exsitec](https://avatars.discourse-cdn.com/v4/letter/j/6a8cbe/32.png) [@jt-exsitec](https://forum.litium.com/u/jt-exsitec)\ **Post date:** [October 31, 2022, 10:45am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/3 "2022-10-31T10:45:26Z")
Alright, thanks! You mention “75% of the delivery VAT”, do you perhaps mean just “75% of the delivery cost”? We’re not sending VAT to Business Central at all, just the cost/sum of the shipping, excluding vat and vat rate. So basically, if you have a total value of products at 1000 SEK, 750 SEK is goods with 12% VAT and 250 SEK in gods with 25% VAT **and** the shipping cost is 100 SEK. Then 75 SEK (75%) will be on the 12% VAT shipping orderrow and 25 SEK (25) on the 25% shipping orderrow. For a total of 100 SEK shipping cost, excluding VAT, right? ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [October 31, 2022, 11:27am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/4 "2022-10-31T11:27:44Z")
If I remember correctly, you should do the calculation as below. When calculating the prorata you need to use the product prices without vat. Take the product total amount for the specific tax-rate and divide with the total amount for all products, then you get the prorata-rate for each tax-rate. The prorata-rate will then be used to calculate how much of the shipping cost including vat that should go into each tax-rate and for each tax-rate you can then calculate the tax amount. ---
**Author:** ![jt-exsitec](https://avatars.discourse-cdn.com/v4/letter/j/6a8cbe/32.png) [@jt-exsitec](https://forum.litium.com/u/jt-exsitec)\ **Post date:** [October 31, 2022, 12:30pm UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/5 "2022-10-31T12:30:14Z")
Thanks for the reply @patric.forsgard Can I use the prorata-rate for calculating shipping cost excluding vat as well or will that be inaccurate? ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [October 31, 2022, 4:29pm UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/6 "2022-10-31T16:29:42Z")
The prorata will only find the rate for the different vat-rate that should be used, and I think it should work if you have the shipping cost in price excluding VAT and only adding the tax up on that to get the total price the buyer has to pay. ---
**Author:** ![jt-exsitec](https://avatars.discourse-cdn.com/v4/letter/j/6a8cbe/32.png) [@jt-exsitec](https://forum.litium.com/u/jt-exsitec)\ **Post date:** [November 1, 2022, 7:48am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/7 "2022-11-01T07:48:07Z")
Alright, just confirmed with the customers BC partner, they’re expecting the shipping cost excluding vat, so we’re not adding any tax on our side. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/12eddac3b8b661de1db86af10ac8151b571e6fb9.png) [@system](https://forum.litium.com/u/system)\ **Post date:** [November 29, 2022, 7:48am UTC](https://forum.litium.com/t/business-central-shipping-lines/2746/8 "2022-11-29T07:48:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.