Tax code template

[former_member212181]

Hi Experts

Can you provide me a sample template for OSTC - SalesTaxCodes and STC1 - SalesTaxCodes_Lines1.

I need to import more than 1700 tax codes for a Manufacturing Co.

I Cant see Tax type combination field in OSTC Template.

and I'm not able to understand "STATaxonTaxCode" &  "STATaxOnTaxType "in STC1 template

I hereby mentioned sample template which I prepared

OSTC

Code	Name	Freight	ValidForAR	ValidForAP	IsItemLevel
Code	Name	Freight	ValidForAR	ValidForAP	IsItmLevel
TC001000	Nil Tax (VNEN)	tYES	tYES	tYES	tNO
TC001001	Against "F" Form (VNEN)	tYES	tYES	tYES	tNO

STC1

ParentKey	LineNum	STACode	STAType	STATaxonTaxCode	STATaxOnTaxType
Code	LineNum	STACode	STAType	TaxOnTCode	TaxOnTType
TC001000	0	TT001022	8
TC001001	0	TT001022	8

Thanks in Advance

Regards

Unnikrishnan

[Former Member]

Hi Unnikrishnan,

"STATaxonTaxCode" & "STATaxOnTaxType" mean Tax on Tax code and type.

You may run SELECT * from OTFC to see if you have any Tax type set already. If not, these 2 fields may not be use-able fro you.

Thanks,

Gordon

[former_member212181]

Hi Gordon
But while importing data error is showing as "enter valid code [OSTC.TfcId] .
But this field is not in OSTC Template given by SAP.
I just tried to add this field in OSTC template and give tax type combination code. but same error showing again.

I Just check SBO Demo India Database for  "BED+VAT" tax code. In this STC1.TaxOnTCode and STC1.TaxOnTCode are showing null value.
So I guess it is immaterial for me.

Regards

Unnikrishnan

[Former Member]

Hi,

Refer to this below link.

http://support.tenrox.com/en/solutions/V8.7/guides/Tenrox_Release_8.7_SAP_B1_Connector_Guide.pdf

http://www.saptechies.com/taxonsales-purchases/

Hope it will be helpful.

Thanks & Regards,

Bowya S S

[joserik]

got you the resolution for this question?

I have the same problem.

"error": {

        "code": -5002,

        "message": {

            "lang": "en-us",

            "value": "Enter valid code  [OSTC.TfcId]"

        }

    }