webfocus-arvid

The General Ledger transaction dollar amount can be adjusted or represented as a positive number or negative number using the following rules.

These rules are based on the Accounting Line Debit/Credit code and also the Object Type code:

Object Type Codes: CH – Cash Not Revenue; FB – Fund Balance; IC – Revenue Not Cash; IN – Revenue Cash; LI – Liability; TI – Transfer of Funds Revenue

Object Type Codes other than the ones listed above: AS – Asset; EE – Expenditure not Expense; ES – Expense not Expenditure; EX – Expense Expenditure; TE – Transfer of Funds Expense

Rules to determine if amount is positive or negative:

If Debit/Credit code = ‘C’ and the Object Type Code is NOT one of these (‘CH’,’FB’,’IC’,’IN’,’LI’,’TI’) then multiple the Amount by -1 (negate the value in the txn)
Otherwise (object type code is one of (‘CH’,’FB’,’IC’,’IN’,’LI’,’TI’) ) use the Amount as is.

If Debit/Credit code = ‘D’ and the Object Type Code IS one of these (‘CH’,’FB’,’IC’,’IN’,’LI’,’TI’) then multiple the Amount by -1 (negate the value in the txn)
Otherwise (object type code is something other than (‘CH’,’FB’,’IC’,’IN’,’LI’,’TI’) ) then use the Amount as is.

If there is no value for Debit/Credit code then use the Amount as is.

ARVID – The ARVID views in ODS do not use the rules above. ARVID simply uses the DEBIT/CREDIT code. If the Code = ‘C’ then the amount is multiplied by -1 (negated or sign is flipped) and if the Code = ‘D’ the amount is not negated or flipped.