Collapse AllExpand All

13.1.1. Configure Sales

To configure the Sales module, go to Sales > Setup. The following screen will appear:

Sales configuration

When configuring the Sales module, you are presented with the following options:

Sales Order # Generation

Select one of the available sales order number generation methods:

Manual

Sales order numbers must be entered manually whenever you create a new sales order.

Automatic

Sales order numbers will be automatically incremented by 1 each time a new sales order is created. These automatically-generated numbers may not be edited. They are read-only.

Automatic, Allow Override

Sales order numbers will be automatically generated and incremented, as under the Automatic option described above. However, this option also allows you to manually override the sales order number at the time of sales order creation.

Next #

The next sequentially available sales order number will display here. You may change the number—creating a new basis for the next sales order number—by typing the new number into this field. Any changes you make here will be reflected the next time a new sales order is created.

Quote # Generation

Select one of the available quote number generation methods:

Manual

Quote numbers must be entered manually whenever you create a new quote.

Automatic, Use Quote #'s

Quote numbers will be automatically incremented by one each time a new quote is created. These automatically-generated numbers may not be edited. They are read-only.

Automatic, Use Quote #'s, Allow Override

Quote numbers will be automatically generated and incremented, as under the Automatic option described above. However, this option also allows you to manually override the quote number at the time of quote creation.

Automatic, Use S/O #'s

Quote numbers will be automatically incremented by one each time a new quote is created, using the same number generation method specified for the creation of sales order numbers. These automatically-generated numbers may not be edited. They are read-only.

Next #

The next sequentially available quote number will display here. You may change the number—creating a new basis for the next quote number—by typing the new number into this field. Any changes you make here will be reflected the next time a new quote is created.

Return Auth. # Generation

Select one of the available return authorization number generation methods:

Manual

Return authorization numbers must be entered manually whenever you create a new return authorization.

Automatic, Use R/A #'s

Return authorization numbers will be automatically incremented by one each time a new return authorization is created. These automatically-generated numbers may not be edited. They are read-only.

Automatic, Use R/A #s, Allow Override

Return authorization numbers will be automatically generated and incremented, as under the Automatic option described above. However, this option also allows you to manually override the return authorization number at the time of return authorization creation.

Next #

The next sequentially available return authorization number will display here. You may change the number—creating a new basis for the next return authorization number—by typing the new number into this field. Any changes you make here will be reflected the next time a new return authorization is created.

Sales Credit # Generation

Select one of the available sales credit number generation methods:

Manual

Sales credit numbers must be entered manually whenever you create a new sales credit.

Automatic, Use Sales Credit #'s

Sales credit numbers will be automatically incremented by one each time you issue a new sales credit. These automatically-generated numbers may not be edited. They are read-only.

Automatic, Use Sales Credit #'s, Allow Override

Sales credit numbers will be automatically generated and incremented, as under the Automatic option described above. However, this option also allows you to manually override the sales credit number at the time of sales credit creation.

Automatic, Use S/O #'s

Sales credit numbers will be automatically incremented by 1 each time a new sales credit is created, using the same number generation method specified for the creation of sales order numbers. These automatically-generated numbers may not be edited. They are read-only.

Next #

The next sequentially available sales credit number will display here. You may change the number—creating a new basis for the next sales credit number—by typing the new number into this field. Any changes you make here will be reflected the next time you issue a new sales credit.

Invoice # Generation

Select one of the available invoice number generation methods:

Automatic

Invoice numbers will be automatically incremented by 1 each time a new invoice is created. These automatically-generated numbers may not be edited. They are read-only.

Automatic With Override

Invoice numbers will be automatically generated and incremented, as under the Automatic option described above. However, this option also allows you to manually override the invoice number at the time of invoice creation.

Next #

The next sequentially available invoice number will display here. You may change the number—creating a new basis for the next invoice number—by typing the new number into this field. Any changes you make here will be reflected the next time you create a new invoice.

To establish general settings for the Sales module, select the General tab. The following options will appear:

Print sales Order on Save by Default

Select to prompt users to print sales orders whenever sales orders are saved. If selected, users will be presented with a Print Sales Order screen whenever a sales order is saved. To bypass this feature, do not select this option.

Perform Credit Limit check on S/O Save

Select if you want to perform a check of customers' credit before their sales orders are saved. This credit check compares the customer's credit limit to the sum of their open sales orders and open receivables. If the customer is found to be over their credit limit, the sales order cannot be saved—except by users with the override privilege. If this option is not selected, normal credit checking will occur during the shipping phase.

Date Control

Select from the following date control options:

Allow ASAP Schedule Dates

Selecting this option will cause sales order line items to default to the current date if no schedule date is entered.

Note

The allocation of available credit memos occurs only once—when a sales order is saved for the first time. Subsequent saves will not result in additional allocations.

Enable Promise Dates

Select to display a Promised Date field on the Sales Order Line Item screen, by default. If not selected, there will be no Promised Date field shown on that screen.

Change Log

Select from the following change log options

Post Customer Changes

Select to post to the change log any changes made to Customer masters.

Post sales Order Changes

Select to post to the change log any changes made to sales orders.

Enable Reservations

Select to enable the sales order reservations functionality system-wide. This feature allows for the hard allocation of quantity to sales orders. When this feature is selected, the Issue Stock to Shipping screen will enforce and disable the option to require sufficient inventory. If not selected, the sales order reservation options will be hidden from view.

Require Reservations

When checked, the quantity issued to shipping will be limited by the quantity reserved for a sales order.

Reserve by Location

Select to set sales reservations for discrete locations and lots. The hard allocation of quantity will be for particular locations and will prevent other orders from issuing reserved inventory. The sales order pick list will print the reserved location to expedite inventory picking. You may choose the order of precedence for selecting locations: lowest quantity first, highest quantity first, or alpha by location name.

Note

Changing the Reserve by Location option from enabled to disabled will remove all location reservations.

Lowest Quantity First

Locations for the item will be sorted ascending by quantity. Reservations will start with the location with the lowest quantity and continue until the quantity required is fully reserved or there is insufficient quantity on hand (QOH).

Highest Quantity First

Locations for the item will be sorted descending by quantity. Reservations will start with the location with the highest quantity and continue until the quantity required is fully reserved or there is insufficient QOH.

Alpha by Location Name

Locations for the item will be sorted ascending alphabetically by the location name. Reservations will start with the first location and continue until the quantity required is fully reserved or there is insufficient QOH.

Allow Manual Reservations

If selected, this option allows a user to choose a specific lot to be reserved for a sales order item.

Ship Control

Select from the following ship control options:

Show Save and Add to Packing List button on Sales Order

Select if you want the SAVE AND ADD TO PACKING LIST button to always be displayed on the Sales Order header screen. If this option is not selected, the SAVE AND ADD TO PACKING LIST button will only be displayed for newly-entered sales orders which have not yet been saved.

Firm sales orders when added to Packing List Batch

Select to make sales order line items firm when the sales order they are on is added to the packing list batch.

Enable Shipping interface from Sales Order screen

Select to enable the performance of limited shipping functionality from the Sales Order header. If selected, users will be able to issue stock to shipping and also return stock from shipping directly from the Sales Order header. If not selected, these shipping options will not be available on the Sales Order header.

Check 'Approve for Billing' option on Ship Order

Select if you want the Approve for Billing option to be selected by default whenever you ship sales order line items. Selecting this option reduces steps in the billing process. Specifically, if an order is selected for billing when it is shipped, you do not then have to take the extra step of independently selecting the order for billing. This can save time and also ensure your shipped orders are selected for billing at the time of shipment.

Sales Credit Control

Select from the following sales credit control options:

Restrict Sales Credits to Items on their Apply-To Document

Select if you want to restrict sales credit items to their apply-to document. Selecting this option narrows the sales credit item selection process to only those items which appeared on the invoice the sales credit is being applied to. If not selected, a sold Item master list will appear instead when selecting sales credit items for sales credits applied to a specific invoice. This setting has no bearing on unapplied sales credits.

Allocate Sales Credits to New Sales Order on Save

Select to have open sales credits for a customer automatically allocated to any new sales orders entered for that customer. This functionality helps reduce customer credit balances by ensuring that customer credits are consumed when new sales orders are entered. Any available, open sales credits are eligible for allocation. The allocation of available sales credits occurs only once—when a sales order is saved for the first time. Subsequent saves will not result in additional allocations. Sales credits which have been allocated to a sales order are applied at the point when the invoice resulting from the sales order is posted. Once the full balance of a sales credit has been applied, the sales credit is then closed. The printed invoice the customer receives will indicate whether sales credits have been applied. In addition, the total due from the customer will be automatically adjusted to reflect any applied credits.

Show Quotes After Converted

Select if you want to be able to view historical quotes after they have been converted to sales orders. If you don't select this option, converted quote information will not be saved.

Use Enhanced Commissions

Select to enable the enhanced commissions package. To learn more about this feature set, please see the Enhanced Commissions product guide.

Display Sales Order Line Items Tab by Default

Select to display the Sales Order window with the Line Items tab displayed initially.

Use Inside Sales Rep

Select if you want the user entering a sales order to be recorded automatically as the inside sales rep. If enabled, a characteristic called INSIDEREP will be added to the sales order with the value being the username of the user who is entering the order. The inside rep information will be included in the Gross Margin Commissions report. If you don't select this option, users entering sales orders will not be identified as inside reps.

To establish customer pricing options, select the Pricing tab. The following screen will appear:

Customer Pricing

When establishing customer pricing options, you are presented with the following options:

Price Control

Select from the following price control options:

Allow Price Discounts

Check this option to allow pricing discounts for select customers. This option instructs the system to verify whether any pricing discounts have been established for a customer, prior to calculating the line item price for of an item within a sales order. If this option is unchecked, then the system will apply the full list price for an item within a sales order.

Disallow Override of Sales Price on Sales Order

Select to prevent all users from overriding the sales price when entering sales order line items. This is a system-wide setting, affecting all users. Do not select this option if you want to selectively prevent users from overriding sales prices. Individual users may be granted the ability to override sales prices, use the Sales module's override price privilege.

Hide Misc. Charges on Sales Order screen

Select to hide all fields related to miscellaneous charges on the Line Item tab of a Sales Order screen. If your site does not use miscellaneous charges when entering sales orders, it may make sense to hide this functionality to avoid confusion.

Item Precedence Over Product Category Pricing

If selected, item-specific price schedule pricing takes precedence over product category pricing. Leave unchecked if the lowest overall price should be selected.

Use List Price Schedules

Select to enable the use of list pricing schedules, also known as alternate list pricing. If not selected, standard list pricing will be used. To learn more about how alternate list pricing works, please see the Alternate List Pricing article at xTupleU.

Use Wholesale Price as Unit Cost for Markups

If selected, the item wholesale price is used as basis for markup pricing. Leave unchecked to use the standard or average cost against the item or item site cost.

Use "Gross Margin " Method for Markups

Select to calculate markup percentage up to 50% as unit cost divided by (1 / markup). The price will otherwise be calculated as the sum of the unit cost and (unit cost * markup).

Freight Pricing

Specify how you want freight charges to be handled when shipping orders and sales credits:

Use calculated Freight values by default

If selected, items issued to shipping will be checked against pricing schedules to determine the actual freight for a given shipment based on shipping quantities and weight rather than assuming all freight should be billed. If not selected, the freight amount on an order or sales credit will be billed on every shipment.

Include Package Weight in Freight Calculation

Select to include package weight in the freight calculations. If not selected, package weight will be excluded.

Pricing on Line Item Edits

Select one of the following as your preferred response when users change sales order line item quantities:

Note

The sales order line item pricing options apply only when editing line item quantity.

Update Price

If selected, the system will automatically update the net unit price for the line item, adjusting to accommodate the newly-entered quantity.

Do not Update Price

If selected, the net unit price will not be changed when line item quantity is changed on EDIT—and users will not be prompted to consider changing the price.

Prompt before Updating

If selected, the system will ask users if they want to update the net unit price (YES/NO). If they answer YES because they do want to update the price, then they will have to manually make the price adjustment.

Ignore if Discounted

Select if you want price update warnings to be ignored when line items being edited are already discounted. Also, if sales order header changes cause prices to be updated, any discounted line items will not be updated.

Price Effective Date

Specify one of the following options for when item prices should be effective as of:

Current

Select if you want item prices to be effective as of the current date.

Order

Select if you want item prices to be effective as of the order date.

Scheduled

Select if you want item prices to be effective as of the scheduled date.

To establish invoice and credit memo settings, select the Invoice tab. The following screen will appear:

Invoice configuration

When establishing invoice and credit memo settings, you are presented with the following options:

Invoice Date Source

Select one of the following invoice date options:

Current Date

If selected, the invoice date on the invoice header will be the same date as the sales order date.

Shipped Date

If selected, the invoice date on the invoice header will be the same date as the sales order ship date.

Scheduled Date

If selected, the invoice date on the invoice header will be the same date as the sales order scheduled date.

Default Invoice Copies

Indicate how you want invoice copies to print.

# of Copies

Indicate the number of copies you want to print. Information about the specified copies will display below.

Default Sales Credit Copies

Indicate how you want sales credit copies to print.

# of Copies

Indicate the number of copies you want to print. Information about the specified copies will display below.

To establish default settings to be used whenever new customers are entered, select the Customer Defaults tab. The following screen will appear:

Customer Defaults

When creating new customer records, it can be useful to have a core set of default values already pre-defined. All these values can be changed when you are creating new customers. However, they provide you with a default starting point. The following settings you define here will be present whenever you create a new customer:

Customer Type

Specify a default customer type to be used whenever new customers are created.

Sales Rep

Specify a default sales representative to be used whenever new customers are created.

Ship Via

Specify a default ship via to be used whenever new customers are created.

Shipping Form

Specify a default shipping form to be used whenever new customers are created.

Shipping Charges

Specify a default shipping charge to be used whenever new customers are created.

Preferred Selling Site

Specify a preferred selling site to be used whenever new customers are created.

Terms

Specify the default billing terms to be used whenever new customers are created.

Balance Method

Specify a default procedure for handling cash receipts from customers. This notation is informational only.

Balance Forward

Select to indicate you want to apply cash receipts to the customer's current balance due.

Open Item

Select to indicate you want to apply cash receipts to specific customer open items.

List SOs Start Date

Specify the start date for sales orders. Use "0" for the current date. The default date is set at -90 days.

Accepts Partial Shipments

Select to indicate customers accept partial shipments by default.

Accepts Backorders

Select to indicate customers accept backorders by default.

Allow Free Form Ship-Tos

Select to indicate customers allow free-form ship-tos by default. This default appears on the Customer master.

Allow Free Form Bill-Tos

Select to indicate customers allow free-form bill-tos by default. This option is unchecked by default.

Credit Limit

Specify the default credit limit to be used for all customers.

Credit Rating

Specify the default credit rating to be used for all customers.

Credit Status

Select the default credit status to be used for all customers.

To define your system's return authorization configuration, select the Return tab. The following screen will appear:

Returns configuration

When configuring return authorization settings, you are presented with the following options:

Enable Return Authorizations

Select to enable the system's return authorizations capability. If not selected, users will be prevented from performing any tasks related to return authorizations—and related functionality will be hidden from view. For systems where return authorizations are enabled, this option will be hidden.

Post Return Authorization Changes to the Change Log

Select to record changes made to return authorizations in the return authorization change log. If not selected, the return authorization changelog will not contain change information.

Default Disposition

Specify one of the following default methods for handling return authorizations:

Credit

Select if, by default, you want to issue credit to customers for authorized line items and quantities. No return is required or expected. Return authorization line items will close when an associated credit memo is posted.

Return

Select if, by default, you want to authorize returns from customers. Return authorization items will close when an associated credit memo is posted, or when all items on a line have been returned, whichever comes last.

Replace

Select if, by default, you want to replace items returned by customers. Authorized quantities will be added as additional order quantity to an associated sales order line, which in turn should be reopened if closed. Return authorization items will close when all items on the line have been returned or all authorized items on the line have been shipped, whichever comes last. No money should be involved when invoicing replacement items.

Service

Select if, by default, you want to repair or service items returned by customers. Service or repair items will first be received by a return authorization. Then a new sales order with linked work order(s) will be created to track work and shipping on the repair or service. The new sales order will be on RMA hold until items have been received by the return authorization.

Substitute

Select if, by default, you want to authorize the substitution of items returned by customers. Under this option, when an original sales order is imported into the return authorization, the return authorization Line items will default to the return disposition. Any new line items added beyond the original ones will have a default disposition of ship.

Credit/Ship

Specify the default timetable for customer credits and/or returns:

Immediately

Select to issue credit or send returns to customers immediately by default.

Upon Receipt

Select to issue credit or send returns to customers only after you have received returned goods from them by default.

Default Credit Method

Specify one of the following default credit method options:

None

Select if, by default, you do not issue credit for customer returns.

Credit Memo

Select if, by default, you credit customer returns with a credit memo to the customer's account. This option will result in the automatic creation of a sales credit memo.

Payment

Select if, by default, you credit customer returns by sending them a payment. This option will create a credit memo, then a miscellaneous payment that applies to the credit memo.

Credit Card

Select if, by default, you credit customer returns with a refund on their credit card.

Check Print on Save by Default

Select if you want the Print on Save option to always be enabled when creating new return authorizations.

Close Return Authorization when Crediting

If selected, return authorization line items will be closed automatically when a return credit is created and posted.

To enable and/or configure the Simple Sales Order screen, select the Simple S/O tab. The following screen will appear:

Simple S/O configuration

When enabling or configuring the Simple Sales Order screen, you are presented with the following options:

Enable Simple S/O

Select to enable the Simple Sales Order screen. The simple sales order is an easy-to-use alternative interface for quickly processing non-complex sales orders. The screen is ideally suited for environments where complex order information is not required (e.g., counter sales, retail, etc.). If enabled, the screen will be available from the Sales > Sales Order menu. If disabled, the menu option will not appear.

Cash Customer #

Enter a customer number to be used as the default cash-paying customer when entering simple sales orders. During order entry, you may easily override the default with either pre-existing other or new customer information.

Sale Type

Specify the sale type to be used for sales orders entered using the Simple Sales Order screen. The sale type selection impacts the sales account assignment for orders entered using this screen.

Require Sufficient Inventory to Ship

Select to ensure you have enough QOH in stock of a line item prior to shipping. If selected, this option will prevent you from shipping a line item if doing so would force QOH for the item site to fall below zero. Not selecting this option means shipping may drive QOH negative.

Print S/O Acknowledgement (Hold Only)

Select to automatically prompt for printing a sales order acknowledgement form when a simple sales order is held. If not selected, users won't be prompted to print the acknowledgement form when holding a simple sales order.

Print Shipping Packing List

Select to automatically prompt for printing a shipping packing list when payment for the simple sales order is posted. If not selected, users won't be prompted to print the packing list when posting payment.

Print Invoice

Select to automatically prompt for printing an invoice when payment for the simple sales order is posted. If not selected, users won't be prompted to print an invoice when posting payment.