File updating at receiving with rebates based on purchase

Purchase

• When Subtract Vendor Rebate from Cost is selected in SA Administrator Options-Sales History-Rebates/Basis, the rebate is anticipated in Purchase Receipt of Inventory Entry. It is based on the rebate record defined in PD Pricing Setup.

Sales Manager

• Multiple Sales Manager reports print an r to identify that a rebate is involved.
• All customer and vendor rebates print on the SM Rebate Report.

Product

• The posted inventory amount is decreased by the rebated amount if you capitalize rebates.
• If Subtract Vendor Rebate from Cost is selected in SA Administrator Options-Sales History-Rebates/Basis, the rebate is subtracted from the average cost in Product Maintain Balance Entry.
• If Last is selected in the Post to G/L by filed in SA Administrator Options-Product-Costs, the Last Cost in Product Maintain Balance Entry is calculated with the rebate removed.

• If these options are selected in SA Administrator Options, the rebate is subtracted from the last cost:

  • Use Last Cost During Entry is selected in Cost field in Documents-Purchase Orders-Entry Defaults
  • Last is selected for Post to S/M By and Post to G/L By in Product-Costs

  The last cost defaults to the line item in Purchase Order Entry from the previous receipt and is net of the rebate. If the same rebate is in effect, you might be subtracting the rebate twice.

• When the vendor is domestic, the alternate vendor information in Product Extended Product Cross Reference Setup is updated with the rebate removed. If the vendor is foreign, the cost is treated in the same manner as the Last Foreign cost in Product Maintain Balance Entry and the rebate is not removed from the displayed amount.
• If you receive a purchase order with a portion going into unavailable, the unavailable quantity in Product Maintain Balance Entry includes the rebate.
• If a tariff code exists on the Product Warehouse Product Setup record, the tariff is calculated at the cost before the rebate is removed. Because the Last Cost field in Product Maintain Balance Entry contains the tariff assessed on the last purchase, the new tariff is calculated and removed before the new rebate is calculated when rebates are calculated based on last cost.
• If you receive a substitute or supersede product for an item that has a rebate record defined in PD Pricing Setup, the rebate is re-evaluated. A rebate is applied if a rebate record is applicable to the substitute or supersede product.

General Ledger

• If you post to the General Ledger by replacement or standard cost, the rebate is calculated and stored as the Rebate Amount, which is included in the Other Line Item Information on the Purchase Master List Report. The posted cost remains as it is, and the rebate is not subtracted when posted to General Ledger.
• If you post to the General Ledger by average or last cost, the posted cost is reduced by the anticipated rebate if Subtract Vendor Rebate from Cost is selected in SA Administrator Options-Sales History-Rebates/Basis. The Rebate Amount included in the Other Line Item Information on the Purchase Master List Report, is stored as a domestic amount all price, and unit conversion is applied.

  For example, if 2 cases of 12 units are received, the rebate is for 24 units. If special units are involved, then the conversion is made on the unit. The cost is decreased by the rebate amount at receiving. The Rebates Due account is not posted until costing.