Workspace Condition

Affecting Import Transaction

Set Current Values Prior Executing Import Transaction Command

Affecting Export/Copy Transactions from Ledger

Set Current Filters Prior Executing Ledger to Ledger/Export Commands

Affecting Ledger to Ledger Consolidation

Set Consol Rules Prior Executing Ledger to Ledger/Export Commands

Affecting Inventory Costing

Set Current Costing Rules Prior Executing Calculate Balance Commands

Set_Currency

Set_Currency

This command can be used to change current workspace condition in respect of current value of base currency to effect for importing transactions.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to create a ledger without base currency.

Command with Parameters

e.g. Set_Currency “CNY”

Target Currency

Specify a Currency
e.g. CNY

Set_DC

Set_DC

This command can be used to change current workspace condition in respect of current value of Debit / Credit side to effect for importing transactions.

Prerequisite Knowledge

Before learning how to use this command, users shall understand to create a ledger with implementation of double entry methodology.

Command with Parameters

e.g. Set_DC “C”

Current Value

Specify D or C
e.g. C

Set_Group

Set_Group

This command can be used to change current workspace condition in respect of current value of Debit / Credit side to effect for importing transactions.

Prerequisite Knowledge

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

Command with Parameters

e.g. Set_Group “PRC”

Current Value

Specify a group
e.g. PRC

Set_Ledger

Set_Ledger

This command can be used to change current workspace condition in respect of current value of ledger identification.

Prerequisite Knowledge

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

Command with Parameters

e.g. Set_Ledger “A01”

Current Value

Specify a ledger
e.g. A01

Set_Include_Filter

Set_Include_Filter

This command can be used to change current workspace condition in respect of current filter to include a range of values with optional to include and exclude value patterns.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to create a ledger with transactions.

Command with Parameters

e.g. Set_Include_Filter “Account” “10000000..99999999:1???????:?3??????”

Note: It supports to configure multiple filter with referring to different column names of transaction file and each column can have one set of value range at the same time.

Source Column Name

Specify column name of transaction file of source ledger
e.g. Account

Current Value Range

Specify a range of value with including value pattern and excluding value pattern
e.g. 10000000..99999999:1???????:?3??????

Set_Exclude_Filter

Set_Exclude_Filter

This command can be used to change current workspace condition in respect of current filter to exclude a range of values with optional to include and exclude value patterns.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to create a ledger with transactions.

Command with Parameters

e.g. Set_Exclude_Filter “Account” “10000000..99999999:1???????:?3??????”

Note: It supports to configure multiple exclude filters with referring to different column names of transaction file and each column can have one set of value range at the same time.

Source Column Name

Specify column name of transaction file of source ledger
e.g. Account

Current Value Range

Specify a range of value with including value pattern and excluding value pattern
e.g. 10000000..99999999:1???????:?3??????

Set_Reverse_Filter

Set_Reverse_Filter

This command can be used to change current workspace condition in respect of reversal filter to include a range of values with optional to include and exclude value patterns.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to create a ledger with transactions.

Command with Parameters

e.g. Set_Reverse_Filter “Account” “10000000..99999999:1???????:?3??????”

Note: It supports to configure multiple reverse filters with referring to different column names of transaction file and each column can have one set of value range at the same time.

Source Column Name

Specify column name of transaction file of source ledger
e.g. Account

Current Value Range

Specify a range of value with including value pattern and excluding value pattern
e.g. 10000000..99999999:1???????:?3??????

Delete_Include_Filter

Delete_Include_Filter

This command can be used to change current workspace condition in respect of removal of a current include filter.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use Set_Include_Filter to create a include filter.

Command with Parameters

e.g. Delete_Include_Filter “Account”

Source Column Name

Specify column name of transaction file of source ledger
e.g. Account

Delete_Exclude_Filter

Delete_Exclude_Filter

This command can be used to change current workspace condition in respect of removal of a current exclude filter.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use Set_Exclude_Filter to create a include filter.

Command with Parameters

e.g. Delete_Exclude_Filter “Account”

Source Column Name

Specify column name of transaction file of source ledger
e.g. Account

Delete_Reverse_Filter

Delete_Reverse_Filter

This command can be used to change current workspace condition in respect of removal of a current reverse filter.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use Set_Exclude_Filter to create a include filter.

Command with Parameters

e.g. Delete_Reverse_Filter “Account”

Source Column Name

Specify column name of transaction file of source ledger
e.g. Account

Import_Mapping

Import_Mapping

This command can be used to import a mapping file to current workspace. A mapping table is a list of mapping values for each source columns to each target columns of transaction file of ledger(s) of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the specification of the transaction file and how to create a ledger with transactions.

Command with Parameters

e.g. Import_Mapping “C:\LB\Mapping.xlsx” “PRC”

Mapping File Path

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

Mapping Name

Assign an unique name of the source mapping file
e.g. PRC

Set_Mapping

Set_Mapping

This command can be used to change current workspace condition in respect of current mapping name of an imported mapping file.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the how to import a mapping file.

Command with Parameters

e.g. Set_Mapping “PRC”

Mapping Name

Specify a mapping name

e.g. PRC

Set_Currency_Translation_Option

Set_Currency_Translation_Option

This command can be used to change current workspace condition in respect of selecting one currency translation option.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the how to import a mapping file.

Command with Parameters

e.g. Set_Currency_Translation_Option “1”

 

Translation Option

Specify any one option

e.g. 1

1: Translation rule “original amount of source ledger converting to base amount of target ledger for each transaction”

2: Translation rule “base amount of source ledger converting to base amount of target ledger for each transaction”

3: Translation rule “base amount of source ledger converting to base amount of target ledger for each trial balance”

 

Clear_Mapping

Clear_Mapping

This command can be used to change current workspace condition in respect of clearing current mapping name of an imported mapping file.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the how to set current mapping.

Command with Parameters

e.g. Clear_Mapping “PRC”

Mapping Name

Specify a mapping name

e.g. PRC

Delete_Mapping

Delete_Mapping

This command can be used to delete a mapping file of current workspace.

Prerequisite Knowledge

Before learning how to use this command, users shall understand the how to import a mapping file to current workspace.

Command with Parameters

e.g. Delete_Mapping “PRC”

Mapping Name

Specify a mapping name

e.g. PRC

Set_AsAt

Set_AsAt

This command can be used to change current workspace condition in respect of cut-off date to effect calculation of inventory account balance.

Prerequisite Knowledge

Before learning how to use this command, users shall understand to create a ledger with implementation of inventory costing calculation. Ledger type shall be configured as “S”.

Command with Parameters

e.g. Set_AsAt “30/09/2016”

Cut-off Date

Specify a cut-off date

e.g. 30/09/2016

Set_Cost_Method

Set_Cost_Method

This command can be used to change current workspace condition in respect of costing method which affects the calculation of unit cost of stock out.

Prerequisite Knowledge

Before learning how to use this command, users shall understand to create a ledger with implementation of inventory costing calculation. Ledger type shall be configured as “S”

Command with Parameters

e.g. Set_Cost_Method “FIFO”

Costing Method

Specify a costing method

e.g. FIFO

FIFO – First in first out

LIFO – Last in first out

Average

LOT – Unique lot number