Ed, you mentioned that you were a behind in getting months closed.  That could account for your issues.  Job Cost has accumulator buckets for cost and other transaction types. The JTD bucket includes everything through the "Current" month and "Next Month."  It also has a "Last Month" bucket.  Those are significant if you are pulling reports that pull amounts from those accumulated totals.

However, if you are running a report such as "Job Cost as of a specific date", then the source of the data is revealed in the description of the report, i.e., the report is pulling from the JC Transaction file (usually Current.JCT).  This is where your "behind closing a few months" might have led to your confusing results.  

Any transactions with an Accounting Date beyond the "Next Month" end date will not post until you run "Close Month"a sufficient number of times to bring the Current Month to within one month of the "Next Month" to assure that all transactions dated within the month following your current month are posted.  You should always do an Inquiry on Transactions (Entries) against the NEW.JCT file to see if there are unposted entries.  Another good procedure is to always review your posting journals because any entries that do not post to Job Cost will be listed.

Hope this was helpful.

Art Minds
Senior Independent Consultant
Pasadena CA 91101
[email protected]

Ed, you mentioned that you were a behind in getting months closed.  That could account for your issues.  Job Cost has accumulator buckets for cost and other transaction types. The JTD bucket includes everything through the "Current" month and "Next Month."  It also has a "Last Month" bucket.  Those are significant if you are pulling reports that pull amounts from those accumulated totals.

However, if you are running a report such as "Job Cost as of a specific date", then the source of the data is revealed in the description of the report, i.e., the report is pulling from the JC Transaction file (usually Current.JCT).  This is where your "behind closing a few months" might have led to your confusing results.  

Any transactions with an Accounting Date beyond the "Next Month" end date will not post until you run "Close Month"a sufficient number of times to bring the Current Month to within one month of the "Next Month" to assure that all transactions dated within the month following your current month are posted.  You should always do an Inquiry on Transactions (Entries) against the NEW.JCT file to see if there are unposted entries.  Another good procedure is to always review your posting journals because any entries that do not post to Job Cost will be listed.

Hope this was helpful.

Art Minds
Senior Independent Consultant
Pasadena CA 91101
[email protected]

I think if you select both the JC Transaction file (new) and JC Transacton file (current) you will get all transactions that are posted and unposted. 

I do try to only have the current month, and the prior month Open.  You can check what Accounting Period you are in by going to File/Company Settings/Job Cost Settings in Job Cost.  My Current Month is May, so transactions from May and June will post.  Once we get into July, if I do not close May, then transactions from July will not post until I do so.

Correct, I understand the transactions and I have seen this issue when updating revenue.  But this is a report, that even if I run today still using that specific day (APRIL 30), and still has erroneous information.  I understand I cannot run it in the future, but I was in April, closing April and it pulled in May cost numbers in a specific dated report. I checked the entries, all have the correct date and on the cost spread sheet they come out correct. On Cost Entries by Job it comes out correct.     

But you got me to thinking, and it is all about the  Data File Selection.  Thanks, that is the answer. I should not use new, when I am in a current month, and if I want to run an old one I should use History.  The title of Job Cost by specific date is a misnomer, but I get it now. Thanks!