Hi Fellow members,
I have already posted this query: https://community.dynamics.com/nav/f/34/t/139674.aspx
However, I didn't get the correct answer.
So I am including an image for easy understanding the question again
Please provide the solution.
*This post is locked for comments
I hope you it solve your issue. Let me know if anything more you need to know.
community.dynamics.com/.../139674.aspx
Regards,
Saurabh Shah
[quote user="Saurabh Shah"]
Hi,
Ok. As you well aware that the only one sales account can be set against the combination of Gen. Bus. Posting group and Gen. Prod. posting group so in your case if you want to have different sales account in case you sales it from chennai (as per example) then you need to have a different Gen. Bus. posting group in that sales order or invoice.
On Sales header, Gen. Bus posting group field is available so if you change the group there it will automatically get changed on all lines and on posting you will have correct sales account based on your mapping.
Now second part, How to automate this. in this case you need to do some customisation that where state code of your location and state of your ship to location is not same then it should pickup the different posting group.
Regards,
Saurabh Shah
[/quote]
Hi Snehanshu Mandal
Thanks for your reply,
Tax Area Location Feature is used for calculating Tax, right? However, the present case is not about tax details..
Tax is computed correctly, what I need is posting to respective Sales Account.
See the example:
I have two locations: One in Delhi and One in Chennai.
My customer XYZ resides in Delhi.
I can invoice from both Delhi and Chennai.
According to standard NAV, I can only define one Gen. Bus. Posting Group for a customer and accordingly one 'Sales Account'.
Let say, in the present, case I defined Gen. Bus. Posting Group as 'Local' for XYZ. (Sales Account for Local in Gen. Posting Setup : Local Sales)
If I invoice from Delhi location, it would be 'Local Sales'
But if I invoice from Chennai location, it would be again 'Local Sales'. (as the sales account for Gen. Bus. Posting Group; Local Sales)
I need to know how can we configure such that, if I invoice from Chennai location, it would be 'Interstate Sales'.
Delhi to Delhi: Local Sales
Chennai to Chennai: Local Sales
Delhi to Chennai: Interstate sales
Chennai to Delhi: Interstate sales.
This question is not regarding 'TAX" as tax is dependent on Tax area location and NAV system is fine with that.
Why Can't you use Tax Area Location feature?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156