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!

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!

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!