| Reversing entire direct cost batches that are posted in Job Cost |
Resolution | Warning: This report is provided as a possible solution to your issue. Quality Assurance has not reviewed the solution. You may need to modify it to meet your reporting needs or adapt it for use with future releases of the software. Note: If the batch is in the new file, you can move the batch using Tools, Move Transactions, New to New, instead of creating a reverse batch. See Moving unwanted transactions in the Job Cost New file using the Move option Create a reverse import file: - Use File Tools to back up your data folder (Tools, File Tools) before downloading and adding the report.
- Download the report below
- Go to your Downloads folder in Windows File Explorer or the folder to where you saved the report
- Cut or Copy the report from that location and place either in your Company Data folder or in the Report folder in the Default location on the server. (Default location is \\servername\Timberline Office\9.5\Accounting\Report)
- You can either:
- Print the report in Report Designer
- Use Report Manager to add it to your Reports menu (as a TS report design).
- In JC, go to Reports, Report Manager.
- Name your report "JC Reverse Direct Costs" and place under the desired menu item.
- File Name, click List and go to the location where you copied the downloaded report.
- Source should stay TS report design
- Click OK.
- In the Batch # box, type the batch number of the Job Cost batch.
- Leave the New Accounting Date box blank to use the original accounting dates or enter a new accounting date for the transactions.
- Click Conditions. Verify Application of Origin = JC.
- If not, click Add. Select Application of Origin in the field list, Equal to as the operator, and JC as the value. Click OK.
- Click OK.
- If your system is set to always print to file, click Start. A Print File Selection window will open.
Note: If the system is not set to always print to file, you will need to click Printer Setup. Place a check in the Print to file box, click OK, click Start. A Print File Selection window will open. - In the Save as type box, select Plain Text (*.txt).
- In the File name box, type undobatchBatch number.txt.
- Click Save.
Note: The report automatically adds the text (REV) to the description field of the import file. The field has a 30-character limit. If your descriptions exceed 30 characters with the added text, edit the import file to successfully import the reversal.
Import the reverse import file: - In Job Cost, from the Tools menu, select Import, Direct Costs.
Note: If part of your JC direct cost batch was a GL only line, go to JC Settings, Import tab and check the box Force Zero Proof to No. This will allow the GL only line to import with the JC direct cost lines. - Click for the Import file box.
- In the Files of type box, select Plain Text (*.txt), select the file you created, and click Open.
- In the Rejected records file box, type the name for a reject file (for example, undobatchBatch numberrej.txt).
- Click Start.
Confirm the import of the batch was successful: - From the Inquiry menu, select Entries, Entries by Batch.
- Select New and click OK.
- Locate the batch and click Close.
- From the Tasks menu, select Post Entries, and click Start.
[BCB:156:Chat 300 CRE US:ECB]
|
|