Ledger Processing 1

Import_Master

Import_Master

This command can be used to create or amend ledger(s) of current workspace with relevant master information.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the specification of the master file.

Command with Parameters
e.g. Import_Master “C:\LB\Ledger Master.xlsx”

Source File Path

Specify full file path of an Excel Workbook which contains a qualified master file.
e.g. C:\LB\Ledger Master.xlsx

Import_Transaction

Import_Transaction

This command can be used to append transaction(s) to ledger(s) of current workspace from a standard import file format.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the specification of the transaction file.

Command with Parameters

e.g. Import_Transaction “C:\LB\Transaction.xlsx” Import_Transaction “C:\LB\Transaction.xlsx” “Sheet2” “Apple”

Note: If not specifying worksheet name, the system can append transaction if first worksheet contains a qualified transaction list.

Source File Path

Sprecify full file path of an Excel Workbook which contains a qualified transaction file.
e.g. C:\LB\Transaction.xlsx

Source Worksheet Name (Optional)

Specify worksheet name of the source file which contains the transaction list
e.g. Sheet3

Source Worksheet Name (Optional)

Specify worksheet name of the source file which contains an alternative transaction list
e.g. Apple

Calculate_Balance

Calculate_Balance

This command can be used to calculate and build balance tables of ledger(s) of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands “Import_Master” and “Import_Transaction“.

Command with Parameters

e.g. Calculate_Balance “A01” “A02”

Target Ledger

Specify a Ledger
e.g. A01

Target Ledger (Optional)

Specify another ledger
e.g. A02

Period (Optional)

If no define period, the system will calculate ledger(s) starting from first period of each ledger. By defining a period, the system will calculate balance starting from current opening balance of the defined period to all remaining periods.
e.g. 01/2010

Calculate_All_Balance

Calculate_All_Balance

This command can be used to calculate and build balance tables of all ledgers of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the basic command “Calculate_Balance“.

Command with Parameters

e.g. Calculate_All_Balance

Note: This command do not have any parameter.

Clear_Master

Clear_Master

This command can be used to delete master information of ledger(s).

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the command “Import_Master“.

Command with Parameters

e.g. Clear_Master “A01” “A02”

Target Ledger

Specify a Ledger
e.g. A01

Target Ledger (Optional)

Specify another Ledger
e.g. A02

Clear_Transaction

Clear_Transaction

This command can be used to delete all transactions of a ledger of current workspace by a specific period range.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands “Import_Master” and “Import_Transaction“.

Command with Parameters

e.g. Clear_Transaction “10/2016..12/2016” “A01”

Period Range

Specify start period..end period
e.g. 10/2016..12/2016

Target Ledger

Specify a Ledger
e.g. A01

Clear_All_Transaction

Clear_All_Transaction

This command can be used to delete all transactions of ledger(s) of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the basic command “Clear_Transaction“.

Command with Parameters

e.g. Clear_All_Transaction “A01” “A02”

Target Ledger

Specify a ledger
e.g. A01

Target Ledger (Optional)

Specify another Ledger
e.g. A02

Clear_Balance

Clear_Balance

This command can be used to delete balance tables of ledger(s) of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands “Calculate_Balance“.

Command with Parameters

e.g. Clear_Balance “A01” “A02”

Target Ledger

Specify a Ledger
e.g. A01

Target Ledger (Optional)

Specify another ledger
e.g. A02

Delete_Ledger

Delete_Ledger

This command can be used to delete a ledger of current workspace. This is equivalent to the results of using "Clear_Master", "Clear_Transaction" and "Clear_Balance".

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the command Import_Master” to create a ledger.

Command with Parameters

e.g. Delete_Ledger “A01”

Target Ledger

Specify a Ledger
e.g. A01

Merge_Ledger

Merge_Ledger

This command can be used to merge a source ledger and its transactions to a target ledger of current workspace. Source ledger will be disappeared upon completed processing.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the command Import_Master” and “Import_Transaction” to create a ledger with transactions.

Command with Parameters

e.g. Merge_Ledger “A01” “A02”

Source Ledger

Specify a ledger
e.g. A01

Target Ledger

Specify another ledger
e.g. A02

Rename_Ledger

Rename_Ledger

This command can be used to change identification of a ledger of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the command Import_Master” to create a ledger.

Command with Parameters

e.g. Rename_Ledger “A01” “A02”

Ledger Identification before Rename

Specify existing identification
e.g. A01

Ledger Identification after Rename

Specify revised identification
e.g. A02

Upload_Analysis_Path_File

Upload_Analysis_Path_File

This command can be used to improve performance of complex report processing which contains mass volume of formulas using multi-level analysis.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands “Import_Master“, “Import_Transaction” and how to configure reporting using multi-level analysis.

Command with Parameters

e.g. Upload_Analysis_Path_File “A01” “C:\LB\Analysis Path.xlsx”

analysis_path_sample_01

Target Ledger

Specify a ledger which contains multiple analysis categories
e.g. A01

Analysis Path File

Specify full file path of an Excel Workbook which contains a list of analysis path
e.g. C:\LB\Analysis Path.xlsx