Home Cloud Account Management Support Forums Downloads About Us  

Blue Alligator Support Forums

Support for the Blue Alligator applications

You are not logged in.

#1 2018-05-21 01:08:01

ScentimentsUK
Junior member
From: Leeds
Registered: 2018-03-22
Website

Vat

Evening,


I have folllowed the video on how to add VAT/ Sales tax

I have completed 2 csv doccuments, mapped and changed the relevent information.

Is it possible someone can check this on my account as i seem to be having no joy.

thanks

Offline

 

#2 2018-05-21 10:58:18

admin
Administrator
Registered: 2008-02-09

Re: Vat

We can see that you've set up the 2 new files correctly, however the SalesTaxCode field in the Products file, and the SalesTaxGroup field in CustomerAccounts file have been added to the middle of the respective lines causing your field mappings for those file types to become misaligned.

To resolve this issue you will need to update the field mappings for the above file types under the File Management > File Mappings section of your cloud account.

To avoid this issue happening in the future when adding new fields to existing lines, be sure to add the new fields at the end of a line rather than the middle to maintain the integrity of your existing field mappings.

Offline

 

#3 2018-05-22 10:04:29

ScentimentsUK
Junior member
From: Leeds
Registered: 2018-03-22
Website

Re: Vat

Morning, I have deleted these collumns and added them to the end of the excel sheet . uploaded files and file processed.

i have only added sales tax to the bubblegum bath bomb line just to check it all works.

it is still not showing up with any vat on this line, apologies. please can you advise

Offline

 

#4 2018-05-23 09:33:34

admin
Administrator
Registered: 2008-02-09

Re: Vat

We can see that the field mappings for your pre-existing fields have returned to normal, however you will now need to map the SalesTaxCode field in the Products file, and the SalesTaxGroup field in CustomerAccounts file via the File Management > File Mappings section of your cloud account.

Offline

 

#5 2018-05-23 16:39:01

ScentimentsUK
Junior member
From: Leeds
Registered: 2018-03-22
Website

Re: Vat

i have maped the 2 files via file management however still no change? Apologies

Offline

 

#6 2018-05-24 16:54:50

admin
Administrator
Registered: 2008-02-09

Re: Vat

Your setup seems to be correct now, but the Products CSV file has not been processed since the latest changes to that file.

If a new file is uploaded or any changes are made to the field mappings of a file, a Process Files should subsequently be performed on the cloud account.

Offline

 

#7 2018-05-24 21:22:43

ScentimentsUK
Junior member
From: Leeds
Registered: 2018-03-22
Website

Re: Vat

i have uploaded procducts and processed but my invoices still show as 0 and dont include VAT.

Offline

 

#8 2018-05-29 19:52:07

ScentimentsUK
Junior member
From: Leeds
Registered: 2018-03-22
Website

Re: Vat

Is someone free to look at this please?

Offline

 

#9 2018-05-30 17:35:45

admin
Administrator
Registered: 2008-02-09

Re: Vat

The CustomerAccounts CSV file should contain a valid SalesTaxGroup that you've provided in the SalesTaxGroup CSV file.
Currently your CustomerAccounts CSV file instead contains a SalesTaxCode which is intended for products.

To fix your issue, you need to change the SalesTaxCode of "S" in your CustomerAccounts CSV file to a SalesTaxGroup of "1".

Offline

 

Board footer

Apple, the Apple logo, iPod, iPod touch, iPad and iTunes are trademarks of Apple Inc., registered in the U.S. and other countries. iPhone is a trademark of Apple Inc. App Store is a service mark of Apple Inc.
© Copyright 2009 - Blue Alligator Company Limited. All rights reserved.