Microsoft Dynamics NAV (Archived)

GL Entry Doubt from Two Locations during the sales.

(0) Share

Report

Posted on by Community Member

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

All responses (4)

Answers (2)

Verified answer

Saurabh Shah 4,560 on at

Like (1)

Report

RE: GL Entry Doubt from Two Locations during the sales.

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
Verified answer

Community Member on at

Like (0)

Report

RE: GL Entry Doubt from Two Locations during the sales.

[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]

https://community.dynamics.com/nav/f/34/t/139674.aspx
Community Member on at

Like (0)

Report

RE: GL Entry Doubt from Two Locations during the sales.

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.
Snehanshu Mandal 560 on at

Like (0)

Report

RE: GL Entry Doubt from Two Locations during the sales.

Why Can't you use Tax Area Location feature?