If you use Office Connector you can create this or just about anything. I created one that we run for each job and it shows the Extra, Extra Description, Cost Code, Cost Code Description. I believe you could do the same for all jobs instead of each one individually. I just started using OC, but have found tremedous value in it.

I'm not sure about your question but I'll make a few guesses! :) 

Since you're connecting to Sage 300 for your Job Costing, you'll want to get a report of your Standard Cost Codes from the accounting department. That will give you the descriptions. You won't really see the descriptions in Estimating in an easily reportable fashion. 

To get this report out of Job Cost, open JC and then click on Reports>List>Standard Cost Codes and you'll get your report.

The above workflow gives you a master list of the cost codes.

Now, if I've misunderstood your question, and instead you're really saying that you want to be able to see each item that is inside the "Estimating" database and to also see what cost code it is assigned to (if any). Then that would be a different workflow that you could do right in Estimating. Just make a dummy estimate, drag all the items from the Estimating db into that dummy estimate (you can click "SHIFT" on the Group Phase folders during Quick Takeoff to automatically take off all the items inside that Group Phase/Phase folder when you drag/drop during quick takeoff) Pro-Tip: if you have add new item feature turned on, turn it off to do this Quick Takeoff and it'll save you a bunch of 'add new items'.

Then with all the items on your dummy estimate, create a tab to sort the estimate by JC Phase and viola! All the cost codes and the items that are assigned to them, plus a list of any items that are not assigned to cost codes.

And of course, if you wanted, you could print that tab of items from the reports menu in Estimating (Spreadsheet Report)

Please let me know if either of the above works for you.

Thanks!

HI L ANDERSEN,

Thanks for the comments; I don't use the Office connector and never worked.I only use Estimate sage.

My estimate system is kind of separate from accounting. Right now, I am trying export  JC from Sage Estimate SQL V18.11 with all descriptions and then compare with Accounting. There some discrepancies between Accounting Dep and Estimating Dep. For example there are some codes that we have in Estimate but those never have been created in the Accounting in their JC system during a long period of time.

I will your solution to Accounting and see.

I am just wondering if could tell me"OC"? What is stand for? 

Thanks!

Hello Twse,

Thanks a lot for your contributions and complete details.

I think you first part of answer fall into Accounting PKG which I don't have it and never used. I think I have already got that report in excel format. But, I am working separate from them, independent.

Yes, I am trying to export all Job Codes including description from Estimate Sage  Estimate v18.11 from STD database. I am working separate from Accounting.Once a Tender becomes as a Job, we export via Job Report.

Issues found when there are some Job Codes in our Estimate that are blanked(no descriptions), because those have never been created fully and completely.

In another word, I have some items in STD database in Sage Estimate (items) but not in the other side(Accounting).

I have started to re-check all existing Codes including missing codes. I am trying to check and compare descriptions as well. I have received JC report with codes and descriptions in Excel format. If I can extract all JC + Descriptions from Sage Estimate SQL 18.11 (the picture above) into any kind of format like PDF, Excel etc.

I like your solutions, I will try for sure. But, just wanna tell your there several JC related to our " ADD On" that won't work in your scenario. But, I will get my 99% of my answers.

I will keep you update! :)

Thanks!