Material Movements

Overview

In QuickEasy BOS Professional, inventory items are referred to as Materials. During the production process materials can be purchased, converted to finished goods and sold.

  • The process of receiving materials is referred to as a Materials Movement (Receive).
  • When goods are produced, there may be materials left over. It is also possible that a customer returns some goods. In both cases, these materials are returned to inventory using a Materials Movement (Return).
  • The process of issuing materials from inventory to production is referred to as a Materials Movement (Issue). Transactions can be manually created in this module or they can be created from Sales, Work and Purchase Orders.
Navigation

Main Menu > Materials > Materials Movement

Settings

User Settings

Navigation

Main Menu > Office > My Organisation > Double-click to open a Staff File > Settings (tab).

Note

The defaults are the values for new databases and new users. Your database may have different values.

Setting Description Default
Default Transactions View > Materials Movement
  • Today
  • All Pending
  • All Active
  • All Pending & Active
Today
Materials & Inventory > Material Movement - Allow editing DateYes or No.No
Materials & Inventory > Material Movement - Deleting AllowedYes or No.No
Materials & Inventory > Material Movement - Edit Status on read-only transactionsYes or No.No
Materials & Inventory > Signage View - Access AllowedYes or No.No
Materials & Inventory > Transfer Orders/Material Movement - Access AllowedYes or No.No
Copy Rules > Customer Credit Notes - Copy to Materials Movement (Receive)Yes or No.No
Copy Rules > Purchase Orders - Copy to Materials Movement (Receive)Yes or No.No
Copy Rules > Purchase Orders - Copy to Materials Movement (Return)Yes or No.No
Copy Rules > Delivery Notes - Copy to Materials Movement (Issue)Yes or No.No
Copy Rules > Sales Orders - Copy to Materials Movement (Issue)Yes or No.
  • Note: Versions before 26.05 show "Sale Order" in this caption.
No
Copy Rules > Materials Movement - Copy to Supplier InvoiceYes or No.No
Copy Rules > Supplier Debit Notes - Copy to Materials Movement (Issue)Yes or No.No
Work Orders - Copy to Materials Movement (Return Materials)Yes or No.No
Work Orders - Copy to Materials Movement (Receive Output)Yes or No.No
Work Orders - Copy to Materials Movement (Issue Materials)Yes or No.No

General Settings

Navigation

Main Menu > Setup > Settings & Defaults > Settings (tab)

Setting Description Default
Materials & Inventory > Default - Days to Materials Movement Receive (MMR) Expiry DateOption to enter an amount in the Value column.0
Materials & Inventory > Materials Movement Receive (MMR) - Set Quantity from Serial No.Yes or No.Yes

List View

Buttons Explained

Button Description
ResetResets the view and data filters. Options are: Today, All Pending, All Active, All Pending & Active.
ViewGenerates the report based on the selected data filters.
NewCreates a new Transaction. The options are:
  • Receive (MMR-PO): Create a Material Movement Receive to receive goods from a Purchase Order.
  • Receive (MMR-WO): Create a Material Movement Receive to receive finished goods from a Work Order.
  • Issue (MMI): Create a Material Movement Issue to issue goods to a customer or Work Order.
  • Return (MMT-MMI): Create a Material Movement Return to receive returned goods from a customer or unused raw materials from a Work Order.
  • Return (MMT-PO): Create a Material Movement Return to return goods to a supplier.
OutputGenerates Material Movement Statements for the selected transactions. Output Options are Print, Print (Show Dialogue), Preview, Email.
Actions
  • Batch Update Transaction View:
    • Updates the Status of the selected transactions. The options are Pending, Active, Complete and Cancelled.
  • Batch Update Items View
    • Dr Account: Lets you select an account to debit from the dropdown list.
    • Cr Account: Lets you select an account to credit from the dropdown list.
  • Update: Button to implement the selected Batch change. Only appears when the Batch Update feature is active.
  • Red Circle with Cross: Close the Batch Update interface. Only appears when the Batch Update feature is active.
Menu
  • View
    • Toggle the list between Transaction or Items.
  • Export
    • Email Excel: Opens the default email template and attaches the list in .xlsx format.
    • Export Grid: Opens a file chooser for you to choose the save location of the list in .xlsx format.
  • Layout
    • Save Grid:
      • Save Grid
      • Save Grid (All Users)
    • Restore Grid:
      • Restore Grid
      • Restore Default Grid
      • Restore Default Grid (All Users)

Filters Explained

Filter Description
SetOptions to set various date formats, including No Date to view all the transactions.
← →Adjusts the date in the direction of the arrow.
DateLets you customise the dates.
CustomerA dropdown list with all the customers.
SupplierA dropdown list with all the suppliers.
StockA checkbox in Items View that if checked only shows stock items.
Status Checkboxes
  • Checkboxes to filter the list to only include the checked Statuses:
    • Pending
    • Active
    • Complete
    • Cancelled

Fields Explained: Transaction View

Info

Fields marked in green (✎) can be edited.

Field Description
Field Chooser (*)Lets you add or remove columns.
StatusThe colour-coded Status of the transaction.
MM No.The system-generated number allocated to the Material Movement.
Cost to NCRThe Cost of a linked Non-conformance Report.
FromThe source document that was used to create the materials movement.
DateThe Date of the materials movement transaction.
ExpiryThe transaction's Expiry Date.
TypeThe Type of Material Movement.
CustomerThe name of the customer.
SupplierThe name of the supplier.
SO No.The Sales Order number if the transaction is linked to a Sales Order.
WO No.The Work Order number if the transaction is linked to a Work Order.
DN No.The Delivery Note number if the transaction is linked to a Delivery Note.
PO No.The Purchase Order number if the transaction is linked to a Purchase Order.
CC No.The Customer Credit Note number if the transaction is linked to a credit note.
SD No.The Supplier Debit Note number if the transaction is linked to a debit note.
WF No.The Workflow number.
UserThe User who created the transaction.
SM No.The Service Manager linked ticket number.
ReferenceThe user-provided reference.
ApprovalThe User who approved the transaction.
Status NoteThe note entered on the status bar.
Total (Exc)The VAT Exclusive transaction total.
FlowThe system-generated number linked to the transaction.
Updated byThe User who last changed the transaction.
UpdatedThe Date and Time of the last update.
Menu (...)
  • View Job Summary: Opens a costing summary for the job. The first tab shows the Profit or Loss, with expected and actual columns. The second tab shows the Timekeeping records allocated to the job.
  • View linked Transactions: Opens a list of linked transactions on the right.
  • View SM Responses: Opens a list of Service Manager responses related to the job.
  • Copy to Supplier Invoice: Creates and prefills a Supplier Invoice.
  • Copy to Materials Movement (Return): Creates and prefills a Material Movements Return.
  • Edit: Opens the transaction for you to edit it.
  • Delete: Deletes the transaction.

Fields Explained: Items View

Field Description
Field Chooser (*)Lets you add or remove columns.
StatusThe colour-coded status of the transaction.
MM No.The system-generated number allocated to the Material Movement.
TypeThe type of Material Movement.
CustomerThe name of the customer.
SupplierThe name of the supplier.
FromThe source document that was used to create the Materials Movement.
SO No.The Sales Order number if the transaction is linked to a Sales Order.
WO No.The Work Order number if the transaction is linked to a Work Order.
DN No.The Delivery Note number if the transaction is linked to a Delivery Note.
PO No.The Purchase Order number if the transaction is linked to a Purchase Order.
DateThe transaction's date.
CPN No.The Campaign number.
ReferenceThe user-provided reference.
Created byThe name of the User who created the transaction.
Item No.The system-generated number allocated to the line item.
ItemIDThe system-generated number allocated to the transaction item.
DescriptionThe material's description.
Fixed PriceThe material's Fixed Price.
CodeThe material's code.
CategoryThe material's category.
SubcategoryThe material's subcategory.
FromThe source document's number that the item was copied from.
Customer (Item)The Customer account that the item is linked to.
TrackingThe material's Tracking Number.
LocationThe source Location of the material.
QtyThe Quantity being moved.
UnitA description of the Unit.
Unit PriceThe material's Unit Price.
Total (Exc)The VAT Exclusive transaction total.
/UnitThe Cost per Unit.
/The number of items to which the cost price relates to.
In StockThe Quantity in stock.
Menu (...)
  • Edit: Opens the transaction for you to edit it.
  • View Material Summary: Opens a summary of all the material's information and transactions on the right.
  • Open linked Material Item: Opens the material's setup view.

Edit View

Buttons Explained: Header

Button Description
∧ ∨Arrow keys to navigate through the transactions.
StatusLets you change the transaction's Status.
LinksA shortcut to all linked documents. If no documents are linked, only the current transaction's number appears.
OutputOptions to Print, Print (Show Dialogue), Preview or Email the document.
NewCreates a new transaction. The options are:
  • Receive (MMR-PO): Create a Material Movement Receive to receive goods from a Purchase Order.
  • Receive (MMR-WO): Create a Material Movement Receive to receive finished goods from a Work Order.
  • Issue (MMI): Create a Material Movement Issue to issue goods to a customer or Work Order.
  • Return (MMT-MMI): Create a Material Movement Return to receive returned goods from a customer or unused raw materials from a Work Order.
  • Return (MMT-PO): Create a Material Movement Return to return goods to a supplier.
SaveSaves any changes to the current transaction.
Actions
  • Materials Movement Receive:
    • Copy to Supplier Invoice: Creates and prefills a Supplier Invoice.
    • Copy to Materials Movement (Return): Creates and prefills a Material Movements Return.
    • Update the From Transaction: Option to change the source document that was used to create the transaction. You are warned that this breaks the links to downstream transactions (transactions copied from this one), and must click Yes to continue.
  • Materials Movement Return:
    • Copy to Supplier Invoice: Creates and prefills a Supplier Invoice.
    • Update the From Transaction: Option to change the source document that was used to create the transaction. You are warned that this breaks the links to downstream transactions (transactions copied from this one), and must click Yes to continue.
  • Materials Movement Issue:
    • Copy to Materials Movement (Return): Creates and prefills a Material Movements Return.
    • Update the From Transaction: Option to change the source document that was used to create the transaction. You are warned that this breaks the links to downstream transactions (transactions copied from this one), and must click Yes to continue.
Menu
  • Links to view information. Options are:
    • View Job Summary: Opens a costing summary for the job. The first tab shows the Profit or Loss, with expected and actual columns. The second tab shows the Timekeeping records allocated to the job.
    • View linked Transactions: Displays a list of linked transactions.
    • View SM Responses: Displays the Service Manager responses.
    • View Audits: Displays the usernames, dates and times of changes.
  • Delete Materials Movement: If the transaction is still Pending.
  • Show Item Notes: Displays any notes linked to the item.
  • Save Grid:
    • Save Grid
    • Save Grid (All Users)
  • Restore Grid:
    • Restore Grid
    • Restore Default Grid
    • Restore Default Grid (All Users)
Info (i)Information about the transaction, including an audit trail.

Buttons Explained: Items

Info

Items can be added from unlinked documents by entering the numbers in the search block on the popup. The links to these documents do not appear in the Links button.

Button Description
CustomAdds a line for you to enter a code to manually create a materials movement transaction.
Material
  • Button: Add materials from the Materials module.
  • Arrow on the button > Update selected item: If changes were made to the source transaction, this command can update the item to match those changes (or to revert changes made).
D/Note
  • Materials Movement Receive: Unavailable.
  • Materials Movement Issue: Opens a list of outstanding Delivery Notes for you to select one.
  • Materials Movement Return: Opens a list of outstanding Delivery Notes for you to select one.
P/Order
  • Materials Movement Receive (PO): Opens a list of outstanding Purchase Orders for you to select one.
  • Materials Movement Issue: Unavailable.
  • Materials Movement Return: Unavailable.
S/Order
  • Materials Movement Receive: Unavailable.
  • Materials Movement Issue: Opens a list of outstanding Sales Orders for you to select one.
  • Materials Movement Return: Opens a list of outstanding Sales Orders for you to select one.
W/Order
  • Materials Movement Receive (WO): Opens a list of outstanding Work Orders for you to select one.
  • Materials Movement Issue: Opens a list of outstanding Work Orders for you to select one.
  • Materials Movement Return: Opens a list of outstanding Work Orders for you to select one.

Fields Explained

Field Description
Status BarDisplays the current status of the transaction and provides a field to enter a note.
MM No.The system-generated number allocated to the transaction.
DateSelect a date.
TypeThe type of transaction.
CustomerA dropdown list from which to select a customer.
SupplierA dropdown list from which to select a supplier.
Reference & Note
  • Enter a reference.
  • Enter a note.

Items

Info

Fields marked in green (✎) can be edited.

Field Description
Field Chooser (*)Lets you add or remove columns.
IDA system-generated number for the transaction.
ItemA system-generated number for the line item.
DescriptionThe material's description.
CodeThe material's code.
CustomerThe customer linked to the transaction.
CategoryThe material's category.
SubcategoryThe material's subcategory.
FromThe source document used to create the Material Movement.
LocationThe material's source location.
TrackingThe material's tracking number.
Unit (Editable)The line item's unit. This field is editable if the transaction is still editable. This field is hidden by default.
In StockThe current quantity of the material that is in stock.
Unit (Lookup)The line item's unit. This field cannot be edited. This field appears by default.
QtyThe Quantity of materials being moved in this transaction.
Fixed PriceThe material's Fixed Price.
Unit PriceThe material's Unit Price.
/The Quantity of the material that is included in the Unit Price.
TotalThe Total Value of the stock (Qty x Unit Price) + Fixed Price = Total.
/UnitThe Cost per Unit (Total / Quantity).
Menu (...)Submenu to:
  • Delete Item: Only applicable to Pending transactions. Deletes the line item.
  • Convert Fixed Price to Unit Price: Divides the Fixed Price by the Quantity to convert the Fixed Price to a unit price. Only available if the Fixed Price is filled in and the Unit Price is zero.
  • View/Edit Note: Opens any notes attached the material to view or edit them.
  • View/Edit Tracking: If tracking is enabled, opens the tracking information.
  • Open linked Material Item: Opens the material setup interface for the material.
  • View Material Summary: Opens a summary of the material.
  • View Detailed Inventory Register: Opens a Detailed Inventory Register.
  • Move Up: Only applicable to Pending transactions. Re-arranges the line items (moves the selected line higher).
  • Move Down: Only applicable to Pending transactions. Re-arranges the line items (moves the selected line lower).

Tracking Batches and Serial Numbers

  • The Items grid has a Tracking field that you can use to record the Batch and Serial Numbers by adding them manually or by using a barcode scanner.
  • To open the tracking dialogue, right-click an Item and select View/Edit Tracking (Ctrl + T).
  • Use the Batch Tracking Report to search for tracking numbers and open the linked Receive and Issue transactions.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.