Adding an element to a posting scheme through form
To add a posting scheme element through form, click [Add through Form] in the Elements button group. Clicking on that button opens the form of the posting scheme element.
Figure 51 Posting scheme element form.
In the opened form, there is the field: Element Calculated For: payment, header, element, subelement, and analytical description. Depending on the selected option, the appropriate variables will be available in particular items.
Checking the field Currency posting means that a scheme is defined to be used for posting of documents in a foreign currency on accounts kept in the same currency.
Checking the field Save VAT rate means that the VAT rates determined for particular elements will be presented on the list of journal entries (when posting documents on the basis of such elements).
Note: A posting scheme will merge only those single-sided entries which have the same VAT rate.
In case of trade and warehouse documents, for option: Payment, the following macros are available:
- For item: Account Dr/Cr - a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Employee account of given type:
Ø Remuneration
Ø Prepayments
Ø Other types defined by the used in the account types directory
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. The amount is retrieved from the source document, depending on the selected macro. Possible options are:
Payment – payment value for a given payment form
Receivable – receivable value for a given payment form
Payable – payable value for a given payment form
PaymentApplied – payment value applied in a given payment form
ReceivablePaid – receivable value paid in a given payment form
PayablePaid – payable value paid in a given payment form
RemainingPayment – remaining payment value to be applied in a given payment form
RemainingReceivable – remaining receivable value to be paid in a given payment form
RemainingPayable – remaining payable value to be paid in a given payment form
SQL query
For each of the above macros, there are the following payment forms available:
Check
Cash
Bank Transfer
Other payment form defined by the user
The item Amount is mandatory.
- For item Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. It is used for specifying an additional condition which needs to be fulfilled by a document posted with the use of a given posting scheme. Possible options are:
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Employee account of given type:
Ø Remuneration
Ø Prepayments
Ø Other types defined by the used in the account types directory
Currency
Payment is a receivable
Payment is a payable
Payment Form
Payer is a customer
Payer is an employee
Payer Code
Document Description
Payment Description
Attribute value from document
Attribute value from payment
SQL query
Insert value from directory
ØCurrency
- For item Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. It is used for providing additional information. Possible options are:
Currency
Document Description
Payment Description
Proper Number
Reference Number
Document Attribute – attribute value from directory
Payment Attribute – attribute value from payment
Number in Account
SQL query
In case of trade and warehouse documents, for option: Header, the following macros are available:
- For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. The amount is retrieved from the source document, depending on selected macro. Possible options are:
Sum of Subtotals
Sum of Totals
Total Tax
Total Amount Paid
Amount Paid in Cash
Amount Paid by Bank Transfer
Amount Paid by Check
Sum of totals in a given tax rate
Sum of subtotals in a given tax rate
Total tax in a given tax rate
SQL query
For macros connected with amounts in a given tax rate, there are the following tax rates available:
A (Rate A 22%)
B (Rate B 7%)
C (Rate C 0%)
D (Rate D 0%)
E (Rate E 0%)
F (Rate F 3%)
G (Rate G 6%)
Other tax rate specified by the user
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with defined scheme. Possible options are:
Sum of Subtotals
Sum of Totals
Total Tax
Currency
Document Description
Due Date
Total Amount Paid
Amount Paid in Cash
Amount Paid by Check
Amount Paid by Bank Transfer
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
SQL query
Insert value from directory
Ø Currency
- For item: Description - a list of predefined macros is dropped down upon clicking on the arrow
. This macro is used for providing additional information. Possible options are:
Proper Number
Currency
Document Description
Number in Account
SQL query
In case of trade and warehouse documents, for option: Element, the following macros are available:
- For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Item account of given type:
Ø Warehouse
Ø Sales
Ø Prime Cost
Ø Other types defined by the user in the account types directory
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. The amount is retrieved from the source document, depending on selected macro. Possible options are:
Subtotal Item
Total Item
Item Tax
Acquisition Value
Purchase Value
Sum of totals in a given tax rate
Sum of subtotals in a given tax rate
Total tax in a given tax rate
SQL query
For macros connected with amounts in a given tax rate, there are the following tax rates available:
A (Rate A 22%)
B (Rate B 7%)
C (Rate C 0%)
D (Rate D 0%)
E (Rate E 0%)
F (Rate F 3%)
G (Rate G 6%)
Other tax rate specified by the user
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with defined scheme. Possible options are:
Subtotal Item
Total Item
Item Tax
Item Code
Item Name
Does the element refer to a merchandise?
Does the element refer to service?
Purchase Value
Acquisition Value
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Item account of given type:
Ø Warehouse
Ø Sales
Ø Prime Cost
Ø Other types defined by the user in the account types directory
SQL query
- For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible options are:
Item Code
Item Name
Document Item Description
Item Tax Rate
SQL query
In case of trade and warehouse documents, for option: Subelement, the following macros are available:
- For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. The amount is retrieved from the source document, depending on selected macro. Possible options are:
Quantity
Purchase Value
Acquisition Value
SQL query
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with defined scheme. Possible options are:
Warehouse Code
Quantity
Item Code
Purchase Value
Acquisition Value
SQL query
- For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible options are:
Warehouse Code
Quantity
Ordinal Number
Delivery Date
Delivery Document Number
Item Code
SQL query
In case of trade and warehouse documents, for option: Analytical Description, the following macros are available:
- For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible option is:
Select account from the chart of accounts
Account Number from Analytical Description
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. The amount is retrieved from the source document, depending on selected macro. Possible options are:
Amount from Analytical Description
SQL query
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with defined scheme. Possible options are:
Element Name of Analytical Dimension
SQL query
- For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible options are:
Element Name of Analytical Dimension
SQL query
In case of cash/bank transactions, for option: Header, the following macros are available:
- For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Contra Account of Transaction
Cash-Bank Register Account
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Employee account of given type
Ø Remuneration
Ø Prepayments
Ø Other types defined by the used in the account types directory
Institution account of given type
Ø Duty
Ø Income Tax
Ø VAT
Ø Other types defined by the user in the account types directory
Bank account of given type
Ø Payments
Ø Other types defined by the user in the account types directory
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. Amount is retrieved from the source document, depending on the selected macro. Possible options are:
Revenue Amount – for deposit transaction
Expense Amount – for withdrawal transaction
SQL query
The item Amount is mandatory.
4. For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with a defined scheme. Possible options are:
Currency
Revenue Amount – for deposit transaction
Expense Amount – for withdrawal transaction
Customer/Vendor Code
Expense
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Employee account of given type
Ø Remuneration
Ø Prepayments
Ø Other types defined by the used in the account types directory
Institution account of given type
Ø Duty
Ø Income Tax
Ø VAT
Ø Other types defined by the user in the account types directory
Bank account of given type
Ø Payments
Ø Other types defined by the user in the account types directory
C/B Account Code
Insert value from directory
Ø Customer/Vendor Code
Ø Currency
SQL query
5. For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible options are:
Proper Number
Reference Number
Customer/Vendor Code
Currency
Document Description
Ordinal Number
C/B Account Code
SQL query
In case of cash/bank transactions, for option: Analytical Description, the following macros are available:
1. For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Account number from analytical description
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. Amount is retrieved from the source document, depending on the selected macro. Possible options are:
Amount from analytical description
SQL query
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with a defined scheme. Possible options are:
Element name of analytical dimension
SQL query
- For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible options are:
Element name of analytical dimension
SQL query
In case of cash/bank reports, for option: Header, the following macros are available:
- For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. Amount is retrieved from the source document, depending on selected macro. Possible options are:
Report Opening Balance
Report Ending Balance
SQL query
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with a defined scheme. Possible option is:
SQL query
- For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible options are:
Reference Number
SQL query
In case of cash/bank documents, for option: Element, the following macros are available:
1. For item: Account Dr/Cr – a list of predefined macros is dropped down upon clicking on the downwards arrow. Possible options are:
Contra Account of Transaction
Cash-Bank Register Account
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Employee account of given type
Ø Remuneration
Ø Prepayments
Ø Other types defined by the used in the account types directory
Institution account of given type
Ø Duty
Ø Income Tax
Ø VAT
Ø Other types defined by the user in the account types directory
Bank account of given type
Ø Payments
Ø Other types defined by the user in the account types directory
Select account from the chart of accounts
SQL query
Checking the parameter Create Dr account/Create Cr account will automatically create an account with a number entered in the field Account Dr/Cr.
- For item: Amount – a list of predefined macros is dropped down upon clicking on the downwards arrow. Amount is retrieved from the source document, depending on selected macro. Possible options are:
Revenue Amount
Expense Amount
SQL query
The item Amount is mandatory.
- For item: Condition – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional condition which must be fulfilled by a document posted with a defined scheme. Possible options are:
Revenue Amount
Expense Amount
Customer/Vendor Code
Expense
Customer account of given type:
Ø Customer
Ø Vendor
Ø Other types defined by the user in the account types directory
Employee account of given type
Ø Remuneration
Ø Prepayments
Ø Other types defined by the used in the account types directory
Institution account of given type
Ø Duty
Ø Income Tax
Ø VAT
Ø Other types defined by the user in the account types directory
Bank account of given type
Ø Payments
Ø Other types defined by the user in the account types directory
SQL query
Insert value from directory
Ø Customer/Vendor Code
- For item: Description – a list of predefined macros is dropped down upon clicking on the downwards arrow. In this field, it is possible to enter additional description. Possible option is:
Customer/Vendor Code
SQL query
By clicking on the eraser icon: 
, all previously entered data will be cleared. This button functions as the Delete or Backspace button available on a standard keyboard.
After filling in the fields, click [Save]. Upon saving, you will automatically return to the posting scheme form.