Purpose
This FAQ explains how the system determines the color display for the receivable section based on specific field conditions. It helps users understand why certain records appear in yellow, green, blue, red or no color.
What is this color logic used for?
The logic determines the color of the "Actual Revenue" field in a table based on payment and accounting status. This visual cue helps users quickly assess the payment status of records.
Color Coding Conditions for Actual Revenue Display
| Condition | Color |
|---|---|
accountInterface = 'Y' AND recPostDate is not empty AND recAccDate is empty AND paymentStatus ≠ 'Fully Paid' AND paymentStatus ≠ 'Partially Paid' | Yellow |
accountInterface = 'Y' AND recPostDate is not empty AND recAccDate is empty AND paymentStatus = 'Partially Paid' | Red |
accountInterface = 'Y' AND recPostDate is not empty AND recAccDate is not empty AND paymentStatus ≠ 'Fully Paid' AND paymentStatus ≠ 'Partially Paid' | Green |
accountInterface = 'Y' AND recPostDate is not empty AND recAccDate is not empty AND paymentStatus = 'Partially Paid' | Red |
accountInterface = 'Y' AND recPostDate is not empty AND recAccDate is not empty AND paymentStatus = 'Fully Paid' | Blue |
accountInterface = 'Y' AND recPostDate is empty AND recAccDate is empty AND paymentStatus = 'Partially Paid' | Red |
accountInterface = 'Y' AND recPostDate is empty AND recAccDate is empty AND paymentStatus ≠ 'Partially Paid' AND ≠ 'Fully Paid' | No color |
accountInterface = 'Y' AND recPostDate is not empty AND recAccDate is empty AND paymentStatus = 'Fully Paid' AND serviceOrder.job ∈ systemDefaultmiscVl AND receivedAmount ≠ 0 | Yellow |
Any other case under accountInterface = 'Y', and paymentStatus = 'Partially Paid' | Red |
Any other case under accountInterface = 'Y', and paymentStatus ≠ 'Partially Paid' | No color |
accountInterface ≠ 'Y' AND paymentStatus = 'Partially Paid' | Red |
accountInterface ≠ 'Y' AND paymentStatus ≠ 'Partially Paid' AND recPostDate is not empty AND recAccDate is empty AND paymentStatus = 'Fully Paid' AND serviceOrder.job ∈ systemDefaultmiscVl AND receivedAmount ≠ 0 | Yellow |
accountInterface ≠ 'Y' AND paymentStatus ≠ 'Partially Paid' in any other situation | No color |