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

Announcements

No record found.

News and Announcements icon
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,613

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,311 on at

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

  • Verified answer
    TWBlaisdell Profile Picture
    Microsoft Employee 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,613 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
    890 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,003 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,225 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans