R2 Core
R2 Core
Breadcrumbs

LOC Billing Orders – Posted Amount Validations

This feature introduces validation checks for LOC billing orders to prevent generating incorrect invoices when discounts are modified after posting.
It ensures consistency between order and invoice values by validating discount integrity before allowing further invoice generation.

Example:

  1. Create an order with 10% header discount in the Subtotal tab.

  2. Add the item (1 qty × 10,000 each).

    • After discount → Order amount = 9,000.

  3. Set Pay-At as Periodic Billing with LOC ALL billing terms.

  4. Generate and post the invoice for 9,000.

image-20251008-073525.png
Figure 1.0: Order created and posted invoice

  1. Change the header discount from 10% to 5%.

  2. Generate the invoice again.

    • The system stops invoice generation and displays a validation error since the discount is changed.

    • Also, during payment schedule generation, if order has line amounts lower than their posted amounts, the system throws error.

image-20251008-073616.png
Figure 1.1: Invoice generation failed

Validations

The following two validations are enforced for LOC billing orders during invoice generation:

  1. Net Discounted Amount Validation

  • System checks whether the line total after discount (Amount column) is less than the posted net discounted amount (Net Posted Amount column) — the value used in the previously posted invoice.

  • If violated, invoice generation is stopped.

image-20251008-073654.png
Figure 1.2: Net Discounted Amount Validation

The system ensures that the posted discount amount remains the minimum allowable discount for that order line.

  1. Net Discount Amount Validation

  • System checks whether the current net discount amount (absolute discount applied) is less than the posted net discount amount (value from previously posted invoice).

  • If violated, invoice generation is stopped.


Visual Indications

When a validation fails:

  • A clear error message is displayed, indicating the discount inconsistency.

image-20251008-073915.png
Figure 1.3: Indictors after invoice generation failed.

  • Affected order line amount is highlighted in yellow. Click on it to view the details.

image-20251008-074003.png
Figure 1.4: Indicator on line amount

  • A yellow bulb icon appears near the Order Total; hover over it to view the reason.

image-20251008-074031.png
Figure 1.5: Indictor on order total

Applicability

  • These validations apply to all types of discount modifications, including:
    a) Changing header-level discount
    b) Changing line-level discount
    c) Changing flat discount
    d) Marking an item line as Non-Discountable
    e) Changing subtotal or section total discounts

  • Main and Sub Orders:
    These validations work the same for both Main and Sub Orders.
    If any Main or Sub Order has line amounts below their posted amounts, during payment schedule generation, the system displays a message listing all affected orders where the line totals fall below posted values.

image-20251008-075739.png
Figure 1.6: Payment generation failed

When the order value legitimately increases (e.g., due to duration or price changes), the system automatically generates an additional invoice for the difference amount.