web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Retail statement posti...

Microsoft Dynamics AX (Archived)

Retail statement posting error - Field Tax Identification Number (TIN) must be filled in for item

(0) Share

Report

Report

Posted on by Community Member

When user is posting Retail statement for a store on a particular date, AX is displaying error message as

Sales order number: SO-xxxxxxx

Item: yyyyyyyyyy

Line number: 1

Field Tax Identification Number (TIN) must be filled in for item.

Posting has been cancelled.

We are running on AX 2012 R3 CU12 - GSTR patch 1 (IND localization).

Questions:

1. How does AX create a Sales order even before posting the Retail statement?

2. When checked the Sales order shown on the error message, that sales order does not exist in AX?

3. We are using GST now and wht AX is looking for TIN?

Can you please help me to understand the issue and provide possible solution to resolve the issue.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

This issue is now resolved. For that one item which was causing the issue, on the Released products form >> Sell tab >> Taxation >> Item tax group was filled. I removed the value, made that field blank and saved the record. This was the only item that had this configuration dating back to VAT era. Might be the user forgot to remove this configuration when the customer moved to GST regime.

Then, I updated the Retail transaction data that was having this Item tax group values for that item.

Updated the ORIGINALTAXITEMGROUP, taxitemgroup fields of retailtransactionsalestrans to ' ' and the statement was posted.

Hope this helps someone who is facing the same issue.

Regards,

Balaji

Was this reply helpful? Yes No
Veronika Filonenko 1,261 on at

Like (0)

Report

Hi,

I am having the same issue. Only I'm only posting an invoice of the SO, from the call center.

Now, I really don't understand why would we remove the Item sales tax group from that parameter that you mention?

This parameter is mandatory from finance perspective.

How the system will calculate tax on that item?

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#1

Martin Dráb 4 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans