TravelDocs: Validating line item grid data

In the TravelDocs application, you add validations to the Other Charges page to confirm that the calculations on them are correct.

About this task

The grid on the Other Charges page includes calculated fields.

  • The first Total field represents the Quantity that is multiplied by the Unit Cost.
  • The second Total field represents the sum of all the line item totals.
  • Validating the line item totals
    Due to the way Datacap processes line item grids, you cannot attach calculations to line item objects. Instead, what you can do is create a field for calculation purposes.
  • Validating the grid total
    This validation ensures that the grid total (Other_Charges_Total) equals the sum of the line item totals (Total)
  • Running a batch through the workflow
    The Other Charges page includes calculation errors to trigger validation failures. When you run the batch through the workflow, you can see the validation failures.
Parent topic: Handling line item grids