Order Entry and Quoting Setup Guide
From Adjutant Wiki
Contents
- 1 Overview
- 2 Initial Setup
- 3 Review and Update Rule Maintenance Records
- 3.1 Departments (DEPT)
- 3.2 Doc Vault Drop Folders (DROPFOLDERS)
- 3.3 FOB (Free on Board) Codes (FOB)
- 3.4 Freight PO Item (FREIGHTPOITEM)
- 3.5 Freight Terms (FREIGHT)
- 3.6 PO Bid Types (POBTYPE)
- 3.7 PO Comment Codes (ORDNOTE)
- 3.8 PO Date Defaults (PODATES)
- 3.9 PO Form Number of Copies (POOPTION)
- 3.10 PO Form Section 4 Overrides (POBLOCK4)
- 3.11 PO Ports (PORT)
- 3.12 PO Types (POTYPE)
- 3.13 Ship Via Codes (SHIPVIA)
- 3.14 Terms of Payment Codes (TERMS)
- 4 Review and Complete Additional Purchase Order Setup
- 5 Scrub and Import Open Sales Order Data
Overview
This guide covers the setup of the Order Entry (Sales Order (SO)) and the Quoting (Request For Quote (RFQ)) applications. The majority of the setup items are shared between the two applications.
The Order Entry system covers the creation and processing of customer sales orders for goods or services sold, submitting orders to production, as well as the shipping/invoicing process. The Order Entry system is deeply integrated with the Inventory Control, Advanced Inventory Control (Coil & Lot tracking), Production, Shipping and Logistics, Purchase Order (PO), Project Management, Task Management, Accounts Payable, and Accounting applications. The Order Entry application setup should be completed after the System Manager Setup Guide and the General Ledger Setup Guide have been completed to avoid running into any roadblocks.
A solid understanding of the client's revenue accounting model is required to accurately set up Transaction Categories and/or GL Groups tied to SO types so that orders generate the desired accounting.
Initial Setup
Review/Discuss Sales Tax Policies
Work with the client to understand how sales taxes are handled for customer sales. Most of this should be covered in the sales tax setup process. However, there are frequently special situations that come to light during the SO training process. Determine of the client has any special items or sales situations that should have unique tax handling setups. Some common Order Entry tax overrides include:
- Item Master Sales Tax flag can be turned on/off for specific items
- TAXFREIGHTSTATE setup option can set the taxability of Freight items according to the State Sales Tax Rule
- If the SoldTo customer on the order is marked as tax exempt, all ShipTo child records will automatically be exempt, and any ShipTo tax tables are ignored
Review the following setup options that can control sales order tax reflexes:
- NEWTAX - Should be enabled for all new customers
- SOREQTAXTABLE - Should be enabled for most new customers
- TAXTABLES - Should be enabled for customers subscribed to tax updates, or customers maintaining their own tax tables
- SHIPTOREQTAXTABLE - Will not allow a save of the ShipTo record without a tax table
- SOCHECKTAXRATE - Will pop up a message is tax rate used doesn't match the most current tax rate found
- RFQSHOWTAX - Allows quotes to calculate and display tax amounts
Establish Salespersons and Account Managers
Assign the 'ACCTMGR' attribute to all employee contact records that should appear in the Acc Mgr drop-down list.
Assign the 'SALES' attribute to all employee contact records that should appear in the Salesperson drop-down list.
It is common for clients to want to relabel the Account Manager and Salesperson roles to match their structure. At a minimum, update the following records:
- Rule Maintenance - Contact Attributes - SALES attribute description
- Rule Maintenance - Contact Attributes - ACCMGR attribute description
- Sales Order - Labels - lacctmang - Current Value (Should cover both SO and RFQ)
- Sales Order - Labels - lsp - Current Value (Should cover both SO and RFQ)
- ALL forms that display Salesperson or Account Manager labels will need to be customized
- ALL reports that the client uses that display Salesperson or Account Manager will need to be customized
Set Default SO/RFQ Types by User
If the client wants the default SO or RFQ type to be set per user, get a list of which users and which types should default from the client.
The SOTYPE-X attribute (where X represents the SO Type code) can be created and added to employee contacts to default the SO type for that user.
The RFQTYPE-X attribute (where X represents the RFQ Type code) can be created and added to employee contacts to default the RFQ type for that user.
Sales Order Form(s)
Work with the client to determine how many PO form layouts will be needed for their operations. Most clients only need a single PO form, but Adjutant can accommodate unique forms that will default in from the POTYPE rule.
- The default PO form from MASTER should only need minor customizations for disclaimer areas, and to confirm that the logo images scale and display correctly.
- Make any further customizations and create additional forms as needed.
- Get client approval on all PO forms.
- The default PO form can be set in the PO Types rule, and individual vendors can be set to a default PO Type in the 'Sold From' attribute.
Vendor Pricing
Custom purchase pricing can be set up by combinations of vendor cost group, item group, and entity similar to customer pricing. The Vendor Pricing setup is similar to customer pricing. It has been rare that clients price/cost their purchases by vendor cost groups. Confirm whether the client has any custom vendor pricing that is defined by vendor groups.
- If the client does not have any group pricing rules, vendor pricing can be set in the Item Master C/V Part screen.
- If the client has vendor pricing that is defined by vendor groups, define the groups in the Vendor Cost Groups (ENTVGRP) rule, and set up the Vendor Pricing screen.
Set the Next PO Number
Review and update the 'Prefix' and 'Current Number' values in the CID Maintenance Counters tab for the PONO line. Establish the beginning PO number.
Review and Update Rule Maintenance Records
Departments (DEPT)
The DEPT rule sets the available departments for multiple applications, including Task Management, Resources, Item Control, Production, and Purchase Orders. If the client intends to categorize purchase orders by department, verify that the needed department records exist.
The department entry marked as Default will populate the department in a new Purchase Order, unless the logged in user has a Resource attribute set with a department.
Doc Vault Drop Folders (DROPFOLDERS)
Review the drop folder entries for Vendor Bids (BPONO) and Purchase Orders (PONO).
FOB (Free on Board) Codes (FOB)
FOB Codes are valid in Order Entry and Purchase Orders. Generally, FOB defines the point at which the seller is no longer responsible for the shipping cost.
The rule in MASTER has the most common entries, and should be valid for most clients. Add any additional FOB codes as needed.
Freight PO Item (FREIGHTPOITEM)
The Fright PO Item is only used for clients that are generating purchase orders from shipping event records. The item in this rule is used as the line item when generating a freight PO.
Freight Terms (FREIGHT)
Freight terms are valid in Order Entry, Shipping, and Purchase Orders. Add any needed freight types to this rule to populate the list of available freight types in the associated applications.
PO Bid Types (POBTYPE)
The PO Bid Types rule sets the available bid types for the Vendor Bid application, the associated PO form to use, and which PO Type to use if the bid is converted to a live PO.
The MASTER rule has a default entry. If the client is planning to use Vendor Bids, confirm that all needed bid types are set up.
PO Comment Codes (ORDNOTE)
The PO Comment Codes rule allows users to set up predefined notes that can be included on purchase orders. The functionality is similar to the comment codes that can be used on orders and invoices. Add any needed quick PO comment codes in this rule.
PO Date Defaults (PODATES)
The PODATES rule controls how the PO Req Date and the PO Est Date are set on a new PO. The rule allows you to override the default logic when creating new POs. Verify the entries in this rule are what the client wants.
PO Form Number of Copies (POOPTION)
The POOPTION rule provides one of the more comical internal rule names. If the client needs anything other than one copy of the PO form to print with every request, update the rule accordingly.
PO Form Section 4 Overrides (POBLOCK4)
The POBLOCK4 rule was created to hold certain print overrides based on FOB and PORT entries for a specific customer. Review ECR 23735 to determine if this rule would be useful for your client.
PO Ports (PORT)
The PORTS rule holds the valid entries for the Port drop-down list on a purchase order. If the rule is empty, Port will not be filled in and will not be required in order to add a PO.
PO Types (POTYPE)
The POTYPE rule controls the valid types, default form to use, GL Group, and which type is the default entry. If the client is not interested in controlling or reporting purchase orders by type, an entry is still required as the default type.
Ship Via Codes (SHIPVIA)
The SHIPVIA rule sets the valid drop-down entries for the Ship Via field in the Order Entry, Purchase Order, and Shipping Events applications. The rule also controls several alerts and automated reflexes, like generating shipping events, or adding certain charges.
Review this rule carefully for any special options and reflexes. Add any needed ship via methods to the rule.
Terms of Payment Codes (TERMS)
The TERMS rule controls the valid terms of payment for both the AR and AP applications. Reconcile the entries against the customer questionnaire and the Open AP Invoice import data (if customer's data includes payment terms). Add any needed terms and delete any terms that are not needed. Too many TERMS options generally add user confusion and can create invoice records with unwanted terms.
Review and Complete Additional Purchase Order Setup
Set up Templates and Recurring Orders
Discuss Purchase Order Templates and Recurring Purchase Orders with customer.
- Set up any templates and/or recurring orders as needed with the customer. Use the Recurring Order WIki as a reference for the recurrence codes.
Confirm version of PO Receipt Screen
Adjutant has a legacy version of the PO Receipt screen that is still in use, and has been used at new clients for specific functions. Generally, new clients should be using the 'New' PO Receipt screen for all receiving functions.
The NEWPOREC CID Setup Option should be enabled to make the 'PO Rec' button in the PO screen open the new version of the PO Receipt screen .
Remove any menu selections that point to the legacy screen and make sure that all menus and shortcuts point to the desired PO Receipt screen.
- If the customer will use the legacy screen for specific purposes, create a shortcut to the screen on the specific user's desktop.
Scrub and Import Open Sales Order Data
Open Sales Order conversions are rare, and generally discouraged. Generally, the amount of open sales orders for any client is small enough that it is not worth going through the scrub and import process. The value of having the end-user train on the Order Entry system by entering the open orders manually usually outweighs the amount they would spend on having ABIS complete a data import for a handful of records.
If the client requires an open sales order conversion, refer to the Sales Order Conversion Guide (UNDER CONSTRUCTION) for detailed information on the import and reconciliation process.