Import Scenario to delete tax

Hello @jwarren ,

To delete a line from a grid you need to map <Line Number> line to =-2.

Here’s a link for a video with instructions on how to map an import scenario to delete lines from a grid (min 57:58)L 

Hope it helps.

Please find the import scenario as attached, if you multiple lines details in the import then we need to @@tax ID defined in the below article as suggested @riglesias 

Thanks for the info @manikantad18  & @riglesias.

Not sure what I should be putting in this field though?

Thanks for the info @manikantad18  & @riglesias.

 

Not sure what I should be putting in this field though?

 

For example, in PO if we e 3 types of Tax ID are generated then you need to put the tax ID which you want to remove.

For example : WA City Tax

Thanks for the info @manikantad18  & @riglesias.

 

Not sure what I should be putting in this field though?

 

For example, in PO if we e 3 types of Tax ID are generated then you need to put the tax ID which you want to remove.

For example : WA City Tax

WA CITY TAX	3.750000	5,005.00	187.69	100.000000	0.00	PO001715
WA COUNTY TAX	0.000000	5,005.00	0.00	100.000000	0.00	PO001716
WA STATE TAX	6.500000	5,005.00	325.33	100.000000	0.00	PO001717

Still not updating the tax in this scenario:

Thanks for the info @manikantad18  & @riglesias.

 

Not sure what I should be putting in this field though?

 

For example, in PO if we e 3 types of Tax ID are generated then you need to put the tax ID which you want to remove.

For example : WA City Tax

WA CITY TAX	3.750000	5,005.00	187.69	100.000000	0.00	PO001715
WA COUNTY TAX	0.000000	5,005.00	0.00	100.000000	0.00	PO001716
WA STATE TAX	6.500000	5,005.00	325.33	100.000000	0.00	PO001717

Still not updating the tax in this scenario:

 

Did you follow my Import scenario?

Thanks

Hello @jwarren 

In this case there is no need to use the @@ notation. Tax ID it’s a key field so when you add Tax ID line the system will automatically insert the key line (highlighted below). Also notice that <Line Number> line needs to be mapped to =-2. Like this:

 

 

Fantastic - thanks guys