Asset Register - Sales Amount

Updating the Sales Amount on the Assets Register report can be done via the Ledger Inquiry.

Edit Transaction Record(s) Individually

1. Highlight the transaction you want to make changes to and click on Change button or double click the field.

2. Tab through till you reach the column you wish to change. Make edits and hit enter:

Open

Edit Transaction Records(s) in bulk

Instead of editing manually inside Eclipse, you can run a ledger inquiry report to Excel over the transactions you want to edit. See: General Ledger Inquiry Reports and Ledger Inquiry and Bulk Transaction Updates

1. Once the Excel report has been generated, Open it and Edit the Sales Amount column AC of the report in excel:

   Open

   

2. Copy the row of the transactions from columns A to AC in Excel.

• Do not go beyond column AC.

• Do not copy the header or footer row, only the data lines. 
  
  

3. Go to the Ledger Inquiry screen in Eclipse, right-click on any record, and select Paste.
   
   

   
   
   

4. The transactions will then be updated in Eclipse.
   
   

5. You can then run the Asset Register Report: Asset Report