🗄️

Master Data

Define master data to be used in the program: Companies and Materials

6 Modules

Companies

  • ✓Company Definition: Create company card as customer, supplier or both
  • ✓Company Type: Classified as Customer, Supplier or Both
  • ✓Current Account Link: Each company is automatically linked to a current account
  • ✓Tax Information: Tax office, tax number and ID information are entered

Bank Accounts

  • •Bank Accounts Tab: Managed from "Bank Accounts" tab in company card
  • •Multiple Accounts: Multiple bank accounts can be defined for a company
  • •Account Information: Bank name, branch, IBAN, currency information are entered
  • •Default Account: One account can be marked as default

Excel Bulk Company Upload

  • •Template Download: Download ready template from "Download Excel Template" in 3-dot menu on Companies page
  • •Template Content: Contains the columns Company Name (required), Address, Phone, Email, Tax No, Tax Office, Company Type (0-2, required) and Subcontractor (E/H)
  • •Bulk Upload: Select filled Excel file from "Upload from Excel" in 3-dot menu
  • •Preview: Data can be previewed in table format before upload
  • •Auto Synchronization: Current accounts are automatically created for uploaded companies
Note: Current account is automatically linked when company record is created

Company Deletion / Deactivation

  • •Deactivation: Companies are not permanently deleted, they are deactivated
  • •Data Integrity: Requests, waybills and invoices linked to company are preserved
  • •Default View: Only active companies are shown in list
  • •Status Filter: All companies can be viewed with Active/Passive filtering

Materials

Material Categories

CategoryDescriptionUsage Area
ProductFinal products ready for saleSales orders, stock tracking
Semi-finishedIntermediate products in production processBill of Materials (BOM), production planning
Raw MaterialBasic production inputsPurchasing, bill of materials
Auxiliary MaterialAuxiliary inputs used in productionPurchasing, bill of materials
ConsumablesConsumption materialsPurchasing, stock tracking
Fixed AssetFixed asset itemsPurchasing, stock tracking

Bill of Materials (BOM)

  • •Defines which components make up the product
  • •Quantity and unit are determined for each component
  • •Semi-finished components can create nested bill of materials

Product Routing (Operations)

  • •Defines production stages of product sequentially
  • •Each operation is linked to a work center and department
  • •Operation times are used in work order planning

Material-Warehouse Relationship

  • •Which warehouses each material will be stocked in is determined
  • •When new material is created, DPO-001 is automatically assigned
  • •Bulk default warehouse assignment button is available
Tip: Use "Assign Default Warehouse (DPO-001)" button for bulk assignment to all materials

Excel Bulk Material Upload

  • •Template Download: Download ready template from "Download Excel Template" in 3-dot menu on Materials page
  • •Template Content: Contains Material Code, Name, Category, Unit, Description, Unit Price fields
  • •Category Values: Product, Semi-finished, Raw Material, Auxiliary Material, Consumables, Fixed Asset
  • •Bulk Upload: Select filled Excel file from "Upload from Excel" in 3-dot menu
  • •Preview: Data can be previewed in table format before upload
  • •Auto Code: If material code is left blank, it is automatically generated

Material Deletion Operations

  • •Deactivation: Deactivates material, data is preserved
  • •Permanent Deletion: Materials without dependent records can be permanently deleted
  • •Restore: Passive materials can be reactivated
Tip: Materials with stock movements cannot be permanently deleted, only deactivated

Row Color Coding

Row colors in material list indicate different statuses:

ColorConditionMeaning
RedMaterial deletedDeleted (soft delete) material
GrayMaterial passiveInactive material
YellowStock ≤ Minimum StockLow stock warning, may need reorder
WhiteNormal statusStock level sufficient
Note: Materials with minimum stock value of 0 and stock of 0 are also shown in yellow