Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2009 R2 - COGS g/l...
Microsoft Dynamics NAV (Archived)

NAV 2009 R2 - COGS g/l account with Gen. Prod./Gen. Bus. Posting Group

(0) ShareShare
ReportReport
Posted on by jenniferyoung 135

Hello,

I was wondering if someone might be able to help me.

I am looking into how we could have a single sales revenue g/l account and a single COGS g/l account and then use the Gen. Prod. Posting Group and the Gen. Bus. Posting Group to filter and generate reports to analyse sales and COGS for various products and customer types.

With regards to the revenue side of things, this seems fairly straightforward. These two codes are associated with each entry posted to the g/l, meaning that this could be filtered easily.

However, for COGS, there doesn't seem to be any association between the GBPG/GPPG and the entries on the g/l account, these two columns are simply blank.

I would have assumed that since the GBPG and the GPPG are both mapped to specific g/l codes for sales and COGS, that these codes would appear on the COGS entry as well as the sales entry when the sales invoice is posted.

Please can anyone let me know how we could filter by these two codes for COGS, allowing us to have a single g/l?

Thanks in advance, any help would be hugely appreciated.

Jennifer

*This post is locked for comments

  • jenniferyoung Profile Picture
    jenniferyoung 135 on at
    RE: NAV 2009 R2 - COGS g/l account with Gen. Prod./Gen. Bus. Posting Group

    Hi Jens,

    Thank you very much again.

    I think I now understand, although this side of Navision is quite new to me!

    Your reply is very helpful, I will follow up your suggestions with our Navision support and see if we can incorporate this.

    I will let you know!

    Best regards,

    Jennifer

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV 2009 R2 - COGS g/l account with Gen. Prod./Gen. Bus. Posting Group

    Hi Jennifer,

    oh that's not so easy. The reason for this is that you can have both setups, inventory integrated into G/L and not integrated. However, this integration always is a second transaction. So they are not the same transaction no. You are right on the COGS account in the General Posting Setup, though. Either way, to post to the right account in this transaction they need to have the posting groups somewhere in the value entry, and they have.

    I 've taken a look into the posting logic on why this information isn't transferred to the G/L entries. It's... well... intentional, as it seems. For selecting the right account you need these groups, but the groups are only filled into the G/L entries when you have a complete set of posting type, GBPG/BPPG and VAT posting groups. This makes sense, as only then VAT can be calculated. To enable this partial filling from inventory postings, three codeunits would have to be changed:

    5802 Inventory Posting To G/L

    11 Gen. Jnl.-Check Line

    12 Gen. Jnl.-Post Line

    The changes itself are fairly straight-forward, I can send them to you if you want. You would need to have them checked by your NAV partner and implemented into your NAV System. But yes, this enables you to see the COGS by posting groups, and Source Type/Source No. should also be filled in. For the object files, please send me a private message.

    with best regards

    Jens

  • jenniferyoung Profile Picture
    jenniferyoung 135 on at
    RE: NAV 2009 R2 - COGS g/l account with Gen. Prod./Gen. Bus. Posting Group

    Dear Jens,

    Thank you very much for your reply.

    Our COGS are inventory items and resources resulting from the posting of the sales invoice. I understand when the invoice is posted, the cost is transferred from inventory to the relevant g/l account? At the moment we have several g/l accounts for revenue i.e. UK Units, UK Spare Parts, EU Units and so on. These all have corresponding COGS g/l accounts to match them.

    I think I understand what you are saying, because the costs are transferred from inventory, they do not use the GBPG and GPPG.

    However I am just confused as when I look at the General Posting setup under Posting Groups, for each combination of GBPG and GPPG there is an associated g/l code for the sales side AND the COGS side, so I am not sure why these codes are not also associated with the ledger entries for COGS.

    Do you know of any way in which we could have a single g/l code for COGS (like would work with sales) which could somehow be analysed by the customer type (according to the sales invoice associated with the entry) and by product type (according to what sort of product has been transferred from inventory)?

    Thank you very much for your kind and excellent help.

    Jennifer

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV 2009 R2 - COGS g/l account with Gen. Prod./Gen. Bus. Posting Group

    Hi Jennifer,

    I'm not fluent in accounting english, but from what I understand the COGS are production and handling costs? These would be posted either by purchase orders (handling) or by production orders (consumption). Both have nothing to do with the selling side... The GBPG/GPPG from the sales side are respected on the revenue accounts, they appear there and can be used for reporting (if you do some customizations, anyway). But you don't have a direct link to the cost in the G/L, this is posted differently. The only cost posting you have on a sale is a decrease in inventory. This posting is without posting groups, however. Over the item entries (which have a weak link to the G/L from sales, can be ambiguous) and their application entries you have a movement chain of which purchased or produced item has been sold. But even then getting a breakdown of the actual item cost and its posting groups can be difficult/impossible. The "shortening of the way" is the direct unit cost, and cost % in the item card. That's the amount that will be taken as decrease of inventory, and it is in the posted invoice lines, too.

    with best regards

    Jens

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans