cancel
Showing results for 
Search instead for 
Did you mean: 

Excise Information and Tax Information in BP Master

Former Member
0 Kudos
349

Dear All,

Please tell me if there is any way out to import Tax Information (PAN No., TIN, TAN, CST No. etc) and Excise Information (ECC No. etc) in the BP Master through DTW or any other utility.

Thanks in advance.

Arun

Edited by: Philip Eller on Jun 4, 2008 8:51 AM

Edited by: Philip Eller on Jun 18, 2008 9:10 AM*

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member187989
Active Contributor
0 Kudos

hi arun,

Tax and excise information is stored in table - CRD7-Fiscal Id's of BP Master Data.

Enter manually tax & excise details for a customer/vendor and

update it.

Go to query generator,Click Execute Button,

Click Pencil button below down orange arrow.

Remove query already there and paste the

query

SELECT * FROM CRD7 T0 WHERE T0.[CardCode] ='[%0]'

Enter the required BP code in conditon variable.

Now you can see entered datas populated in

respective columns,map this information with

DTW template.

BP code is mandatory field in DTW template.

Hope above answer will solve your problem.

Jeyakanthan.

Former Member
0 Kudos

Hi Arun,

I can tell you how to import tax informations in in BP master Accounting tab. You can get template from DTW -> Advaced -> Maintain Interface select oBusiness Partners. In that list select BP Fiscal Tax ID right click on it click Create Template for the Structure.

In that Template Tax ID0 for PAN No., Tax ID1 for CST No.,Tax ID11 for TIN No. , etc.

Importing Excise information i think its not possible.

Do you have any doubt let me know.

Former Member
0 Kudos

Hi, please confirm which fields are used to import which TAX information.

Thanks in advance.

Arun

Former Member
0 Kudos

Here is the mapping of Tax Information in 'BPFiscalTaxID' template

TaxId0 PAN No

TaxId1 CST NO

TaxId2 LST/VAT NO

TaxId3 SERVICE TAX NO

TaxId4 PAN CIRCLE NO

TaxId5 PAN WARD No

TaxId6 TAN NO

TaxId7 PAN ASSESSING OFFICER

TaxId8 COMPANY TYPE

TaxId9 NATURE OF BUSINESS

TaxId10 ASSESSEE TYPE

TaxId11 TIN NO.

Excise Information has to be manually keyed in by User.

Regards