Reverse the items that have incorrect dates and enter new items with the correct date:
- In Job Cost enter a Direct Cost batch with lines reversing the original entries that had an incorrect date using that same date then re-enter using the correct date.
- Finish and Post
- In General Ledger go to File, Company Settings, GL Settings
- Select Processing Options
- Set Force Zero Proof to No noting what the value was prior to changing.
- Click OK twice to exit
- Go to Tasks, Post Entries and check the box Post out of balance batches
- Range on the two batches that are rejecting
- Click Start to post
- Go back to File, Company Settings, GL Settings, Processing Options
- Set Force Zero Proof back to the original value
- Click OK twice to exit.
This issue is being researched for resolution in a future update or release of Sage 300 Construction and Real Estate
Note: Before following these steps, please verify that the batch did not partially post by looking at the new file in JC and looking at the current file in GL. To determine the batch number, in GL, go to Inquiry, Entries, Batch and select the new file. Identify the out of balance batch number. Then run the same inquiry on the current file and condition on the batch number. If the batch does not exist in the current file check the status of the batch in JC. In JC, run the inquiry, entries, entries by batch and select new file. If the batch does not exist in the new file, run the same inquiry on the current file. Drill down into the batch and add columns for debit/credit accounts and verify that the batch has debit/credit accounts. Then follow the steps in this article.
If the batch is in the new.jct - there are some reasons for the batch partially posting. If the current month in JC is December and you make a direct cost batch entry in JC that has a job entry dated February and a GL only entry dated February, the GL only entry will post but the job costed entry will not until the month of December is closed and the task post entries occurs in JC.