Sales Entry Sales Manager Update Report overview

Factors that control file updates

The SM Warehouse/Product Totals Setup and SM Extended Warehouse/Product Totals Setup updates take into consideration the nonstock and kit component settings, based on options in SA Administrator Options-Sale History-Levels.

If the Store Sales for Non-stock Products option is selected, sales analysis information is tracked for the nonstock product/nonstock component. If there is sufficient demand, you should consider stocking the product. If the Store Sales for Kit Components option is selected, sales analysis information is tracked for each component. The kit product itself is automatically recorded in Sales Manager, unless the Sales Manager option in Product Warehouse Product Setup is not selected.

SM Warehouse/Product Totals Setup is updated for lost business lines and lost business orders when the order is set to lost business. Nonstock lost business does not update SM Warehouse/Product Totals Setup unless the Store Sales for Non-stock Products option is selected in SA Administrator Options-Sale History-Levels.

If a customer rebate exists on a line, the rebate amount is subtracted from the sales amount before Sales Manager is updated. If it is a vendor rebate amount, it is subtracted from the cost before Sales Manager is updated, if the Subtract Vendor Rebate from Cost option is selected in SA Administrator Options-Sale History-Rebates/Basis.

When the original order is canceled and a back order is created, the canceled order does not update Sales Manager. Core charge returned lines do not update Sales Manager, although Return Merchandise (RM) and returns on Counter Sales (CS), and Stock Orders (SO) will affect the Sales Manager totals. Quote Orders (QU), Blanket Orders (BL), and Received on Account (RA) order types are not included in the Sales Manager update because only invoiced orders are included in the update.

Warranty exchange lines are not used to update Sales Manager because there is no cost or sales amount. A Correction (CR) order updates Sales Manager when the order is invoice processed or when Sales Entry Sales Manager Update Report is generated. The SM Government Tax Register Report is also affected by the CR. However, the CR is not included in SM Commission Report.

The SM Extended Product Category Setup and SM Extended Warehouse/Product Totals Setup files are updated based on posting date and cannot be compared with the General Ledger, but they can be useful for sales analysis reports. The Last Purchase-Qty in SM Extended Warehouse/Product Totals Setup is updated with the quantity sold, and the Unit field is expressed in selling units, rather than stocking units.

If Sales Manager is updated on a calendar year basis based on the Store Files by Calendar or Fiscal option in SA Administrator Options-Sale History-Levels, the posting date determines which period to update.

The commission amounts are not calculated at this time but are calculated during the SM Commission Report. If the order is in Stage 4 (Invoiced) or 5 (Paid), you can generate the SM Commission Report whenever you want. There are no time constraints as to when it must be performed. Once the actual commission amount is calculated, it is stored in the Sales Commission Setup file. The SM Commission Report can be generated for previously reported commissions, unreported/uncalculated commissions, or both.

During Sales Entry Invoice Processing Report, the commission cost is calculated based on options in SA Administrator Options-Products-Costs. The commission types are set up in Sales Commission Setup. The commission type is obtained from one of three places:

• The PD Pricing Setup record for the product or customer.
• If a commission type does not exist in PD Pricing Setup, the Commission Type from the Sales Salesrep Setup information is used.
• From the line item if the product was entered as a nonstock product. You can manually specify a commission type on the Nonstock window. The commission type comes from the outside sales representative’s record.

If the product is a build-on-demand kit, the General Ledger cost is used when component costs are rolled into the kit cost. The internal cost override option is selected if the cost is manually overridden in Sales Order Entry. The cost of each component may include the addon cost. If a component is a special product with a tie to a purchase order or warehouse transfer, the average cost of the product is recalculated, but the component is not recosted.

If the component is stocked or a special item without a tie, the component is recosted and not reaveraged. The commission cost will always be calculated per the Calculate Commission From option in SA Administrator Options-Products-Costs and is set in the Sales Order Entry-Kit window. This cost is only rolled to the sales order header and line item records if the Roll-up option in Product Setup-Pricing is set to Both or Pricing Cost. If the kit is specially costed, the commission is based on the special cost. If the kit contains a nonstock product, the cost of the nonstock product is included in the commission cost.

You can override all commission information in Sales Entry Maintain Commissions. Use Sales Maintain Commission Entry to modify the commission information stored with each line item on an order. However, once the commission is paid, do not change the commission amounts.

Storeroom

Sales order lines for customer-owned inventory are not included in Sales Manager data since it has already been sold to the customer.