Let ABC (Delhi) Ltd. be a customer.
If the items are sold to ABC Ltd. from Delhi warehouse, the tax applicable would be VAT and the Journal Entry would be as follows:
ABC Ltd. Dr. 1,125
Sales Tax Cr. 125
Local Sales CR. 1000
If the items are sold to ABC Ltd. from Mumbai warehouse, the tax applicable would be CST and the Journal Entry would be as follows:
ABC Ltd. Dr. 1,125
Interstate Sales CR. 1125
How can we configure as above for a single customer ABC Ltd.?
*This post is locked for comments
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
Hi Saurabh,
Thanks for your reply,
But I think the situation in my question is not clear to you. It is not about tax details..
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.
Hi,
Are you defining C Form on sales order ?
Please define the sales tax with tax area code and Tax details with C form codes so you can get the respective tax %.
If the sales order is having the C Form tick and Form code is having value on sales header then system will not post the tax amount seperately and will include the amount in inventory so no posting of CST in GL account seperately as you required.
Regards,
Saurabh Shah
Why Can't you use Tax Area Location feature?
Dear friends,
Tax is computed correctly for different locations. So I believe there might be some provision for the above said situations.
If anyone know the solution please provide the same.
I would like to have a solution without customization.
Regards,
JO
I think MS dynamics NAV fails here...
Or you could migrate to a modern program that allows for multiple taxing situations by customer dependent on sales location, one such program is SMS by LOC software.
I can't believe how antiquated this NAV stuff is...
If I hear one more time about one-to-one and NAV silo structure I'm going to jump off a silo, maybe one of the many LINKED silo's that ordinary dirt farmers have out back of their barns.
Hi Macro!
Thanks for the reply. However, I need further enlightenment on the issue.
As you said that only one to one principle is applicable, two Gen. Bus. Posting Groups cannot be configured to a single customer.
In each Sales Order, when we select Customer, the Gen Bus Posting Group is updated automatically from Customer card.
Still the issue remains as the GL determination is on Gen Bus Posting Group and Gen Pro Posting Group.
Thanking you,
JO
Hi Jiju!
Within the confines of NAV's standard functions, how I see this is that you have to create two separate Sales Orders (SO) for the transactions in Delhi and Mumbai. The Delhi SO would have the VAT computed exclusive of the line price per unit and the Mumbai SO would have the VAT inclusive of the line price per unit.
If you were to configure the VAT business posting group for the customer then it's up to you if you will set it as Price Inclusive of VAT or not. How it's set up in the Customer Card will determine how the transaction would be treated in the Sales Order. Same goes with the Item Card for its Price Inclusive of VAT option. How NAV works is it operates on a one-to-one principle which means you can only configure one Customer Card or Item Card (for example) to one Gen. Bus. Posting Group, VAT Business Posting Group and so on. Two VAT posting groups (for example) cannot be configured for one Customer. In short, you have to process your example above through separate SOs.
I hope I was able to shed light on this. :)
Regards,
Marco
Sure Harsh, I will do that as soon as I get that
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
