Reversing an entire batch of incorrect estimates posted in Job Cost

How to reverse batches of incorrect estimates posted in Job Cost in Sage 300 CRE.

We provide this report as a workaround. It didn't go through the normal QA process. You can modify it to meet your reporting needs or adapt it for use with future releases.

This solution reverses all posted estimate transactions entered in a specific batch. Use this process to reverse a large group of posted estimate transactions. If you didn't post the batch, move unwanted transactions in the Job Cost New file using the move option.

Locate and verify the batch number of the incorrect estimate transactions

In Job Cost, use an inquiry to determine the batch number of any duplicate estimates posted in Job Cost.

1. Go to Inquiry, Entries, Cost/Estimate Entries.
2. Select Current and click OK.
3. Locate one of the incorrect jobs. Double-click on the Total Estimate amount.
4. Click the Cost Code column heading.
5. Select Insert column before this column and click OK.
6. Select Batch from the JC - Transaction list and click OK.
7. Scroll down and note all batch numbers with duplicate estimates. Note the Transaction Date on the batches. Run the Reverse Estimate Import report for each batch that you need to reverse.
8. Click Close.
9. Go to Job Cost, Reports, Entries, Entries by Batch.
10. Enter one of the batch numbers from step 7 in both the Batches from and Batches to boxes.
11. Click Ranges.
12. Select JC and click OK.
13. Click Start. Verify you want to reverse all entries that appear on the report.
14. Repeat steps 9-13 for any duplicate batches. After verifying, continue with the next step.

Reverse the incorrect estimate transactions

Attachment: ReverseEstimate.rpt

1. Save and print the attached Reverse Estimate report.
2. When printing the report, type the correct Transaction Date. The transaction date becomes the reversal date of the transactions.
3. In the Batch ID field, enter a batch number from the steps above.
4. Click Conditions. Verify the report has a condition of "Application of Origin Equal to JC". (Prior versions of this design didn't have this condition).
   • If you imported the batch from Estimating, change this condition to "Application of Origin Equal to PE".
5. Click Printer Setup.
6. Select the Print to file checkbox and click OK.
7. Click Start.
8. Note the Save in: location or browse to a location familiar to you.
9. In the File name box, type Reverse estimate import file.
10. In the Save as type list, select Plain Text (*.txt).
11. Click Save.
12. In Job Cost, import the estimate reversals:
13. Select Tools, Import, Estimate.
14. In the Import file box, click browse to select the print file created above.
15. In the Rejected records file box, type Reverse estimate rejects.
    • To reverse original estimates, clear the Import as an Approved Estimate Change box, and click Start.
    • To reverse approved estimate changes, check the Import as an Approved Estimate Change box, and click Start.
16. Review the import journal to confirm the import succeeded.
17. Verify that the batches net to zero:
    1. Go to Inquiry, entries, entries by batch and select the new file. Write down the new reversing batch number.
    2. Go to Reports, Entries, Entries by batch. Select new and current transaction files. Click Ranges. Select JC. Click Batches and select the original batch and the new batch number. Click Ok twice and click Print Preview. Confirm that the two batch totals reverse each other. If they don't, remove the batch in the new file or determine what is missing. You can have rejected items in the import reject file.
18. Post the entry using Tasks, Post Entries.
19. Repeat these for any other estimate batch that posted duplicate or incorrect entries in Job Cost.