Small and medium business | Business Central, N...

COGS (Cost of goods sold ) Account GL Entry doesn't contain Gen business and Gen product posting groups

(0) Share

Report

Posted on by Sayyam Abbasi

Hello Business central community,

I am working on sales reporting where I need to reconcile the COGS (Cost of Good sold) amount on the basis of Gen Product and Gen Business Posting Group. But, Unfortunately when I SHIP & Invoice to order in business central the COGS GL entries doesn't contain any posting group. Due to which I cannot segregate the sales on the basis of Posting groups combination.

I am attaching the GL entries snapshot for one of the posted Sales invoice where I highlighted the COGS entries.

If I specify the Gen Prod and Gen Bus posting groups on the COGS GL Account (5011) then It will fix the posting groups for all customers and products.

I am not sure, is there any configuration for COGS account to enable the posting groups. If anyone have faced such issue or would like to suggest on it then I would love to hear and implement.

Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sayyam Abbasi 10 on at

Like (0)

Report

Hi Aman, Thank you for the quick response.

Unfortunately the above solution doesn't work. The Automatic Cost Posting was already set to true and I set the Automatic Cost Adjustment set to Always and then I created new order and post it.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

look this

community.dynamics.com/.../how-to-set-up-purchase-and-cogs-for-retail-customers-in-general-posting

DAniele

Was this reply helpful? Yes No
Sayyam Abbasi 10 on at

Like (0)

Report

Hi Daniele, Thank you for the response.

But it looks like the above provided link is not relevant.

Was this reply helpful? Yes No
Suggested answer

Manan_Shah 1,459 on at

Like (0)

Report

Hi Sayyam,

As per your screen shot those highlighted lines are Direct cost posted.

Please check below link for more details.

https://www.solsyst.com/post/adjust-cost-what-it-is-and-why-you-need-it

Many Thanks,
Manan

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

Maybe you should look into using the item ledger entries as the source of your report instead of using the G/L Entries.

The item ledger entry will show all your cost and you have access to both the item and the customer so you can find both the prod and bus. posting groups from there.

Was this reply helpful? Yes No
Suggested answer

Alfredo_Iorio 1,264 on at

Like (1)

Report

I agree with Inge. Build your report from the ILE table. If you are comfortable managing a bit of complexity when building reports in BC, I would look at the value entries too. There, you will find all the details you need for your report.

Was this reply helpful? Yes No