x Want to participate? Join the group to interact
  • Replies 11 replies
  • Subscribers 242 subscribers
  • Views 3705 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Ed Dailey

Job Cost as of Specific Date

Posted By

In comparing one job from one month (APRIL) to the other (MAY) this report showed (APR) JTD costs that actually pulled costs from MAY.

I struggled with this for about 4 hours finding the the entries were in fact correct, with the correct accounting date. I checked on the Job Cost Summary, Cost Spread sheet and JC entri

I was behind in getting months closed, so I have the data within a week of each other.

Has anyone else run into this. This report becomes worthless for cost anylsis if it does not pull by the correct date.  Only having a year with Sage I am no expert, but maybe someone else has had this problem. I do not know if anyone ever verified that the report works correctly.  I have seen variations when running this report and the month is not closed, but it corrects itself once you post you close and post your entries, or estimate inputs.

Any insight is helpful. Thanks.  

Ed

Parents

  • JTD Costs is just a bucket of costs for any period for the job = JOB TO DATE.  I think you were expecting MTD Costs (MONTH TO DATE) costs. 

     So yes, it's useless by date.   The Cost Spreadsheet (by date range) appears to be more what you are looking for.

Reply

  • JTD Costs is just a bucket of costs for any period for the job = JOB TO DATE.  I think you were expecting MTD Costs (MONTH TO DATE) costs. 

     So yes, it's useless by date.   The Cost Spreadsheet (by date range) appears to be more what you are looking for.

Children
  • in reply to Rhonda V

    So if the date I use, EOM for example then it should be all the costs in there for that month. My question is that when you total the April and May together it is correct.  So what exactly is the report good for?  Our PM want the report to check where we are against our estimate, but again if the bucket of costs pull ones with an accounting date in the next month, kind of makes the specific date uselss.

  • in reply to Ed Dailey

    Rhonda, thanks I had shared the spreadsheet but we have been using the other for over 10 years and the newbie is not going to get that changed anytime soon.  I just wondered the purpose of an inaccurate report.  Sorry to sound frustrated but not a lover of the Sage world yet. 

*Community Hub is the new name for Sage City