You can define your own calculations or text to output:
Discuss in forum
Multiple line VBScript formulas such as ‘if’ statements can be used. For example, using the statement below you can extract all accounts and label each as either Profit & Loss or Balance Sheet:
If {CA\Account Code} >=”10000” then

      Result  = “Profit & Loss”

Else 
      Result = “Balance Sheet”
End If
Create a Data Fill definition like shown below and press  User Defined Output:

In the User Defined Output window enter the information as shown below:

The Excel output:

You can see here now that the Remaining Credit column has been added (which is the name you gave the User Defined Output) and the Remaining Credit values have been calculated for each debtor code.

Let’s now create a Data Fill that will only output records where the debtor is over their credit limit. All debtors under their credit limit will not be extracted at all. Using the Function Launcher run saved Data Fill.

Click the User Defined Output button and enter the information as it is shown below:

Here you can see that “Exceeded Limit” has been added to the Output window.
Discuss in forum

Comments

Only registered users can write comments.
Please login or register.