Summary

Completed

In this module, you learned how to work with documents, which involved creating two different tables, a header, and a line table. The primary keys that are defined in the header table are used in the line table as well, but an extra Line No. field in the line table helps make records unique. The Line No. field is an integer field that is incremented with 10000. To have the Line No. field incremented, set the AutoSplitKey property on the ListPart page that displays the line records.

A document page is linked to the header table and uses a part to display the lines that are linked in a ListPart page. You can use the SubPageLink property to link the two pages and to display page parts in the FactBox area. If you need to display more information about data from the line table, you can set the Provider property.

A document page uses number series, so you should also implement the No. Series Design Pattern. After initializing the number series, you need to set up other fields. This task is handled in the InitRecord function.

You also learned how to use the TestField function to test if a field contains a value and display an error if the value is blank. Finally, you were introduced to the Round function, which rounds a decimal value. By default, the Round function uses the rounding that is defined in General Ledger Setup.