Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Greg Enns]

We’d like Resources on a Sales/Service Order line to post Unit Cost to the General Ledger. NAV only “posts” cost to the Resource Ledger Entries and Service Ledger Entries. 
Has anyone found a clean way to do this?

——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————

[Leo Chen]

Hi Greg

NAV not only post to Res. Ledger Entry but also to G/L. Entry

In Resource card, make sure besides the cost, Gen.Prod.Posting Group (GPPG) is populated.  In General Posting Setup, also ensure that the G/L Accounts are setup for the GPPG setup in Resource card.  Below show an example of related transactions posted to G/L and Res. Ledger entry.

——————————
Leo Chen
Systems Analyst
Summit Fertilizers
——————————
——————————————-

[Greg Enns]

My issue is not with Assembly Orders (those work fine as you describe). Rather we are trying to post Service Orders and Sales Orders with Resource lines and have NAV post both cost and revenue to the GL, but NAV only posts the revenue entries.

——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————
——————————————-

[Ken Sebahar]

?Greg,
unfortunately there is no clean/easy way to accomplish this.  There is probably a way with a set of enhancements and month-end adjusting entries to accomplish this, but it is not something we have done in the past for clients running NAV/BC.  While a Resource can have a Unit Cost defined for it that will be passed onto your service/sales lines and can be used for viewing cost/profitability statistics per Document, you do not want to be posting these costs to the G/L.   A simple example of why you do not want to post COGS for this labor:  let’s assume you have Resources defined to add labor to a Sales Order/Service Order.   You are already posting cost to the G/L as part of your payroll journal entry.  So if you were to post costs from the Resource lines during invoice posting, you would be doubling up your costs.  An alternative suggestion is to separate out your payroll so that your service/labor team’s payroll expenses are included within the COGS section of your income statement.  Hope that helps.

——————————
Ken Sebahar
Solution Systems, Inc.
ken@solsyst.com
——————————
——————————————-

[Greg Enns]

Thanks for the response Ken. We understand that these GL entries are not critical to the accounting process. We were looking to book the cost as a debit to COGS and a credit to a few different contra-expense account “Absorbed Salaries” (depending on which resource it was).

——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————
——————————————-