Gen. Posting Groups do not flow to G/L on Inv/COGS entries

LibertyMountain

Does anybody know why the Gen. Bus. Posting Group and Gen. Prod. Posting Group do not flow through to the G/L on the INV and COGS entries of a sales invoice?

Suppose a sale (cost $10, unit price $20) that produces the following entries in the G/L:

-$10 Inventory
+$10 COGS
+$20 A/R
-$20 Revenue

only on the revenue g/l entry do the posting groups flow through to the G/L. But it would be nice if the Inventory and COGS entries showed the Gen. Posting Groups (the COGS entry especially) as you could use the G/L to get a quick gross margin by Gen. Bus. Posting Group or by Gen. Prod. Posting Group.

Anybody know why these fields don't flow through? would it be a bad idea to customize to make them flow? The place to do it, I believe, is codeunit 5802 (PostInvtPostBuf). The GlobalInvtPostBuf has the Posting Groups, but then the code neglects to pass the Posting Groups when it creates the Inventory and COGS GenJnlLines.

Thanks.

Alex_Chow

Make sure you have the Automatic Cost Posting checked ON on the Inventory Setup.

LibertyMountain

Thanks for your reply. The option is checked as you suggest. I am wondering if the reason it is not passing the posting groups is because of this very option ...

if you choose not to post costs automatically, then you are given the choice to post by entry or by posting group. if you choose to post by posting group (I assume this is Item Posting Group, not Gen. Prod. Posting Group), then there is no guarantee that your Gen. Posting Groups will be unique across the grouped entry. therefore, there is no point to pass the Gen. Posting Groups.

After researching more, that is my guess. But again, still not sure...

Alex_Chow

Are you using Job No. function in NAV?

LibertyMountain

I don't think so. we don't have the manufacturing granule. I assume the Job No. function is part of manufacturing?

Alex_Chow

LibertyMountain wrote:

I don't think so. we don't have the manufacturing granule. I assume the Job No. function is part of manufacturing?

No, it's not. Job and manufacturing are 2 separate things.

Last thing to check your mods. The situation you described is NOT how standard NAV behaves.