Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

GL Entry Doubt from Two Locations during the sales.

Posted on by Microsoft Employee

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

  • Verified answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Snehanshu Mandal 560 on at
    RE: GL Entry Doubt from Two Locations during the sales.

    Why Can't you use Tax Area Location feature?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans