Don't have time to read? Watch the instructional video here:
...
Clear Period Variances
This method should only be used when clearing the period variances before the first cost report. After that, performing a Period Close whilst ticking 'Clear Costs this Period' will clear the variances.
1. In the menu bar select General Ledger > Budget Worksheet
2. Click the Select All button at the bottom left of the window
3. Right-click in the highlighted area and select Excel
...
4. Excel will automatically appear (might be hidden behind Eclipse window).
5. To clear all accounts period variances , in Excel highlightfollow these steps in Excel.
Highlight the entire EFC column (column L)
...
then right-click and select copy.
...
Then paste the entire column into the EFCW column (column Q).
Or you can edit individual rows accordingly
...
by editing the EFCW column (column Q)
6. Once your Budget looks good in excel, highlight only the data cells in the Excel worksheet (in other words, all cells with information in them except the header and footer rows), Excel worksheet and then right-click and select Copy.
Only copy from Column A to Column Q.
You do not need to select the AppOverage (R) and Adjustment (S) columns.
Do not copy the header or footer rows.
...
7. Go back to Eclipse, right-click on the Budget Worksheet window main body and select paste. Your Budget Worksheet will now be updated. Make sure to go back and close the Excel window
...
8. If you get errors when attempting to paste in:
Ensure you are copying the correct amount of data rows (See Step 6).
Try to select and re-copy the rows in Excel and attempt the paste again.
If that does not work, please try to sign out and in again by following these instructions to reset your clipboard: Eclipse Frozen / Copy & Paste not working / M Drive is not accessible - Reset your own Eclipse Session