You’re offline. This is a read only version of the page.
10
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.
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.
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.
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
Hi Daniele, Thank you for the response.
But it looks like the above provided link is not relevant.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (