web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Different COGS G/L posting based on location

(0) ShareShare
ReportReport
Posted on by 15,529

Hi

Is it possible to setup different COGS G/L for different locations? For example if we sell product A to Customer B from Location C then the COGS post to account 1 but post to account 2 if we sold it from Location D?

 Product A to Customer B from Location C -> COGS to G/L Account 1 

 Product A to Customer B from Location D -> COGS to G/L Account 2

Thanks

 

I have the same question (0)
  • Verified answer
    Samantha73 Profile Picture
    3,255 on at

    Good question  - I'm pretty sure this is not possible but love to hear other answers

  • Verified answer
    TWBlaisdell Profile Picture
    on at

    Hello MahGah,

    Thank you for posting. 

    It would definitely take some level of Extension to the Sales Line Page and change to standard Dyamics 365 Business Central.

    General Posting Setup is where General Business Posting Group and General Product Posting Group Codes are combined in a matrix Table to build out the combinations of each to detemine accounts such as Sales and Cost of Goods Sold.  The fields for General Business Posting Group and General Product Posting Group are stored in Table 37, but the standard Sales Line Page (Page 46) doesn't show these fields, so the Personalization to add these fields is not available. Thus, it would require a Page Extension be developed by a Partner.

    At the base level, you would have to make the Page Extension to show General Business Posting Group and/or General Product Posting and have the different Cost of Goods Sold Account identified for different combinations.  Then, a selection at the now presented Line > General Business Posting Group or General Product Posting Group to identify the change required to redirect the posting to the desired Cost of Goods Account. The challenge is that Location Code does not have any control over General Posting Group setup, so it would be a manual process without a more extensive extension possibly adding a General Busines Posting Group to the Location Card, for example. That would get a little challenging because General Business Posting Groups are exclusively tied to Customer and Vendor Records, so adding Locations could get a bit confusing.

    I hope this at least provides some level of guidance for options.

    Best Regards,

    Tom

  • MahGah Profile Picture
    15,529 on at

    Hi Tom 

    Thank you for detailed answer and providing guideline for how we can accomplish this. This is really helpful. I will work with our partner on this to follow your great guideline and build an extension for us. 

    Thanks 

  • Robert Jolliffe Profile Picture
    885 on at

    I feel like you may be able to use Dimensions in some way to segregate the COGS - but they would all go to the Same GL account however reporting on them would be pretty easy.  Maybe a Required Dimension for the "Ship From Location" or something like that that a quick extension can fill in based on the Location selected on the sales order?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans