Tax information in sales Line through X++

(0) Share

Report

Posted on by @rp@n

Dear All,

In SalesLine we already inserted data through Code only.

In Tax Information button we want to update "Customer Tax Information" tab In Name and Address automatically means while insert data in to salesLine through code.

it's not showing Customer name and Address automatically.

But it's showing in lookup. When user select then it's updated properly.

4628.a1.png

4048.a2.png

Note : Customer wants to update Name and Address in Customer Tax Information tab automatically means when import data in to SalesLine.

*******

I checked in back end "TransTaxInformationTmp_IN" table is there. It's temp table.

Please give me more shed on this.

Thanks!

Arpan

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (0)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Is this on salesTable Form ?

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Yes Sukrut,

In Tax information GST number and other fields are updated properly.

Please give me more shed on this.

Thanks!

Arpan

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If you are not creating TransTaxInformation_IN Try this code in your import process .

CustTable custTable = CustTable::find(salesTable.CustAccount);

SalesLine salesLineLoc;

TransTaxInformation_IN transTaxInformation;

while select salesLineLoc

where salesLineLoc.SalesId == salesTable.SalesId

{

TransTaxInformation_IN transTaxInformation = TransTaxInformationHelper_IN::findOrCreateTransTaxInformation(salesLine.TableId, salesLine.RecId);

if (transTaxInformation)

{

ttsbegin;

transTaxInformation.selectForUpdate(true);

TransTaxInformationHelper_IN::initFromCustVend(transTaxInformation, custTable);

transTaxInformation.update();

ttscommit;

}

}

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Sukrut,

As you mentioned above Table TransTaxInformation_IN not present in AOT

TransTaxInformationTmp_IN is there.

Please confirm.

I need to paste above code after SalesLine.CreateLine() and before Salsline.update().

Means in between?

Thanks!

Arpan

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

yes use TransTaxInformationTmp_IN. Yes that correct .. try that

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Sukrut,

In Class TransTaxInformationHelper_IN the method you mentioned is not there.

I am using AX 2009.

Please give me more shed on this.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

can you go to SalesLine datasource ItemId Field on salesTable form and see how they are inserting records in TransTaxInformationTmp_IN , I don't have 2009 to see

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

sure, i will check

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Hi Sukrut,

I checked in SaleTable form and entire form in find with "TransTaxInformationTmp_IN " but NO result.

I checked also in SalesTable and SalesLine but NO result.

I am surprised.

But when i am creating manually record in SalesLine then it's get updated properly. NO Issue.

But when i import through code in SalesLine then it's NOT get updated.

Arpan

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Check saleslinetype and salestabletype class

Was this reply helpful? Yes No

Community site session details

Tax information in sales Line through X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Tax information in sales Line through X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates