general posting setup mapping

(2) Share

Report

Posted on by Aspen

342

Hi Business central allows to map one direct cost applied account to capture all the raw materials consumed in production per general product group. How about the situation that there are 2 accounts for different types of materials? My thought is to create a material dimension for the item and assign different values to the item. This way, even all materials are posted into one direct cost applied account, user could still know the consumption of different types of materials. Please advise.

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (2)

Suggested answer

YUN ZHU 84,325 Super User 2025 Season 1 on at

Like (0)

Report

general posting setup mapping

I think using dimensions is the best approach, which is more reasonable than directly modifying the posting group.

PS: In addition, in Business Central 2023 wave 2 (BC23), Microsoft released the following features, but this is for AR and AP, I hope it can also give you some hints.

Use different general ledger accounts for payables, receivables

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave2/smb/dynamics365-business-central/use-different-general-ledger-accounts-payables-receivables?wt.mc_id=DX-MVP-5004336

Thanks

ZHU
Suggested answer

Ramesh Kumar 5,120 on at

Like (1)

Report

general posting setup mapping

In Business Central, the Direct Cost Applied account is assigned per General Product Posting Group via the Inventory Posting Setup. By default: All material consumption posts to the same G/L account (e.g., 50010 - Direct Materials Applied) There's no native way to split posting to multiple G/L accounts for different material types unless you split by Item Posting Groups or Gen. Prod. Posting Group

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
Verified answer

Sagar Dangar, MCP 538 on at

Like (1)

Report

general posting setup mapping

Hi,

Using different dimensions is good approach but Try below approach if that's fit according to your requirement.

for different types of materials, you can create 2 separate items and assign different general product posting group and accordingly 2 different account setups.
Verified answer

RockwithNav 7,059 on at

Like (1)

Report

general posting setup mapping

That's one of the ideal situation and a solution to engage Dimensions and keep a very nice track of your Reporting. If you have two different GL then this way wont work, you have to tweak your solution with Gen Prod Posting Group only.