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

  • Hi,

    I had this issue and had to have the Job Cost Summary report redone for me to be able to see the correct end of month amount in the JTD column, otherwise the report was not useful at all and had to go back and forth trying to tie it out.

  • in reply to Jackie@PDI

    Jackie, I am curious as to who had to "redo" the Job Cost report.  Please note that I am looking at the Job Cost as of a Specific Date.  Is this a crystal report?  I do not understand the purpose of a report to a specific date that does not go to that specific date. I am finding questions in some reports and I am wondering how they are written. I thought they came as a package, but I am new to the SAGE stage.  thanks, again. 

  • in reply to Ed Dailey

    Hi Ed, We used Alliance Solutions to purchase the software. They designed the reports for us. We use a job cost summary report that has detail by cost code, but the JTD column was not right. The had to redo it this past month cause it was too much work for me to carve out the current month transaction. Crazy! Now it works perfectly!

  • in reply to Jackie@PDI

    Thanks Jackie!  I found the problem, it is in the Data File Selection. I reran April, now just selecting JC transaction (history) and it was correct.  So when behind it is critical to know the current month is the one that is not closed, the new month is the one after the current month and history is the one before.  Great learning session, but all the input from others really helped.  Thanks again.

Reply
  • in reply to Jackie@PDI

    Thanks Jackie!  I found the problem, it is in the Data File Selection. I reran April, now just selecting JC transaction (history) and it was correct.  So when behind it is critical to know the current month is the one that is not closed, the new month is the one after the current month and history is the one before.  Great learning session, but all the input from others really helped.  Thanks again.

Children

*Community Hub is the new name for Sage City