ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Materials Cost in the GL
http://www.istechforum.com/YaBB.pl?num=1076542479

Message started by cathyh on 02/11/04 at 15:34:39

Title: Materials Cost in the GL
Post by cathyh on 02/11/04 at 15:34:39

I am looking for a way to capture the cost of materials (as opposed to the cost of goods sold which includes labor) at the end of each month. So far I have looked at the inventory reports and the shipments costing is in standard, the closed WO costing is good but doesn't separate finished goods from shipped items, and the month end summary for shipments appears to be average cost where it says actual, and it is a total for labor and materials. In short, I can't find any numbers that agree! Is any one else capturing this kind of information? Any suggestions? Thanks! :D

Title: Re: Materials Cost in the GL
Post by Lynn Pantic on 02/11/04 at 17:58:47

Are you looking for the material portion of the cost of items shipped or what you spent on materials which may still be in stock or WIP as of the month end? Closest estimate of the material portion of items shipped would be the material portion of Standard cost from the IN-N-B report. Cost of materials received would be the P and J transaction types on the IN-N-A report.

Title: Re: Materials Cost in the GL
Post by cathyh on 02/13/04 at 10:16:39

Thanks for your reply, Lynn. Yes I am looking for the cost of materials for items shipped only and I would really like it if I could use standard cost in IN-N-B but unfortunately with some of our higher priced materials and inacurate (still!) bills the standard is often different from the actual. WE are largely a job shop and most of the time there is no way to get the standard cost completely in sync with the actual. If I could find a report that extracts the actual labor from the total actual cost on shipped items I could at least have a number for materials and then I could make a journal entry every month to move materials to a different account. I think I can do this with an export of the CGS account to excel but I was looking for an easier solution.

Title: Re: Materials Cost in the GL
Post by Lynn Pantic on 02/13/04 at 11:04:41

The new JC-R report could work if there is a way to control the filters (Actual Finish Date maybe) to include the Work orders associated with the month's shipments,

Title: Re: Materials Cost in the GL
Post by cathyh on 02/13/04 at 13:30:47

I have the 12/31/03 update installed (we haven't done the latest two because we are in the process of getting a new server and I decided to wait to load these updates in case I had to start from scratch with DBA) but I don't have JC-R in the menu. It looks like from the update list that this was done in the 12/1 update. What do I need to do to have this report show up in the menu list?

Title: Re: Materials Cost in the GL
Post by Lynn Pantic on 02/13/04 at 14:06:11

As I recall, I forgot to add it to the menu intil one of the later updates even though you should have the program. Try UT-A, program name BKJCR. Or if you have Evolution, add BKJCR.RUN to the menu.