Skip to content

Updating Last Years Balances

This is only possible if user Sage system allows it (system key NLUPDMAST = YES).

Sage's own functionality with regards to entry of reporting currency last year balances seems to be suspect,

and user may wish to check this all works to user satisfaction before using this functionality.

If allowed user can download and update the base and reporting currency last year's balances held against (detail level) posting codes.

Four sets of ranges are provided:

  • Base currency (download)
  • Reporting currency (download)
  • Base currency (upload)
  • Reporting currency (upload)

Upload ranges can be laid over download ranges.

When updating, user can choose not to include the reporting or base currency ranges.

If creating new records, the other value to the one included on the spreadsheet will always be calculated using the current exchange rate.

If updating existing records, user can choose whether the other value to the one included on the spreadsheet is recalculated or left unchanged. This is set in Options.