| Remove unposted transactions from General Ledger using the Move option |
Description | If you have unwanted entries in your New.glt file, move them to a separate folder. We recommend moving instead of deleting them. Use this method to clean up unposted transactions. |
Resolution | [BCB:1:Backup warning:ECB] Considerations before Moving Transactions: - You can move batches or transactions you entered in General Ledger if they aren’t needed
- Before moving entries that originated in another application, make the correcting entries in the application of origin
- Removing transactions from interfacing applications may make batch-to-batch reconciliation between General Ledger and interfacing applications difficult
- Moving entries that don’t net to zero by Account and Accounting Date may cause an out of balance situation
- If you don’t want any of the entries in the new file, see these steps to use File Tools to rename the new.glt
If you can't post the entries and a journal entry has been made, you can move the batch. This could be due to and out of balance batch or the dates being outside GL posting dates. However, this may result in an out of balance between General Ledger and the interfacing application. Contact your Sage Consultant or Sage Expert Services for assistance with reconciliation issues Identify the entries to move: - In General Ledger, select Inquiry, Entries.
- Select the New GL transaction file and click OK.
- Click Select, select Add column after this column, and then click OK.
- From the GL transaction record, select other columns as needed and click OK.
Note: You can use records such as Run Number, Sequence Number to identify individual transactions within a batch. Repeat these steps to show additional information on the inquiry. - Make note of the Batch, Run and Application of Origin, and any additional information to identify the transaction.
- Click Close.
- Click Close.
Moving the Entries: - In General Ledger, from the Tools menu, select Move Transactions, New to New.
- In the Destination File Selection window, select an archive folder in the Look in box. This is where you’ll move the unwanted transactions.
- In the File name box, accept the name NEW and click Open.
- Note: If this is the first time you’re moving transactions into this folder, the message File not found. Okay to create? appears. Click Yes.
- In the Print Selection window, enter a Cutoff date for the accounting date of the latest transaction to move.
- Select Conditions.
NOTE: If you don’t select conditions, it will move all transactions in the New file through the cutoff date. - In the Field column, select Batch.
- In the Operator column, select Equal to.
- In the Value column, type the batch number.
- Click OK.
- Click Add.
- In the Field column, select Application.
- In the Operator column, select Equal to.
- In the Value column, type the application of origin.
- Click OK.
- Repeat the steps to condition by additional records needed to identify the transactions then click OK.
- Click Start.
- Review the journal to verify that the correct batch or entries moved without errors.
- To view the entries in the archive folder, see steps to access moved entries.
Tip: If moving the batch removes all items in the new file, the program deletes the new.glt file. Follow these steps to recreate the new file. - Go to Tasks, Record Entries.
- A pop-up message will appear, The new.glt file does not exist, do you want to create it?.
- Select Yes.
- Click Cancel to close out of the entry window.
|
|