web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Actual Cost Report
Microsoft Dynamics AX (Archived)

Actual Cost Report

(0) ShareShare
ReportReport
Posted on by Community Member

I have been given the task of coming up with a report to show variances for labor and materials by work orders finished within the fiscal year. I can pull a report for all work orders ended for the year and the item numbers associated with those work orders. I can pull a report for the standard costs per item and do a "VLookup" to combine the information. What I can't seem to find is a way to run a report for the work order showing actual costs for each work order. The best I can come up with is the In Process Production Cost report. If the work is in process, will this give me the total actual costs for the work order if the order is ended? If not, how can I go about getting the actual costs by work order? Please help. I have to have this done by tomorrow.

*This post is locked for comments

I have the same question (0)
  • Tim Schofield Profile Picture
    Tim Schofield on at

    Not sure this works in AX 2009 - but I think that from the production order there is a Price inquiry, which is looking at a BOMCalcTrans table. From that table you should be able to see the actual cost of each work order.

  • Community Member Profile Picture
    Community Member on at

    Thanks, Tom. I can look each work order up individually but I have thousands of them for the fiscal year-to-date. I was looking for a report that might give me that information. What I'm doing right now is compiling all the IPP reports that have been stored for the year to see what I can come up with. I'm hoping the final amounts for the WO's on these reports is the actual number.

  • Tim Schofield Profile Picture
    Tim Schofield on at

    Yup. Wasn't thinking that you'd look at each work order separately but dive directly into that underlying table and summarise. I think that you'll find that there is one Level = 0 record for each work order that might help.

  • Community Member Profile Picture
    Community Member on at

    Thanks again, Tim, and I'm sure your answer is completely accurate. However, I have had exposure to AX for exactly 3 weeks....  I have NO idea how to get to the tables. I even tried fiddling around with Atlas until I realized that the sets of information I need are from two separate tables and since I don't know Atlas either, I couldn't combine tables in one list report. I guess I'm stuck just doing what I'm doing now. I hoped there might be a "canned" report out there somewhere.

  • Community Member Profile Picture
    Community Member on at

    Can you tell me how to get to the table?

  • Tim Schofield Profile Picture
    Tim Schofield on at

    You'll want to use the Table browser. Either open the AOT (Ctrl-D) and then Open Data Dictionary > Tables then find BOMCalcTrans and Right-Click > Open.

    Try this in a non-production environment first - if you have one.

    Or Administration > Periodic > SQL Administration. Open All tables and find BOMCalcTrans and then Table actions > Browse table.

    Be careful! the table browser can update - it's not's display only.

    Your production orders are in ProdTable.

    Hope this helps.

    Tim

  • Community Member Profile Picture
    Community Member on at

    I'll try this on Tuesday. I needed it Friday morning. Hopefully I won't lose my job over this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans