x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 9 replies
  • Subscribers 241 subscribers
  • Views 2219 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
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
mpolk

Job Cost Reports are not including all entries in the new data file.

SOLVED
Posted By

We have not closed the year and have entries awaiting to be posted once we roll our fiscal year-end date to 2021. 

We can view new entries in GL and our posting journals from other modules such as AP, JC, PR, etc. all have messages stating Posting to a future GL period which is correct.

The problem is when we run a job cost report by entries selecting from the new data file our report excludes all January entries but shows all February & March entries.

I have confirmed that the report is pulling data from the new file.  This hasn't ever happened before, and I was wondering if anyone has experienced this same problem?

Parents
  • +1
    verified answer

    If the current period in Job Cost is December 2020, then JC transactions can post to the current file with dates through 01/31/2021. Are you sure the January entries aren't in the current.jct?

  • 0 in reply to Denise Paulus

    Denise,

    Thank you for the reply.  Yes, the January entries are showing up in the current data file.  Just wondering if an update changed the way the data pulls because in the past all entries for the new year were in the new data file.  Now the current folder contains December 2020 & January 2021 entries which seems odd because technically January should be in the new data file.

Reply
  • 0 in reply to Denise Paulus

    Denise,

    Thank you for the reply.  Yes, the January entries are showing up in the current data file.  Just wondering if an update changed the way the data pulls because in the past all entries for the new year were in the new data file.  Now the current folder contains December 2020 & January 2021 entries which seems odd because technically January should be in the new data file.

Children
  • 0 in reply to mpolk

    I think you misunderstand what Denise was explaining.  Job Cost has 3 "buckets" or fields:   Last Period, Current Period, and Next Period.  When you do the task of Post Entries and let all batches post, they will automatically post if there is a bucket available.  Since January is "Next Month" in your example, the entries posted from the new data file to the current data file. 

  • 0 in reply to mpolk

    Once the Job Cost month was rolled into December 2020, any entries with an accounting date (or in some cases a transaction date) that is less or equal to 1/31/2021 would post when running the post entries task in Job Cost. The December entries would post to the current month buckets, the January 2021 entries would post to the Next Month buckets.

  • +1 in reply to Denise Paulus
    verified answer

    Additionally there is a YTD bucket that would reflect only the entries that posted with dates in the 2020 year. When you roll the period into January 2021 the 2020 YTD totals will roll out and the totals for 2021 (next year) will replace them if you have the fiscal year end dates in Job Cost  settings set to a calendar year end that is.

  • 0 in reply to Denise Paulus

    Denise, 

    Thank you so much for the information!  You have been extremely helpful.  

*Community Hub is the new name for Sage City