Product Group

This form is used to manage product group data.

Application menu: Product → Product Group
Database table: productgroup
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Code will receive focus first.
Sorting order: Records are sorted by Code.
List print template: Adjust the list print layout via General → Print Layout using Design Group = productgrouplist.

PRODUCT GROUP (Daftar)

PRODUCT GROUP (Form)

General

The general section contains several inputs that end users can populate:

Code
The code input is required.. The code input can be used as a filter on the main list form..
Name
The name input is required.. The name input can be used as a filter on the main list form..

Posting Account

The posting account section contains several inputs that end users can populate:

Inventory
The inventory input is required.. The inventory input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.
Input VAT
The input vat input is required.. The input vat input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.
Output VAT
The output vat input is required.. The output vat input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.
Cost of Goods Sold (COGS)
The cost of goods sold (cogs) input is required.. The cost of goods sold (cogs) input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.
Sales
The sales input is required.. The sales input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.
Sales Discount
The sales discount input is required.. The sales discount input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.
Sales Return
The sales return input is required.. The sales return input can be used as a filter on the main list form..
- This field searches table account (form Chart of Accounts). Open the dropdown, type a keyword, and pick the desired record.

Rules

The rules section contains several inputs that end users can populate:

Sales Discount
The sales discount input can be used as a filter on the main list form..
- Options are loaded from table salesdiscrules (form Sales Discount Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
Sales Commission
The sales commission input can be used as a filter on the main list form..
- Options are loaded from table salesmancommrules (form Sales Commission Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
Reward
The reward input can be used as a filter on the main list form..
- Options are loaded from table salesproductrewardrules (form Gift Reward Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
Points
The points input can be used as a filter on the main list form..
- Options are loaded from table salespointrewardrules (form Point Reward Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
servicedoercommision
The servicedoercommision input can be used as a filter on the main list form..
- Options are loaded from table servicedoercommrules (form Service Staff Commission Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.

Others

The others section contains several inputs that end users can populate:

Created By
This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
- This field shows the user code that created the record and is filled automatically.
Modified By
This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
- This field shows the user code that last modified the record and is filled automatically.
Last Modified
This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
- This field displays a timestamp that is populated automatically.

Additional Fields

The additional fields section contains several inputs that end users can populate:

Product
- Add Product entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Product.

Product

This form is used to manage product data.

Application menu: Product → Product List
Database table: product
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Code will receive focus first.
Sorting order: Records are sorted by Code.
List print template: Adjust the list print layout via General → Print Layout using Design Group = productlist.

PRODUCT (Daftar)

PRODUCT (Form)

General

The general section contains several inputs that end users can populate:

Code
The code input is required.. The code input can be used as a filter on the main list form..
Alias Code
The alias code input can be used as a filter on the main list form..
Name
The name input is required.. The name input can be used as a filter on the main list form..
Product Group
The product group input is required.. The product group input can be used as a filter on the main list form..
- This field searches table productgroup (form Product Group). Open the dropdown, type a keyword, and pick the desired record.
Supplier
The supplier input is required..
- This field searches table supplier (form Supplier). Open the dropdown, type a keyword, and pick the desired record.
Tax Type
The tax type input is required..
- Options are loaded from table taxes (form Tax List). The default value follows the Role User form, but you can choose another item.
Category
The category input is required.. The category input can be used as a filter on the main list form..
- Select one of the available options.
- Available options:
  - Inventory
  - Service
  - Package
Active
The active input can be used as a filter on the main list form..
Product Bundle
- Add Product Bundle entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Product Bundle.
Unit
- Add Product Unit entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Unit.

Rules

The rules section contains several inputs that end users can populate:

Sales Discount
The sales discount input can be used as a filter on the main list form..
- Options are loaded from table salesdiscrules (form Sales Discount Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
Sales Commission
The sales commission input can be used as a filter on the main list form..
- Options are loaded from table salesmancommrules (form Sales Commission Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
Reward
The reward input can be used as a filter on the main list form..
- Options are loaded from table salesproductrewardrules (form Gift Reward Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
Points
The points input can be used as a filter on the main list form..
- Options are loaded from table salespointrewardrules (form Point Reward Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.
servicedoercommision
The servicedoercommision input can be used as a filter on the main list form..
- Options are loaded from table servicedoercommrules (form Service Staff Commission Rules). The default value follows the Role User form, but you can choose another item. You may select more than one option.

Inventory Management

The inventory management section contains several inputs that end users can populate:

Use product serial number
The use product serial number input can be used as a filter on the main list form..
Minimum
The minimum input can be used as a filter on the main list form..
- Enter numeric values into minimum.
Maximum
The maximum input can be used as a filter on the main list form..
- Enter numeric values into maximum.
Min. Reorder
The min. reorder input can be used as a filter on the main list form..
- Enter numeric values into min. reorder.
Default Reorder
The default reorder input can be used as a filter on the main list form..
- Enter numeric values into default reorder.
Width
The width input can be used as a filter on the main list form..
- Enter numeric values into width.
Height
The height input can be used as a filter on the main list form..
- Enter numeric values into height.
Length
The length input can be used as a filter on the main list form..
- Enter numeric values into length.
Weight
The weight input can be used as a filter on the main list form..
- Enter numeric values into weight.

Bill of Materials (BOM)

The bill of materials (bom) section contains several inputs that end users can populate:

BOM Components
- Add BOM Components entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in BOM Components.
Production Operation List
- Add Production Operation List entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Production Operation List.

Others

The others section contains several inputs that end users can populate:

Description
Factory
The factory input is required.. The factory input can be used as a filter on the main list form..
- This field searches table factories (form Factory List). Open the dropdown, type a keyword, and pick the desired record.
Brand
The brand input is required.. The brand input can be used as a filter on the main list form..
- This field searches table productbrand (form Product Brand List). Open the dropdown, type a keyword, and pick the desired record.
Author
The author input is required.. The author input can be used as a filter on the main list form..
- This field searches table authors (form Author List). Open the dropdown, type a keyword, and pick the desired record.
Image
- Use this field to add, replace, or delete an image/photo. Images may come from local files, pasted URLs, or the device camera. After the preview appears you can resize or adjust it, then click [Upload image to server] to upload before closing the dialog.
- Allowed formats: .jpg, .jpeg, .png, .webp · Target size: 200px × 200px · Uploaded files will be converted to jpeg.
Created By
This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
- This field shows the user code that created the record and is filled automatically.
Modified By
This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
- This field shows the user code that last modified the record and is filled automatically.
Last Modified
This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
- This field displays a timestamp that is populated automatically.

Product Bundle

This form is used to manage product bundle data.

Database table: productpackage
Primary Key: transid (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Product Code will receive focus first.
Sorting order: Records are sorted by Invoice.
List print template: Adjust the list print layout via General → Print Layout using Design Group = .

PRODUCT BUNDLE (Daftar)

PRODUCT BUNDLE (Form)

Additional Fields

The additional fields section contains several inputs that end users can populate:

Product Code
The product code input is required.. The product code input can be used as a filter on the main list form..
- This field searches table product (form Product). Open the dropdown, type a keyword, and pick the desired record.
Name
The name input can be used as a filter on the main list form..
Quantity
The quantity input can be used as a filter on the main list form..
- Enter numeric values into quantity.
Cost of Goods Sold (COGS)
This input is read-only and only displays data from system.. The cost of goods sold (cogs) input can be used as a filter on the main list form..
- This field displays cost of goods sold (cogs) and is populated automatically.
Subtotal
This input is read-only and only displays data from system.. The subtotal input can be used as a filter on the main list form..
- This field displays subtotal and is populated automatically.
Created By
This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
- This field shows the user code that created the record and is filled automatically.
Modified By
This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
- This field shows the user code that last modified the record and is filled automatically.
Last Modified
This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
- This field displays a timestamp that is populated automatically.