Construction Base extends the standard Business Central Item master data area with the data and actions needed for construction and project business: visibility of inventory held on jobs, industry classification of item categories, convenient display of item attribute values, and project references carried through item journal lines and item ledger entries.
Item
The standard table Item is extended with the following field.
Below you will find the description of the added field.
Field
Description
Inventory on Job
Read-only field that totals the remaining quantity of positive purchase item ledger entries for this item that are assigned to a job, taking the standard dimension, location, drop shipment, variant and date filters into account. Shows how much of the item's inventory is currently held on job sites rather than in a regular warehouse.
Note
A key on "Item Category Code" is also added to the Item table to improve the performance of lookups and reports that group items by item category.
Item List
On the standard Item List page, Construction Base adds the following action to the Functions group.
Update Costs
Recalculates the item costs for the selected items.
Item Category
The standard table Item Category, and the corresponding Item Categories page, are extended with the following field.
Below you will find the description of the added field.
Field
Description
Dimension Value
Links the item category to a dimension value of the dimension defined as "Industry Group Dimension" in the Marketing Setup, see Setup Extensions. The lookup is restricted to values of that dimension, and a blocked dimension value cannot be selected.
Note
On the Item Categories page, this field is shown after the "Description" field.
Item Attribute Value Mapping
The standard table Item Attribute Value Mapping is extended with the following read-only fields, which make the attribute name and its value available as plain text wherever the mapping is used, for example in reports and lookups.
Below you will find the description of the added fields.
Field
Description
Attribute Name
Name of the related item attribute.
Value as Text
Value of the related item attribute, shown as text.
Item Journal Line
The standard table Item Journal Line is extended with the following fields.
Below you will find the description of the added fields.
Field
Description
Sales Boq Order No.
Reference to the bill-of-quantities (BoQ) sales order that this journal line relates to.
Demand Requisition No.
Reference to the demand requisition that this journal line relates to.
Item Ledger Entry
The standard table Item Ledger Entry is extended with the same two fields as the Item Journal Line, so that the references are retained on the posted entry.
Below you will find the description of the added fields.
Field
Description
Sales Boq Order No.
Reference to the bill-of-quantities (BoQ) sales order the entry originates from.
Demand Requisition No.
Reference to the demand requisition the entry originates from.
Note
Two additional keys are added to the Item Ledger Entry table to improve performance: one sorted by item and open status, and one sorted by job, item and location (with a running total of the quantity) which is used, among others, for the "Inventory on Job" field on the Item table described above.
Related information
Setup, Setup Extensions (Megabau, Marketing, Purchases & Payables) Construction Base adds configuration options to several setup areas: the Megabau Setup from MEGABAU 365, and the standard Business Central Marketing Setup, Purchases & Payables Setup, Email Scenarios and Companies...
Item
