Manufacturing BOM Cost Table

(0) Share

Report

Posted on by babubaskaran@outloo...

Dear All,

I am trying to build a smartlist which can give the total Manufacturing BOM cost of any BOM The BOM cost is the total cost derived from the total of each component associated with the main BOM. Does any of you done this if so please share or suggest what table I have to look for this.

Thanks,

Babu

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello Babu,

What you are looking for can is already included in the Manufacturing > Bill of Material Smart List. As for the calculation, it can easily be taken into Excel and a pivot table would do the job greatly.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Mahmoud,

Thanks for your reply. Yes I have already checked that and Bill of Materials smart list has a field called unit cost which which is displaying the unit cost of any sub BOM of main BOM and not the BOM cost itself. And there no other field I can identify which has BOM cost on it. Please have a look at it and let me know your thoughts.

Thanks,

Babu

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi Babu,

I'm currently working on the same report. The Stored Procedure that calculates that number is [mbomExplodeBOMandRemovePhantoms]. I'm currently extracting the code to generate the report, but i thought this might help you.

Best regards,

Carlos

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Carlos,

Thanks, let me try this and let you know my update.

Was this reply helpful? Yes No
Community Member on at

Like (2)

Report

Hi Babu,

Clear all the store procedure part, declare the variable the stored procedure was expecting has a parameter. at the end of the code, comment out the subtotal to table #stack2, and just show the result of that table. It has everything needed to Detail that BOM cost.

Best Regards,

Carlos

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Dear Carlos,

I am not able to get this worked for me, may be I am missing something. Can you please confirm how did you get this worked for you.

Was this reply helpful? Yes No
Lyn Barr 1 on at

Like (0)

Report

This was perfect, Carlos, thanks for posting this! You saved me a lot of time.

Was this reply helpful? Yes No