Building an import scenario to delete tax impact on POs - not sure which field to use on import scenario.
I need to:
- Delete the Tax ID
- Remove Hold
- Save
Here is my current import scenario:
Answer
Import Scenario to delete tax
Best answer by riglesias
Hello
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:
+2Hello
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.
Rodrigo ~ A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
+15Please 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
| https://community.acumatica.com/maintenance-and-troubleshooting-15/webinar-common-examples-of-import-scenarios-206 |
Acumatica Functional Consultant & Customer Experience Supervisor
Thanks for the info
Not sure what I should be putting in this field though?
+15Thanks for the info
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 |
Thanks for the info
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:
+15Thanks for the info
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
+2Hello
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:
Rodrigo ~ A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Hello
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.