logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
9.0.6 Avalara how are multiple shipments handled
Options
Go to last post Go to first unread
Previous Topic Next Topic
Joe Payne2  
#1 Posted : Wednesday, June 1, 2022 7:07:32 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
It doesn't seem like the Avalara gateway supports multiple shipments properly.

If I split an order into two shipments, and each shipment destination is taxable, I should see two different Avalara transactions.

But the gateway is creating transactions with a DocId of the order number. And you can't have two transactions in Avalara with the same DocId.

And further, tax line items do not get assigned to a shipment when the line items are created. So it's impossible to know (in Able) which shipment a particular tax line item belongs to when multiple shipments are involved.

So how is that handled?
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
shaharyar  
#2 Posted : Wednesday, June 1, 2022 8:51:21 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
We recently found a bug related to multiple shipments when using recalculate button. There was a null exception on clicking recalculate button.
We had this fixed and will be released in the next version.

Quote:
If I split an order into two shipments, and each shipment destination is taxable, I should see two different Avalara transactions.


I will look into the implementation details.

Thanks for sharing the details.
Back to top
shaharyar  
#3 Posted : Wednesday, June 1, 2022 10:11:37 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
I have looked into the implementation details and found that the individual line items can have a different addresses. So creating a new shipment with separate order items will add new tax line items with different addresses when we adjust the tax. If you look into the Avalara transaction details each line item is showing its Ship From and Ship To address.

Please let us know if this addresses your concern.

Moreover, you might be encountering the error that I mentioned in my previous post. Please confirm that is there any error log entries when you click recalculate on a new shipment.

We had fixed the issue. Please tell me if you want the fix so I can share it.

Edited by user Wednesday, June 1, 2022 10:14:00 AM(UTC)  | Reason: Not specified
Back to top
Joe Payne2  
#4 Posted : Wednesday, June 1, 2022 10:48:15 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
Thanks for looking into it.

So a single order, with multiple shipments going to difference states/provinces, will still show in Avalara as a single transaction?
Back to top
sweeperqb  
#5 Posted : Wednesday, June 1, 2022 3:58:42 PM(UTC)
sweeperqb

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 5/30/2020(UTC)
Posts: 125

Thanks: 14 times
Was thanked: 3 time(s) in 3 post(s)
We are interested in the fix if you have it.
Back to top
shaharyar  
#6 Posted : Thursday, June 2, 2022 4:02:50 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Quote:
So a single order, with multiple shipments going to difference states/provinces, will still show in Avalara as a single transaction?


Yes, multiple shipments going to different states/provinces will show it as a single transaction in Avalara. Each line item within a single transaction has its own Ship To and Ship From address.
Back to top
shaharyar  
#7 Posted : Thursday, June 2, 2022 4:31:59 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
To fix:

1- Open Website\Areas\Admin\Controllers\OrdersController.cs
2- Search for
Code:

// else update the add product view
model = PrepareAddProductModel(model.ProductId, model.OrderId, model.ShipmentId, model.Quantity, model.Price, true);

3- Replace with
Code:

// else update the add product view
ModelState.Remove("WarehouseId");
model = PrepareAddProductModel(model.ProductId, model.OrderId, model.ShipmentId, model.Quantity, model.Price, true);

4- Compile the code and update the Ablecommerce.dll

It is always good to test locally before making the changes live.
Hope it helps!
Back to top
Users browsing this topic
Guest (4)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.163 seconds.