Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Lewis Rosenberg]

?Hello NAVUG Friends,

 

We would like to have the ability to report on historical costs using the values (from the time of transactions) for the following fields:

 

• Rolled-up Material Cost
• Rolled-up Capacity Cost
• Rolled-up Subcontract Cost
• Rolled-up Cap. Overhead Cost

 

These fields exist on the Item Card but since we want to do historical reporting, we have considered adding them to the Item Ledger Entries to capture these costs with each transaction.

 

Is anyone else doing anything similar?

#NAV2013R2
#Manufacturing
#Inventory Costing

??????

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————

[Ian Ray]

If I understand what you are getting at, I have done something similar with materials and capacity with Jet by pointing at the Value Entries. The result is cost (actual) / quantity over a period of time. I suppose this could get specific to individual transactions, but I have so far only done this as an average over a user-specified period.

We also do capacity costs from value entries for individual production orders as compared to average cost for the previous 90 days. This isn’t historical data so much as a KPI. (Edit: this wouldn’t be valuable unless you do manual capacity flushing)

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-

[Michael Carr]

Lewis,

I am using the rolled up material and labor for standard costing to post labor to the general ledger using a modified report.

However I post the results through a manual journal each month.

I see a lot of value in your approach which is more valuable to my mind in FIFO or actual costing.

Don’t know why it wouldn’t work —- how expensive might be another story.

——————————
Michael Carr
VP , Finance
Philadelphia Scientific LLC
Montgomeryville PA
——————————
——————————————-