My Products
Help
eln
CONTRIBUTOR ***

Issue with OrderTotal not including freight-VAT on sales orders

by eln

Hi,

 

I'm not sure this issue is caused by the API per se, but I was told to put it here.

 

When creating SalesOrders through the Visma.net API the order total does not include VAT from freight. Freight cost is determined from the values on the ShippingMethod (ShipVia). When creating invoice based on sales order the VAT is included and OrderTotal is correct.

 

When creating a sales order without any sales order lines, the order total correctly includes VAT on freight. We've found a workaround where we first create a sales order without any sales order lines, and then perform an update adding the sales order lines, which results in correct order total.

 

Attaching some print screens to showcase errors.

BR

 

vismashipvia.PNGimage (2).pngimage (1).png

 

{
    "orderType": {
        "value""WS"
    },
    "hold": {
        "value"false
    },
    "customerRefNo": {
        "value""36763"
    },
    "customer": {
        "value""49989"
    },
    "note": {},
    "shipVia": {
        "value""PNP"
    },
    "paymentMethod": {
        "value""11"
    },
    "cashAccount": {
        "value""MC01"
    },
    "soBillingAddress": {
        "value": {
            "overrideAddress": {
                "value"true
            },
            "addressLine1": {
                "value""Hyggevej 4"
            },
            "postalCode": {
                "value""8000"
            },
            "city": {
                "value""Aarhus C"
            },
            "countryId": {
                "value""DK"
            },
            "county": {
                "value"""
            }
        }
    },
    "soShippingAddress": {
        "value": {
            "overrideAddress": {
                "value"true
            },
            "addressLine1": {
                "value""Hyggevej 4"
            },
            "postalCode": {
                "value""8000"
            },
            "city": {
                "value""Aarhus C"
            },
            "countryId": {
                "value""DK"
            },
            "county": {
                "value"""
            }
        }
    },
    "soBillingContact": {
        "value": {
            "overrideContact": {
                "value"true
            },
            "name": {
                "value""Erik Larsson"
            },
            "email": {
                "value""eln@iadvice.dk"
            },
            "phone1": {
                "value""92153820"
            }
        }
    },
    "soShippingContact": {
        "value": {
            "overrideContact": {
                "value"true
            },
            "name": {
                "value""Erik Larsson"
            },
            "email": {
                "value""eln@iadvice.dk"
            },
            "phone1": {
                "value""92153820"
            }
        }
    },
    "shipComplete": {
        "value""ShipComplete"
    },
    "lines": [{
            "operation""insert",
            "inventoryId": {
                "value""7350106391452"
            },
            "warehouse": {
                "value""11"
            },
            "quantity": {
                "value"1.0
            },
            "unitPrice": {
                "value"119.96
            },
            "discountPercent": {
                "value"0.0
            },
            "discountAmount": {
                "value"0.0
            },
            "lineDescription": {
                "value""LEGO iAdvice Office Set"
            },
            "subaccount": [{
                    "segmentId"1,
                    "segmentValue""01"
                }
            ]
        }
    ]
}
9 REPLIES 9

by Yıldırım

We need more information to clarify the case.

ShipVia: Base Rate (cost) automatically added to the Sales Order Total when it's created via API. 

Line Total :119,96
Line Total's VAT: 17.99 
Freight Cost: 23

SalesOrderShipVia.png

 

We're seeing that from print screen you've attached, Freight VAT Category is empty (Momskategori-frakt). Can you please review your Freight Vat Category ?  

Can you also inform us about, 
1- Is your issue, Freight Cost not being added to the Sales Order Total
or
2- Freight Cost not being calculated within VAT even though Freight VAT Category(Momskategori-frakt) is filled with a valid taxable VAT Code ? 

Thanks.

chriswidell
CONTRIBUTOR **

by chriswidell

Hi,

 

Our issue is #2. VAT is not calculated on top of freight cost and not included in ordertotal regardless if VAT category is on Ship Via Code or not.

 

Best regards,

 

Christian Widell

+46760435476 

by Yıldırım

Hello,


is VAT code taxable what has been set on the Freight Vat Category ?

chriswidell
CONTRIBUTOR **

by chriswidell

Hi again,

 

Yes it is taxable as far as I can conclude.

 

Best regards,


Christian Widell

by Yıldırım (Updated ‎13-10-2020 14:47 by Yıldırım VISMA )

Hello, 

 

after doing some testing to confirm, it appears that although Freight VAT Category correctly set with taxable VAT Category Code by default in the ShipVia Card,  its VAT value is not calculated in the VAT Total of the document while Posting a Sales Order via API.

This has been conveyed to the Development Team, we'll provide more updates as they come in.
------

Based on Freight VAT Category, calculated Freight Vat can be seen at Vat Details Tab in the ERP. (Added to VAT Total)
Freight.pngVatDetails_freight.png

@Yıldırım Maybe this case is related to this case: https://community.visma.com/t5/Ideas-in-Developers-Visma-net/missing-vat-in-orderhead/idi-p/317171

 

Both are about missing VAT in order head. In our case we also see that we get VAT in order head if  creating empty order and the later adding order lines.

by Yıldırım (Updated ‎13-10-2020 10:21 by Yıldırım VISMA )

@Trygve Storrønningen1 wrote:

@Yıldırım Maybe this case is related to this case: https://community.visma.com/t5/Ideas-in-Developers-Visma-net/missing-vat-in-orderhead/idi-p/317171

 

Both are about missing VAT in order head. In our case we also see that we get VAT in order head if  creating empty order and the later adding order lines.


That is more likely a company specific case since it's not reproducible while testing with other companies. There is another case escalated to development team. More information will be shared under that relevant thread once development team finalize the investigation.

Accepted solution
Yıldırım
VISMA

by Yıldırım (Updated ‎25-11-2020 11:17 by Yıldırım VISMA )

Update
Planned to be fixed in 8.28 release. (Visma.net Financials API updates for version 8.28)
Update
This has been fixed in 8.28 (Release Notes - Visma.Net API 8.28 - 24.11.2020)

by Yıldırım

Hello, 

we'll check this out and get back to you with information.