You’re offline. This is a read only version of the page.
15,443
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 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?
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
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
Good question - I'm pretty sure this is not possible but love to hear other answers
#1
Sohail Ahmed
999
#2
YUN ZHU
934
Super User 2025 Season 1
#3
Mansi Soni
612
Share
Report
All responses (
Answers (
