SM Rebate Report ranges and options

Ranges

See Ranges.

Options

(V)endor or (C)ustomer Rebates

Specify one of these values to determine the type of rebates to include on the report:

  • V: Vendor rebates
  • C: Customer rebates

    Reports for customer rebates include this information:

    • Each product
    • Invoice number
    • Date
    • Quantity
    • Unit
    • Net amount
    • Amount of the rebate owed to the customer for the sale
(P)urchase, (S)ale or (B)oth

This option is valid for vendor rebates only.

Specify one of these values to determine the type of vendor rebates that are included on the report:

  • P: Vendor on Purchase rebates

    This information is included on the report:

    • Purchase order number
    • Date
    • Quantity
    • Purchase amount
    • Amount of the rebate due from the vendor for the purchase
  • S: Vendor on Sale rebates

    This information is included on the report:

    • Invoice number
    • Date
    • Quantity
    • Net cost
    • Net amount of the rebate due from the vendor for the sale
  • B: Vendor on Purchase and Vendor on Sale rebates
Status: (I)nv,(P)rnt,(D)isp,(U)pd,(R)econ

Specify one or more of these values to include the associated information on the report:

  • I: Invoiced rebate lines
  • P: Rebates that were previously updated in the report totals
  • D: Disputed claims
  • U: Updated claims
  • R: Reconciled claims

If you specify more than one value, do not separate the values by commas. For example, specify dur to include disputed, updated, and reconciled claims on the report.

Update Invc Rebates to Printed Status?

Select Yes to update the rebate types. A unique claim number and a header record are created for each vendor. The header record contains information for each vendor rebate that was updated. Any rebate types for orders that are included on the report show an r for reported.

Print Totals Only?

Select Yes to print only totals. Select No to print full details, such as individual products and customers.

Print eCommerce Data Where Appropriate?

This option is valid for vendor rebates only.

Select Yes to generate EDI 844 Product Transfer/Account Adjustment output for vendors, based on the method that is specified in the Rebates field in Vendor Setup-eCommerce.

To generate EDI 844 Product Transfer/Account Adjustment output, you must specify No for Print Totals Only?.

If you specified I for Status (I)nv,(P)rnt,(D)isp,(U)pd,(R)econ, only rebates that were not previously updated by the report are included in the output. In this case, select Yes for the Update Inv Rebate to Printed Status? option.

If you specified P for Status (I)nv,(P)rnt,(D)isp,(U)pd,(R)econ, only rebates that were previously updated by the report are included in the output.

EDI/XML Flat File Directory

Leave this field blank.

Use Reconciled Rebate?

Select Yes to use the rebate amount that received from the vendor to calculate total rebate amounts.

Select No to use the original rebate amount. If you use this report to balance your Rebates Due account, and you specified P, D, or U for the Status (I)nv,(P)rnt,(D)isp,(U)pd,(R)econ option, select No.

Include UPC Numbers On Report?

Select Yes to print the UPC number for each product. A third heading and detail line prints for each product.

Enter a List of Vendors?

To include specific vendors on the report, select Yes, and then click List to specify the vendors. The vendors that you specify for this option overrides the vendor range values.

Include Serial Number? (XML/ION only)

Select Yes to include serial numbers in the output. This option is valid only if XML or ION is selected in the Rebates field in Vendor Setup-eCommerce.

Assign One Claim Number per Sales Invoice?

This option is valid only if you include Vendor on Sale rebates on the report.

Select No to generate one claim number for all sales invoices per vendor.

Select Yes to generate one claim number per sales invoice. When you select Yes, the contract sorting option specified in the Sort Contract by C)ust#, S)hipTo or N)either field is ignored.

Set Zero Value Rebates to Reconciled?

Select Yes to change the status of zero value rebates to Reconciled when a claim number is assigned to the rebate. The status of a claim header for zero dollars is changed to inactive.

Resubmittal?

Select No if the rebate claim is an initial request. Select Yes if the rebate claim was previously sent to the vendor.

Submitted By

The user name of the person submitting the report. Contact information from the user's operator record is included XML and ION output only.

If these conditions are met, the user name is validated against SA Operator Setup and Sales Rep Setup records:

  1. Yes is selected for Print eCommerce data Where Appropriate?.
  2. V is selected for (V)endor or (C)ustomer Rebates.
  3. S or B is selected for (P)urchase, (S)ale or (B)oth.

If the user is invalid, an error occurs and the report processing stops.

Sort Contract by C)ust#, S)hipTo, D)iv, or N)one

This option is valid for vendor rebates only.

If contract information is provided on a rebate claim, you can sort the claims per contract by customer or ship to number. Specify one of these values:

  • C: Sort claims for each contract by customer
  • S: Sort claims for each contract by customer and then ship to
  • D: Sort claims for each contract by division
  • N: Sort claim for each contract by claim number
If you select Yes in the Assign One Claim Number per Sales Invoice? field, this contract sorting setting is ignored and one invoice is created per claim.
Sort by Warehouse?

This option is valid for vendor rebates only.

Select Yes to sort the claims by warehouse, vendor, and then contract. Select No to sort by vendor and then contract.

0 $ Rebates: E)xclude, (IM)=0, (IN)=0, (IA)ll=0, (IS)

Use this option to include Vendor on Sales rebates with zero $ rebate amounts in the SM Rebate Report. Depending on the value that you specify, you can exclude or include the actual selling price, based on rebate type.

Specify one of these values:

  • E: Excludes zero $ rebates.
  • IM: Includes all zero $ rebates and the actual selling price for the rebate transactions that are not manual rebates. Excludes the actual selling price for manual rebate transactions.
  • IN: Includes all zero $ rebates and the actual selling price for the manual rebate transactions. Excludes the actual selling price for rebate transactions that are not manual rebate transactions.
  • IA: Includes all zero $ rebates but excludes the actual selling price for all rebate transactions.
  • IS: Includes all zero $ rebates and the actual selling price for all rebate transactions.
Note: This option is independent of the Set Zero Value Rebates to Reconciled? option.