x Want to participate? Join the group to interact

Sage Construction & Real Estate

Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Sage 300 CRE General Discussion Job Cost Report

Job Cost Report

Posted By UCC over 8 years ago

I am using Sage Version 14.1.19 and am trying to create a Cost Transactions report with the following information:

Category / Transaction Date / Vendor / Description / Units / Amount

Also including totals/phase totals.

I would greatly appreciate assistance with creating this report.

Thank you

UCC

Parents

Andy T over 8 years ago

I would suggest you using report designer take a copy of Cost Entries by Job and then change accounting date to transaction date. Add vendor. Then I think the report will be what you want. If you want the vendor name instead of the number you will have to pull from the AP-Vendor.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Andy T over 8 years ago

I would suggest you using report designer take a copy of Cost Entries by Job and then change accounting date to transaction date. Add vendor. Then I think the report will be what you want. If you want the vendor name instead of the number you will have to pull from the AP-Vendor.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Dina Hashim over 2 years ago in reply to Andy T

two questions .. what is the purpose of accounting date? Is that just when entered vs actual invoice date? 2nd question.. well 2nd subject question .. HOW plz tell me there is a way .. how can you get Name be the search criteria rather than ID for EVERYTHING .. gl acct, vendor, customer, if I new the ID's by heart I wouldn't need a look up. HELP!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Lorie Kane over 2 years ago in reply to Dina Hashim

The Accounting Date tells you what accounting period the transaction hits your financials. You can choose whether it is entered, duplicate of the invoice date, etc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Balcoda Support over 2 years ago in reply to Dina Hashim

Unfortunately, there isn't a way to do this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Dina Hashim over 2 years ago in reply to Balcoda Support

I thought not, I did see the cloud version you could but you loose so much more it's not worth it. But thank you for confirming.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel