Configuration of Order Management: Implementation Activity
In this implementation activity, you will learn how to prepare the system to support the tracking of inventory and the processing of sales and purchase orders with stock items.
The following activity is based on the U100 Basic Company dataset. If you are using another dataset, or if any system settings have been changed in U100 Basic Company, these changes can affect the workflow of the activity and the results of the processing. To avoid any issues, restore the U100 Basic Company dataset to its initial state.
If you want to perform this activity in an out-of-the-box company instead of creating a tenant with the dataset, you need to prepare a company with the basic settings, as described in Company Without Branches: General Information.
Video Tutorial
This video shows you the common process but may contain less detail than the activity has. If you want to repeat the activity on your own or you are preparing to take the certification exam, we recommend that you follow the instructions in the steps of the activity.
Story
Suppose that you are an implementation manager for the SweetLife Fruits & Jams company, and you need to configure the system for the processing of sales and purchases of stock items through orders.
Process Overview
In this activity, you will do the following:
- Configure inventory preferences on the Inventory Preferences (IN101000) form
- Configure sales order preferences on the Sales Orders Preferences (SO101000) form
- Configure purchase order preferences on the Purchase Orders Preferences (PO101000) form
- Review the company's units of measure on the Companies (CS101500) form
- Configure inventory control accounts on the Chart of Accounts (GL202500) form
System Preparation
Before you start configuring the inventory and order management functionality, you should do the following:
- Launch the MYOB Acumatica website with the U100 Basic Company dataset preloaded, and sign in to the system as implementation manager Kimberly Gibbs by using the gibbs username and the 123 password.
- On the Enable/Disable Features (CS100000) form, make sure that the Inventory and Order Management and Inventory features are enabled.
- On the Reason Codes (CS211000) form, create and save the reason codes that are required for configuring inventory and order management, as described in Reason Codes: Implementation Activity.
- On the Order Types (SO201000) form, activate at least the SO order type, as described in Sales Order Types: To Activate the SO Order Type.
Step 1: Configuring Inventory Preferences
To configure the inventory functionality, do the following:
- Open the Inventory Preferences (IN101000) form.
- In the Default Reason Codes section
of the General tab,
specify the following settings:
- Receipt Reason Code: INRECEIPT
- Issue/Return Reason Code: INISSUE
- Adjustment Reason Code: INADJUST
- Phys. Inventory Reason Code: PHYINVADJ
- In the Posting Settings section, select the Update GL check box.
- In the Data Entry Settings section, clear the Hold Documents On Entry and Validate Document Totals on Entry check boxes.
- On the form toolbar, click Save.
Step 2: Configuring Sales Order Preferences
To configure the sales order functionality, do the following:
- Open the Sales Orders Preferences (SO101000) form.
- In the Data Entry Settings section of the General tab, make sure that SO is selected in the Default Sales Order Type box. This is the predefined sales order type used for the processing of stock items with shipping.
- In the Shipment Settings section, clear the Hold Shipments on Entry and Validate Shipment Total on Confirmation check boxes.
- In the Invoice Settings section, clear the Hold Invoices on Failed Credit Check check box.
- In the Posting Settings section, select the Automatically Release IN Documents check box.
- On the form toolbar, click Save.
Step 3: Configuring Purchase Order Preferences
To configure the purchase order functionality, do the following:
- Open the Purchase Orders Preferences (PO101000) form.
- In the Validate Total on Entry section of the General tab, make sure that the For Normal and Standard Orders and For Receipts check boxes are cleared.
- In the Other section, specify VENDORRET as the PO Return Reason Code.
- Select the Release IN Documents Automatically and Release AP Documents Automatically check boxes.
- Clear the Hold Receipts on Entry check box.
- On the form toolbar, click Save.
Step 4: Reviewing the Company’s UOMs
To review the settings of the company’s units of measure (UOMs), do the following:
- Open the SWEETLIFE company on the Companies (CS101500) form.
- In the Miscellaneous Settings (Shared) section of the Company Details tab, make sure that KG has been specified in the Weight UOM box and LITER in the Volume UOM box.
Step 5: Reviewing Inventory Control Accounts
To review the control accounts needed for inventory operations, do the following:
- Open the Chart of Accounts (GL202500) form.
- Search for
the 12100 account that has Inventory Asset
in the
Description column.Tip:To search for a record in a list or records, you can enter a text string in the Search box of the filtering area. The system will find all the records that match your search criteria and display these records in the table. For details, see Searching in MYOB Acumatica.
- In the Control Account Module column for the 12100 - Inventory Asset account, make sure that IN is specified.
- Search for the 20100 account that has Inventory Purchase Accrual in the Description column.
- In the Control Account Module column for the 20100 - Inventory Purchase Accrual account, make sure that PO is specified.
You have configured the basic inventory and order management functionality. Now you can proceed with configuring inventory entities. For details, see Preparing Inventory Entities.
Activity Recap
In this activity, we have illustrated how the implementation manager has done the following:
- Configured the basic settings of inventory documents, sales orders, and purchase orders
- Reviewed the company’s UOMs
- Configured control accounts for inventory operations