Production Order

This form is used to manage production order data.

Database table
mrporder
Primary Key
transid (Invoice).
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 Division will receive focus first.
Sorting order
Records are sorted by orderdate.
Print template
Update the print template for this form via General → Print Layout using Design Group = mrporderform.
List print template
Adjust the list print layout via General → Print Layout using Design Group = mrporderlist.
production order
PRODUCTION ORDER (Daftar)
production order
PRODUCTION ORDER (Form)

Additional Fields

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

  • Division
    The division input is required.. The division input can be used as a filter on the main list form..
    • Options are loaded from table division (form Division List). The default value follows the Role User form, but you can choose another item.
  • Invoice
    The invoice input is required.. The invoice input can be used as a filter on the main list form..
  • Department
    The department input is required.. The department input can be used as a filter on the main list form..
    • This field searches table departement (form Department). Open the dropdown, type a keyword, and pick the desired record.
  • Work Center
    The work center input is required.. The work center input can be used as a filter on the main list form..
    • Options are loaded from table mrpworkcenter (form Work Center). The default value follows the Role User form, but you can choose another item.
  • Order Date
    The order date input is required.. The order date input can be used as a filter on the main list form..
    • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
  • Production Start Date
    The production start date input is required.. The production start date input can be used as a filter on the main list form..
    • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
  • Expected Completion Date
    The expected completion date input is required.. The expected completion date input can be used as a filter on the main list form..
    • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
  • Deadline Date
    The deadline date input is required.. The deadline date input can be used as a filter on the main list form..
    • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.

Create Product from Sales Order

  • Create Product from Sales Order
    The create product from sales order input can be used as a filter on the main list form..
  • Sales Order
    The sales order input can be used as a filter on the main list form..
    • This field searches table salesorder (form Sales Order). Open the dropdown, type a keyword, and pick the desired record.
  • Ordered Products
    The ordered products input can be used as a filter on the main list form..
    • This field searches the SQL data source. Open the dropdown, type a keyword, and pick the desired record.
  • View Sales Invoice
    This input is read-only and only displays data from system..

Products to Be Manufactured

  • Products to Be Manufactured
    The products to be manufactured input is required.. The products to be manufactured input can be used as a filter on the main list form..
    • This field searches the SQL data source. Open the dropdown, type a keyword, and pick the desired record.
  • Name
    The name input is required.. This input is read-only and only displays data from system.. The name input can be used as a filter on the main list form..
  • Ordered Quantity
    The ordered quantity input is required.. The ordered quantity input can be used as a filter on the main list form..
    • Enter numeric values into ordered quantity.
  • Unit
    The unit input is required.. This input is read-only and only displays data from system.. The unit input can be used as a filter on the main list form..
  • Serial Number
    The serial number input can be used as a filter on the main list form..
  • Expiration Date
    The expiration date input can be used as a filter on the main list form..
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Quantity Produced
    The quantity produced input is required.. The quantity produced input can be used as a filter on the main list form..
    • Enter numeric values into quantity produced.
  • Number of Failed Products
    The number of failed products input is required.. This input is read-only and only displays data from system.. The number of failed products input can be used as a filter on the main list form..
    • This field displays number of failed products and is populated automatically.
  • Actual Completion Date
    The actual completion date input is required.. The actual completion date input can be used as a filter on the main list form..
    • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
  • Old Production COGS
    The old production cogs input is required.. This input is read-only and only displays data from system.. The old production cogs input can be used as a filter on the main list form..
    • This field displays old production cogs and is populated automatically.
  • New Production COGS
    The new production cogs input is required.. This input is read-only and only displays data from system.. The new production cogs input can be used as a filter on the main list form..
    • This field displays new production cogs and is populated automatically.
  • Calculate Production Requirements (BOM)
    This input is read-only and only displays data from system..
  • Status
    The status input is required.. This input is read-only and only displays data from system.. The status input can be used as a filter on the main list form..
    • Available options:
      • value 0, label Production Order, extra attributes: buttonlabel=Set to Ready for Production, description=Ready for production will check raw material availability and move them to the production location once ready., icon=shopping_cart, formula=_this.$AjaxGet('mrpordertoready', { data: _this.formData, ignorestock: 0 }, function (res) { if (res.status ==0) { _this.$q.dialog({ title: 'Confirmation', message: res.message, cancel: true, html: true, persistent: true }).onOk(() => { _this.$AjaxGet('mrpordertoready', { data: _this.formData, ignorestock: 1 }, function (res) { <--status--> = res.status; _this.$refs.mrpordercomponent[0].formData = res.mrpordercomponent; _this.$refs.mrpworkorder[0].formData = res.mrpworkorder; _this.$refs.mrpordercomponent[0].calcDataFooter(); _this.$refs.mrpworkorder[0].calcDataFooter(); _this.$emitter.emit('updateMRPOrder', {columns: [], formname: ''}) }); }) } else { <--status--> = res.status; _this.$refs.mrpordercomponent[0].formData = res.mrpordercomponent; _this.$refs.mrpworkorder[0].formData = res.mrpworkorder; _this.$refs.mrpordercomponent[0].calcDataFooter(); _this.$refs.mrpworkorder[0].calcDataFooter(); _this.$emitter.emit('updateMRPOrder', {columns: [], formname: ''}) } });
      • value 1, label Ready for Production, extra attributes: buttonlabel=Start Production, description=Raw materials and labor are ready. Click 'Start Production' to begin tracking production time., icon=check_box, formula=_this.$AjaxGet('mrpstartproduce', { data: _this.formData }, function (res) { if (res.status == 1) { _this.$q.notify(res.message) } else { <--status--> = res.status; } });
      • value 2, label In Production, extra attributes: buttonlabel=Complete Production, description=This product is currently in production, icon=manufacturing, formula=_this.$AjaxGet('mrpfinishproduce', { data: _this.formData }, function (res) { if (res.status == 2) { _this.$q.notify(res.message) } else { _this.isRecordChanged = true; <--status--> = res.status; _this.$refs.mrpordercomponent[0].formData = res.mrpordercomponent; _this.$refs.mrpworkorder[0].formData = res.mrpworkorder; _this.$refs.mrpordercomponent[0].calcDataFooter(); _this.$refs.mrpworkorder[0].calcDataFooter(); _this.$emitter.emit('updateMRPOrder', {columns: [], formname: ''}) } });
      • value 3, label Release Product, extra attributes: buttonlabel=Release Product, description=Completing production will issue raw materials from the production location and add finished goods to the target location. Any variance between planned and actual raw materials will be returned to or drawn from the source warehouse., icon=new_realeases, formula=_this.$AjaxGet('mrpreleaseproduct', { data: _this.formData }, function (res) { if (res.status == 3) { _this.$q.notify(res.message) } else { _this.isRecordChanged = true; <--status--> = res.status; _this.$refs.mrpworkorder[0].formData = res.mrpworkorder; _this.$refs.mrpworkorder[0].calcDataFooter(); <--newcogs--> = res.newcogs } });
      • value 4, label Done, extra attributes: buttonlabel=, description=Product has been completed, icon=done, formula=
  • Notes
    The notes input can be used as a filter on the main list form..
  • Production Components
    • Add Production Components entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Production Components.
  • Production Work Order
    • Add Production Work Order entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Production Work Order.
  • 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.

Production Components

This form is used to manage production components data.

Database table
mrpordercomponent
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 Product 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 = .
production components
PRODUCTION COMPONENTS (Daftar)
production components
PRODUCTION COMPONENTS (Form)

Additional Fields

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

  • Product
    The product input is required.. The product 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 is required.. This input is read-only and only displays data from system.. 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.
  • Unit
    This input is read-only and only displays data from system.. The unit input can be used as a filter on the main list form..
  • Serial Number
    The serial number input can be used as a filter on the main list form..
    • This field searches inventory. Open the dropdown, type a keyword, and pick the desired record.
  • Expiration Date
    The expiration date input can be used as a filter on the main list form..
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Quantity to be Used
    This input is read-only and only displays data from system.. The quantity to be used input can be used as a filter on the main list form..
    • This field displays quantity to be used and is populated automatically.
  • Actual Quantity Used
    The actual quantity used input is required.. The actual quantity used input can be used as a filter on the main list form..
    • Enter numeric values into actual quantity used.
  • Quantity Variance
    The quantity variance input is required.. This input is read-only and only displays data from system.. The quantity variance input can be used as a filter on the main list form..
    • This field displays quantity variance and is populated automatically.
  • Cost of Goods Sold (COGS)
    The cost of goods sold (cogs) input is required.. 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
    The subtotal input is required.. 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.

Production Work Order

This form is used to manage production work order data.

Database table
mrpworkorder
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 Production Operation 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 = mrpworkorderlist.
production work order
PRODUCTION WORK ORDER (Daftar)
production work order
PRODUCTION WORK ORDER (Form)

Additional Fields

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

  • Show
    This input is read-only and only displays data from system..
  • Production Operation
    The production operation input is required.. The production operation input can be used as a filter on the main list form..
    • This field searches table mrpoperation (form Production Operation List). Open the dropdown, type a keyword, and pick the desired record.
  • Ordered Quantity
    The ordered quantity input is required.. This input is read-only and only displays data from system.. The ordered quantity input can be used as a filter on the main list form..
    • This field displays ordered quantity and is populated automatically.
  • Unit
    This input is read-only and only displays data from system..
  • Quantity Produced
    The quantity produced input is required.. The quantity produced input can be used as a filter on the main list form..
    • Enter numeric values into quantity produced.
  • Number of Failed Products
    The number of failed products input is required.. This input is read-only and only displays data from system.. The number of failed products input can be used as a filter on the main list form..
    • This field displays number of failed products and is populated automatically.
  • Labor Costs
    The labor costs input can be used as a filter on the main list form..
    • Enter numeric values into labor costs.
  • Total Labor Cost
    This input is read-only and only displays data from system.. The total labor cost input can be used as a filter on the main list form..
    • This field displays total labor cost and is populated automatically.
  • Duration
    The duration input can be used as a filter on the main list form..
    • Enter numeric values into duration.
  • Time Unit
    This input is read-only and only displays data from system..
  • Total Duration
    This input is read-only and only displays data from system.. The total duration input can be used as a filter on the main list form..
    • This field displays total duration and is populated automatically.
  • Order Date
    The order date input is required.. This input is read-only and only displays data from system.. The order date input can be used as a filter on the main list form..
    • This field displays a timestamp that is populated automatically.
  • Start Date
    The start date input can be used as a filter on the main list form..
    • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
  • Expected Completion Date
    The expected completion date input is required.. This input is read-only and only displays data from system.. The expected completion date input can be used as a filter on the main list form..
    • This field displays a timestamp that is populated automatically.
  • Deadline Date
    The deadline date input is required.. This input is read-only and only displays data from system.. The deadline date input can be used as a filter on the main list form..
    • This field displays a timestamp that is populated automatically.
  • Actual Completion Date
    The actual completion date input is required.. This input is read-only and only displays data from system.. The actual completion date input can be used as a filter on the main list form..
    • This field displays a timestamp that is populated automatically.
  • Employee Assigned to Work Order
    • Add Employee Assigned to Work Order entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Employee Assigned to Work Order.
  • Status
    The status input is required.. This input is read-only and only displays data from system.. The status input can be used as a filter on the main list form..
    • Available options:
      • value 0, label Production Order, extra attributes: buttonlabel=Set to Ready for Production, description=Ready for production will check raw material availability and move them to the production location once ready., icon=shopping_cart, formula=
      • value 1, label Ready for Production, extra attributes: buttonlabel=Start Production, description=Raw materials and labor are ready. Click 'Start Production' to begin tracking production time., icon=check_box, formula=_this.$AjaxGet('workorderstart', { data: _this.formData }, function (res) { if (res.status == 1) { _this.$q.notify(res.message) } else { <--status--> = res.status; <--startdate--> = res.data.startdate; } });
      • value 2, label In Production, extra attributes: buttonlabel=Complete Production, description=This product is currently in production, icon=factory, formula=_this.$AjaxGet('workorderfinish', { data: _this.formData }, function (res) { if (res.status == 2) { _this.$q.notify(res.message) } else { <--status--> = res.status; <--realfinishdate--> = res.data.realfinishdate; } });
      • value 3, label Done, extra attributes: buttonlabel=, description=Product has been completed, icon=done, formula=
  • 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.

Employee Assigned to Work Order

This form is used to manage employee assigned to work order data.

Database table
mrpworkorderemployee
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 Employee 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 = .
employee assigned to work order
EMPLOYEE ASSIGNED TO WORK ORDER (Daftar)
employee assigned to work order
EMPLOYEE ASSIGNED TO WORK ORDER (Form)

Additional Fields

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

  • Employee Code
    The employee code input is required.. The employee code input can be used as a filter on the main list form..
    • This field searches table employee (form Employee). Open the dropdown, type a keyword, and pick the desired record.
  • Name
    The name input is required.. This input is read-only and only displays data from system.. The name input can be used as a filter on the main list form..
  • Quantity
    The quantity input is required.. The quantity input can be used as a filter on the main list form..
    • Enter numeric values into quantity.
  • Unit
    The unit input is required.. This input is read-only and only displays data from system.. The unit input can be used as a filter on the main list form..
  • 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.

English Documentation Administrator 08 Nov 2025 05:19pm