Open Object Designer and select Table in the list of object types. Click New. Table designer will open.

Each table field must have a number, a name, and a data type. Number 1 is already assign automatically. In the Field Name field enter No. and choose Code as Data Type. Finally, enter 20 in Length. This will create a Code[20] field.

Move to the next empty line. Field No. will automatically increment. Enter CA Code in Field Name, Code in Data Type, and 20 in Length.

Create other fields as given in the following table:

Open table 50010 Item Certificate in object designer. Click C/AL Code in the View menu or press F9 to open table code. Open C/AL Globals and create two functions, DeleteCertificateActions and UpdateItemOnActions.

Position cursor in the DeleteCertificateActions variable and declare a local record variable ItemCertificateAction:

This is a simple function with lines of code in it:

        ItemCertificateAction.SETRANGE("Certificate No.","No."); 
        ItemCertificateAction.DELETEALL; 

Move to the function UpdateItemOnActions. Declare a local...

In the object designer, select Page in the object types list and Click on New -- this action button will open the page designer.

In the Table field of the page wizard, select table 50010 Item Certificate as the source table for the page, or just enter its name or ID manually.

Chose Create a page using wizard option and select Card in the list of page types. Click OK:

Next step in the wizard will suggest you to create FastTabs on the page. Leave one tab named General, as per the default setup, then click Next.

In the next step, we select table fields that will be presented...

Create a new page in object designer.

Set table 50012 Item Certificate Action as a source table for the new page.

Choose the Create a page using a wizard option and select the ListPart page type.

Select the following fields to be presented in the page:

Finish and save as page 50012 Item Certificate Subform.

Design the page 50010 Item Certificate Card and add a line below the last field:

Open the page 50010 Item Certificate Card in page designer. Declare a global variable ExpirationDate of the Date type.

Insert a new field in the General group, just below the field Issued Date. Set SourceExpr = ExpirationDate to make the ExpirationDate variable as the data source for the new field.

Open the C/AL Code page. Declare a function GetCertificateExpirationDate.

Open function parameters and add one parameter:

Create a new page in page designer.

Select the table 50010 Item Certificate as a source for the page. Choose Create a page using a wizard option and select the page type CardPart.

Add fields to the page:

The FactBox page must display the certificate expiration date the same way as it is shown in the Item Certificate Card page. In the next recipe we will see how to reuse the function we already have in page 50010. For now, let's copy the function to the new page.

Declare two global variables: ExpirationDate of type Date and IsCertificateOverdue of type Boolean.

Close variable declarations...

Create a new codeunit in object designer. Save it as codeunit 50010 Item Certificate Mgt.

Declare a global function GetCertificateExpirationDate.

Select the function in C/AL Globals list and open its properties. By default, property Local is set to Yes. Change it to No to make the function accessible from other objects.

Open function parameters in C/AL Locals and declare one parameter:

Still in C/AL Locals, add a local variable to the function:

Change the function...

Edit the codeunit 50010 Item Certificate Mgt. and declare a global function CollectProlongedNotRevokedCertificates. To allow the function to be called from other...

Create a table with the following fields:

Select field 2 Certificates - Total and change its CalcFormula property to...

In the application menu, open /Departments/Administration/Application Setup/RoleTailored Client/Profiles, or type Profiles in the Search field and select the Profiles page in the search results.

In the Profiles page, click New to create a new user profile.

Enter profile ID. Name CERT MANAGER and Certification Manager in the Description.

Click...

In the first step, we will add a field to the Item table that will specify if an item certificate is required to post an item entry. Open the table 27 Item in table designer and insert the field:

Save the modification in the table. Switch to the page designer and open the page 30 Item Card. Insert the field Certificate Required in...

In the list of keys, move to the empty line below the primary key No. and click the assist button on the right.

Open table 50010 Item Certificate in object designer and click View | Keys.

In the Fields List window, add two fields to the index:

Click OK, then close key's list and save the table:

Open table 5802 Value Entry in table designer, go to key's definition.

Add a key containing two fields: Item No. and Certificate No..

Certificate No. is a custom field added in the recipe Creating Custom Tables.

Click the assist button in the SumIndexFields field and add two...

Create a Query object in object designer.

Insert a data item with the Customer table as data source.

Include two columns from the Customer table: No. and Name.

Add another data item Customer Discount Group.

Include two fields from the Discount group: Code and Description:

Open the properties for customer discount group data item and choose SQL Advanced Options in the DataItemLinkType property.

The new property, SQLJoinType will become available. Select FullOuterJoin.

Open link editor in the DataItemLink property and configure the link...