Skip to Content
avatar image
Former Member

Rebate settelment

When trying to do Final settlement - automatic

Error Message: no item category available (table T184 zb1 zpmx)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 15, 2011 at 03:30 PM

    Hi,

    Check the below settings required for Rebates

    A rebate is a trade allowance, which is going to be paid retroactively to customers based on their accumulated sales

    on sales volume over a defined period.

    Rebate agreement types:

    0001 = Group rebate

    0002 = Material rebate

    0003 = Customer rebate

    0004 = Hierarchy rebate

    0005 = Independent of sales volume

    The rebate agreement has a separate condition record for each product that customer buys. These condition records

    specify the rebate amount or percentage. Due to the customer for each product with sale a rebate agreement is

    finally settled when a credit memo is issued to the customer for accumulated rebate total.

    Define rebate agreement types: Transaction code: VB(2

    Path:

    IMG

    Sales and distribution

    Billing

    Rebate processing

    Rebate agreements

    Define agreement types

    Define agreement types

    Choose material rebate agreement type 0002 from position button

    Click on details icon

    Agreement [0002] = Material Rebate

    Proposed valid u2013 from [3] = First day of year

    Proposed valid u2013 to [2] = End of the current year

    Here we define the rebate agreement valid period. Usually rebate agreement valid for one year.

    Payment method []: Here we specify the payment method for rebate settlement.

    Ex: Cash, Cheque, DD, etc.

    Default status []: It specify the status of the rebate agreement like:

    Settlement is being checked for release

    Released for settlement

    Settlement has been created

    Final settlement already created

    341

    Condition type group [0002] = Material

    It specifies a grouping of condition types and condition tables for use during rebate processing. Generally one

    condition type assign to this agreement type.

    Use: As a rule, the condition type group consists of only our rebate condition type. However if your rebate

    processing requires it, you have the following possibilities:

    - You can assign more than one condition type to a group

    -You can enter the save condition type in a group more than once and use different condition

    tables, or key combinations, for each instance.

    Verification levels [F] = Display totals by Payer/Material

    It determines the level of the detail, one see when displaying total for a rebate agreement.

    [] Different validity period: Rebate agreement and condition record have same validity. It indicates rebate

    agreement and condition record of the same validity periods or not.

    Manual accruals order type [R4] = Rebate request for manual accruals

    It is a sales document type assigned to the rebate agreement and used in the manual accruals in a rebate agreement.

    [] Manual accruals: It enables manual accruals. Activate this field if you want to be able to post manual accruals

    for this agreement type.

    Arrangement calendar []: Assign calendar for rebate agreement. The arrangement calendar defines the end of the

    validity period of rebate arrangements and controls their extension.

    Payment procedure [A] = Payment allowed up to the accruals value

    When we allow manual payment of the rebate to the recipient we indicate that system has to create credit memo

    request of the type specified in the partial settlement field for the specified amount then when the system carries out

    final settlement system takes into account the amount that business paid and remaining amount is going to be paid.

    SAP uses partial settlement document type R3 and associated order related billing type is B3.

    Partial settlement [R3] = Partial rebate settlement request

    It specifies the sales document type, which should be used when you perform partial settlement for an agreement.

    SAP uses partial settlement document type R3.

    [] Reverse accruals: It ensures the system that it has to reverse the accruals up to the amount specified in the

    manual payment. Should the accruals not be as high as the payment to be made the system will reverse whatever

    accruals it has.

    342

    Settlement periods []: The settlement periods define that periodic partial settlement is to be carried out for a rebate

    agreement. This can be carried out at the relevant settlement dates.

    Use: Rebate agreements with settlement periods are used in rebate agreements for which a certain, regular amount

    is to be paid according to the payment procedure. Only the revenue up to the relevant settlement date is taken into

    account for the partial settlement.

    Final settlement [B1] = Rebate credit memo request

    For final settlement system proposes credit memo request type B1.

    Correction [B2] = Rebate correction request

    Rebate correction request document type B2 has been assign. System proposes this document type for rebate

    corrections that has been taken place in the settlement.

    Minimum status <b> = Agreement released for settlement

    We have to specify the rebate agreement document type [0002] for settling the rebates. It specifies the minimum

    status that a rebate agreement must have before the settlement can be calculated. During the processing of a final

    settlement, the system checks whether the rebate agreement is assigned the minimum status.

    Ex: B u2013 Agreement released for settlement

    C u2013 Credit memo request already created for settlement

    D u2013 Final settlement of agreement already carried out

    Text determination procedure []: It determines the sequence in which the text types appear in the document.

    Text ID: It specifies which text ID appears in text edits control. The text ID defines the different types fo texts that

    belong to a text object.

    Save and Exit

    343

    Configuration settings:

    Pre u2013 Requisites: So as to process rebates the main 3 control parameters are:

    - At definition of sales organization

    - At customer master payer

    - At definition of billing document

    Should be activating in this 3 places.

    Create condition record rebate agreements: Transaction code: VB01

    Path:

    - Logistics

    Sales and distribution

    Master data

    Rebate arrangements

    Rebate arrangement

    VB01 u2013 Create

    Specify agreement type 0002 and press ENTER

    Specify the rebate recipient [Customer master payer number]

    Specify the validity period of the agreement

    Specify the agreement status: Blank [] = Open

    344

    Specify the verification level [F] = Display totals by Payer/Material

    Click on conditions

    Specify the material number

    Select condition line item

    Click on scales and maintain the scales

    Save it and exit

    Go to V/08 and choose our pricing procedure from position button

    Include the rebate condition type B002 in between the discount

    Specify the requirement as 24

    Assign ERB as accounting key ERU as accruals

    Save and Exit

    Go to VA01 VL01N VF01

    Select line item

    Go to  Item Item conditions

    Check rebate condition type BO02 has been activated or not

    Save and Exit

    Like this raise another VA01  VL01N  VF01 and note down all document numbers.

    Display the rebate agreement

    Go to VB02

    Specify the rebate agreement number and press ENTER

    Note down the ERROR

    ERROR: The sales volume for agreement <111> is not current

    FB03 to see the document overview

    Exit

    Then go to:

    Logistics

    Sales and distribution

    Billing

    Rebates

    Update billing document

    In order to execute a report specify SDBONT06 in SE38

    Then accruals and business volume are updated when the accounting document for billing is created.

    Setting the rebates: For partial settlement

    Go to VB02

    Enter rebate agreement number

    Change agreement status field as B

    Choose create manual accruals and enter the amount to be paid

    Save and Exit

    Note down the credit memo request automatically by going to VB03

    Enter agreement number

     Choose rebate payment  Rebate document  Select partial settlement

    345

    Click choose button and note down the credit memo request number

    Now go to create credit memo with reference to credit memo request

    Now release the credit memo to the accounting [If it was blocked]

    Logistics

    Sales and distribution

    Billing

    Billing document

    Change

    Enter billing document number to release to accounting

    Now check accruals in rebate agreement by going to VB03

    Enter agreement number

    Choose conditions

    Select condition line item

    Choose payment details

    Steps for Rebate process:

    (1) Create sales document type R3, R4, B1, and B2 [VOV8]

    (2) Item category B1N [VOV7]

    (3) Define rebate agreement type 0002 [VB(2]

    (4) Define condition type group [VB(3]

    (5) Assign condition type/tables to condition type group [VB(4]

    (6) Assign condition type groups to rebate agreement type [VB(5]

    (7) Activate account determination [VKOA]

    (8) Activate rebate with reference to billing document [OVB0]

    (9) Activate rebate with reference to sales organization [OVB1]

    (10) Activate rebate with reference to payer master record [XD02]

    (11) Maintain relevant rebate condition types in pricing procedure [V/08]

    (12) Assign sales document to sales [OVAZ]

    (13) Maintain condition record for rebate agreements [VB01]

    Regards,

    Siva

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Vaibhav,

      When you settle the rebate agreement system creates credit memo request in backgroud, In that credit memo Material for rebate settlement (which you would have maintained while creating agreement) is used for creating credit memo request.

      This error is about item category determination in VOV4.

      I think ZB1 is your credit memo request type and ZPMX is item category group of material used for settlement.

      in T code VOV4 maintain the item category for combination of ZB1 and ZPMX.

      Then your problem will be resolved

      Regards

      Mayank

  • Jul 15, 2011 at 08:24 AM

    Hi,

    Please check the following-

    1. Item category determination- IMG-SD-Sales- Sales doc item-assign item categories

    2. Maintain item category group in Material master view in sales org 2

    Hope this helps,

    Regards,

    Randhir

    Add comment
    10|10000 characters needed characters exceeded