Transactions Edit View Interface
In BOS, transactions (e.g. Customer Invoices, Quotations, Supplier Invoices) have two interfaces. The first lists the transaction with details such as the Status, Date, Customer, or Supplier, and the transaction amounts. This is known as the List View. List View is further divided into two views: Items which lists every item on the transaction and Transactions which only lists the transaction totals. The second, known as Edit View, is where transactions are captured.
A transaction type must be added to a menu before transactions can be entered. Transaction types can be added to any menu. User access is set per transaction type.
This page explains how to create and edit transactions (Edit View). The included fields are determined by the Transaction Type’s settings.
Buttons Explained
| Button | Description |
|---|---|
| Navigational Arrows | Navigates to the next or previous entry. |
| Recent | A dropdown list of recently viewed records for quick access to those records. The button is supressed if there are no recent items. |
| Output | Prints, previews, or exports the selected report if Output Templates are added. Provides for list reports to be exported in .xlsx format in List Views. |
| Links | A dropdown list with the Abbreviation and Number of documents in the same transaction flow for quick-access to those documents. |
| New | Creates a new transaction. |
| Save | Saves any changes. |
| Actions | See Actions Button Explained below. |
| Menu | See Menu Button Explained below. |
Actions Button Explained
- Actions (button) provide for further processing, deleting, or copying of the transactions.
- The available options differ per transaction and depend on the Copy Rules.
- Actions allow static records to be edited (e.g. Customer, Supplier, or Contact). These modules have limited functionality when opened from a transaction.
- The transaction can be linked to a Service Ticket from Actions.
Non-Conformance Reports
- When a transaction is linked to a non-conformance report (NCR) as the Problem transaction the following functions are added:
- Create NCR (Problem): Creates a new NCR and links the current transaction as the problem transaction.
- Link to NCR (Problem): Links the current transaction as the problem transaction to an existing NCR. (Warnings apply)
- Terminology used:
- Problem: Refers to the original transaction that was queried.
- Remake: Refers to a work order that is created to remake part or all of the items.
- Rework: Refers to products that are faulty but can be fixed. They are reworked.
Batch Updates
Where applicable the following changes can be made to all the selected items:
- Adj %: Changes the adjustment percentage to the one typed in the adjacent block.
- Fix: Checkbox.
- If checked both the fixed and unit prices can be edited, and they override the mark-up percentage (MU%) which is calculated based on the entered prices.
- If unchecked, the MU% is applied to the cost price to determine both the fixed and unit prices. The MU% overrides any entered prices and the prices are adjusted to reflect the MU%.
- Changes made to the transaction automatically adjust this checkbox: If a price is entered the checkbox is checked. If a MU% is entered, the checkbox is unchecked.
- Group: Allows a group name to be inserted. Group names are transaction specific.
- MU%: Changes the markup percentage to the one typed in the adjacent block. Automatically unchecks the Fix checkbox.
- Status: Changes the item’s status to the one selected from the dropdown list.
- Transaction Calendar: (Transaction Calendar is the name of the Calendar Type). Allows the calendar resource to be changed.
- Calendar Start: (Calendar Start is a custom description). Changes the calendar’s start date and time.
- Calendar End: (Calendar End is a custom description). Changes the calendar’s end date and time.
Example:
- Batch Update
- Show Notes
- Order by Group
- Link to Service
- Delete Transaction
- NCR
- Create Accounts Procedure (Problem) (where Accounts Procedure is the name of a Service Type)
- Create Non-Conformance Reports (NCR) (Problem) (where Non-Conformance Reports is the name of the Service Type created for NCRs)
- Link to NCR (Problem)
- Unlink NCR (Problem)
- Copy Transaction
- Copy to Customer Invoice
- Copy to Goods Issued
- Contact
- Add Customer
- Edit Customer
- Edit Contact
Menu Button Explained
The options available under menu options depend on which features are activated.
An example without production:
- Open Calendar
- Open Linked Asset
- View / Edit Notes & Attachments
- View / Edit Followers
- View Accounting Report
- View Inventory Report
- Settings
- Edit Accounting (VAT Types, Currencies, Credit Terms, Accounts)
- Layout
An example with production enabled:
- Open Timekeeping
- View / Edit Notes & Attachments
- View Inventory Report
- Views – Production
- Materials: Opens the production materials view filtered to the specific transaction.
- Tasks: Opens the production tasks view filtered to the specific transaction.
- Outwork: Opens the production outwork view filtered to the specific transaction.
- Settings
- User Access
- Edit Transaction Type
- Edit Accounting (VAT Types, Currencies, Credit Terms, Accounts)
- Layout
Warning Bar
- Displays warnings about the transaction (e.g. the transaction is not in an accounting status) and lists the NCR number if the transaction is linked to an NCR.
Header Information
| Field | Description |
|---|---|
| Status | Allows users to set the Status for the entry. |
| Status Note | Allows users to type in a Note or instruction for that Status. |
| Req Date | A dropdown list for users to select the Date on which the products or services are required. The field’s caption depends on the related setting. |
| @ | A time chooser for users to select the Time on which the products or services are required. |
| No. | The number of the document. The version number of the document where applicable. |
| Date | A calendar for users to select a Date. |
| Customer / Supplier | A dropdown list of Customers or Suppliers (depending on the transaction) for users to select one. |
| Contact | A dropdown list of Contacts for users to select one. |
| Rep | A dropdown list of Reps for users to select one. |
| Reference | A field for users to type a Reference. |
| Note | A field for users to type a Note. |
| Entity | A dropdown list of Entities for users to select one. Supressed if there is only one registered entity because the transactions are automatically allocated to that entity. |
| Category | A dropdown list of Categories for users to select one for reporting purposes. |
| Order No. | A field for users to type an Order No. |
| Terms | A dropdown list of Terms for users to select one. |
| Deliver To | A dropdown list of the address descriptions. The addresses can be edited directly on the popup. |
Item Information
Buttons Explained
- A Transaction can contain multiple line Items. It can also contain a mixture of the different options available (e.g. a single quotation can include one or more items, custom entries, and estimates.)
- The items that can be added is determined by this setting: Transaction Items > Enable Adding Items. Although all the buttons are shown, some may return an error message if the applicable function is forbidden.
| Button | Description |
|---|---|
| Item | Opens a list of Items for users to select one or more items to add to the transaction. |
| Custom | Allows users to create a Custom Entry. |
| Estimate | Allows users to create an Estimate for the transaction (e.g. Quotation). Only applicable to Transaction Types that include the Estimate option. |
Fields Explained
- Only fields with blue captions can be edited. The rest are prefilled or calculated.
- The available fields depend on the price used (e.g. cost or sell price) and the transaction type’s setup.
| Field | Description |
|---|---|
| /Unit | The Price per Unit (based on the Fixed Price and the Unit Price) in the local currency. |
| /Unit Cur | The Price per Unit (based on the Fixed Price and the Unit Price) in the transaction currency. |
| Adj % | The Percentage Adjustment (e.g. discount) applied to the line item. If a discount should be applied, insert a negative adjustment (e.g. -10). |
| Adjustment | The amount of the Adjustment. |
| Calendar Calendar End – Date | The end date for the calendar. This field caption is user-defined. Calendar entries are prefixed with the word calendar and in this example the custom caption is Calendar End. |
| Calendar Calendar End – Time | The end time for the calendar. This field caption is user-defined. Calendar entries are prefixed with the word calendar and in this example the custom caption is Calendar End. Displayed as @. |
| Calendar Calendar Start – Date | The start date for the calendar. This field caption is user-defined. Calendar entries are prefixed with the word calendar and in this example the custom caption is Calendar Start. |
| Calendar Calendar Start – Time | The start time for the calendar. This field caption is user-defined. Calendar entries are prefixed with the word calendar and in this example the custom caption is Calendar Start. Displayed as @. |
| Calendar Transaction Calendar | A dropdown list of resources (contacts or assets) for users to select one to show on the calendar. (The name of this field depends on the linked calendar.) Calendar entries are prefixed with the word calendar and in this example the linked calendar is named Transaction Calendar. |
| Category | A dropdown list of Categories for users to select one for reporting purposes. |
| Cr Account | The Account that should be credited. |
| Created | The date on which the entry was created. |
| Description | The Description of the item or estimate. |
| Dr Account | The Account that should be debited. |
| Field Chooser (*) | Allows users to add or remove columns. |
| Fix | A checkbox that affects how the price is calculated. If checked both the fixed and unit prices can be edited, and they override the mark-up percentage (MU%) which is calculated based on the entered prices. If unchecked, the MU% is applied to the cost price to determine both the fixed and unit prices. The MU% overrides any entered prices and the prices are adjusted to reflect the MU%. Changes made to the transaction automatically adjust this checkbox in the order that they are made: – If a price is entered the checkbox is checked. – If a MU% is entered, the checkbox is unchecked. |
| Fixed Cost | The line item’s Fixed Cost (a Fixed Cost applies regardless of the Quantity). |
| Fixed Price | The line item’s Fixed Sell Price (a Fixed Price applies regardless of the Quantity). |
| Flow | The system-generated number for the Transaction Flow (e.g. if a Quotation is copied to a Sales Order, they are part of the same transaction flow.) |
| From | The number of the source document (e.g. if a Quotation is copied to a Sales Order, the From field shows the Quotation number). |
| GM% | The Gross Margin Percentage. |
| Group | A field to enter a Group to sort the items. Groups are optional and entered per transaction (e.g. Labour, Materials). Groups can be used to select items that are copied to the next transaction. |
| ID | The system-generated number for the entry. |
| Inc | A checkbox that, if checked, changes the price to VAT Inclusive. |
| Item | The sequential number allocated to the Item on the transaction. |
| Item Type | The name of the Estimate Type where applicable. |
| Location | The Location of the stock item. This field only appears if a Resolve option was selected for the Transaction Type. If there is only one inventory location, or the Fixed Location option was chosen for the item, that location is selected by default. Only locations with an Active Status can be selected. |
| Markup | The Mark-up Amount. |
| MU% | The Mark-up Percentage. |
| Profit | The profit earned on the line item. |
| Qty | The Quantity of the item which defaults to one. Negative quantities are only allowed when the Resolve selected for the Transaction Type is Adjust (e.g. Stock Adjustments). Zero quantities are allowed. |
| Resolve | The Resolve option for the item (e.g. Issue, Receive, Order). If only one resolve option is selected for the Transaction Type, that option is entered by default. Processing rules may also change the resolve (e.g. if sales order is copied to a work order, the resolve is set to Produce). |
| Status | The current Status of the entry. |
| Subtotal | The line item’s Subtotal before Adjustments in the local currency. |
| Total (cur) | The transaction total in the Transaction Currency. |
| Total (exc) | The VAT Exclusive Total in the local currency. |
| Total (inc cur) | The VAT Inclusive Total in the Transaction Currency. |
| Total (inc) | The VAT Inclusive Total in the local currency. |
| Total Cost | The line item’s Total Cost in the local currency. |
| Type | An abbreviation that indicates the Type of entry that was added. |
| Type ID | The system-generated number for the Transaction Type. |
| Unit | The Unit Description of the Item (e.g. ea, kg, hrs). Only editable for custom entries. |
| Unit Cost | The line item’s Unit Cost (a Unit Cost is multiplied by the Quantity). |
| Unit Price | The line item’s Unit Price (a Unit Price is multiplied by the Quantity). |
| Updated | The date on which the entry was updated. |
| Updated By | The User who last updated the entry. |
| VAT | The VAT amount in the local currency. |
| VAT % | The percentage of VAT applied to the line item. |
| VAT (cur) | The VAT amount in the Foreign Currency. |
| VAT Category | The VAT Category selected for the Transaction Type. |
| VAT Type | A dropdown list of VAT Types for users to select one. |
| Widget | A submenu that can also be accessed by right clicking the line entry. The menu options depend on the type of Transaction and the type of line entry. Typical options are: – Open Estimate – View/Edit Artwork – View/Edit Note – Copy Item – Change Item/Unit – Move Up (items can also be moved by drag and drop) – Move Down (items can also be moved by drag and drop) – Delete – Open Linked Item – View Item Summary |
