Customer - Adjustments
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Select Transaction FieldsTransform FieldsY Filter DebitDebit OutputY Table inputSelect Transaction FieldsY Transform FieldsFilter DebitY Filter DebitModified Java Script ValueY Modified Java Script ValueCredit Adj OutputY
Credit Adj Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountCreditAdjust>startTimetruefalseTRANSTAT<act.customerAccountCreditAdjust>statustruefalseAMOUNT<act.customerAccountCreditAdjust>amounttruefalseTAXAMT<act.customerAccountCreditAdjust>taxtruefalseTRANSID<act.customerAccountCreditAdjust>referencetruefalseDESCRIPTION<act.customerAccountCreditAdjust>notesfalsefalseCLIENTID<act.customerAccountCreditAdjust>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountCreditAdjust>customer[0]<participation.customer>acttrue<act.customerAccountCreditAdjust>$valuefalsetruetrue1000
670
152
Y
Debit Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountDebitAdjust>startTimetruefalseTRANSTAT<act.customerAccountDebitAdjust>statustruefalseAMOUNT<act.customerAccountDebitAdjust>amounttruefalseTAXAMT<act.customerAccountDebitAdjust>taxtruefalseTRANSID<act.customerAccountDebitAdjust>referencetruefalseDESCRIPTION<act.customerAccountDebitAdjust>notesfalsefalseCLIENTID<act.customerAccountDebitAdjust>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountDebitAdjust>customer[0]<participation.customer>acttrue<act.customerAccountDebitAdjust>$valuefalsetruetrue1000
668
60
Y
Filter Debit
FilterRows
N
1
none
Debit Output
Modified Java Script Value
N
AMOUNT
>=
constantNumber0.0-1-1N
463
56
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
AMOUNT.setNumber(abs(AMOUNT.getNumber()));
537
150
Y
Select Transaction Fields
SelectValues
Y
1
none
AccountNumber
CLIENTID
-2
-2
Billing Number
TRANSID
-2
-2
Billing Date
DATE
-2
-2
Balance
AMOUNT
-2
-2
Comments
DESCRIPTION
-2
-2
214
55
Y
Table input
TableInput
Y
1
none
Quickvet
SELECT * from billing where visit = 0 and balance <> 0
0
N
N
99
55
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var TRANSTAT = "POSTED"
var TAXAMT = abs(AMOUNT.getNumber())/11;
TRANSTAT
TRANSTAT
String
-1
-1
TAXAMT
TAXAMT
Number
16
2
339
57
Y