cancel
Showing results for 
Search instead for 
Did you mean: 

Rebate settelment

Former Member
0 Kudos

When trying to do Final settlement - automatic

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank for your prompt response.

but i want to settle rebate automatically.

and i am getting this error Error Message: no item category available (table T184 zb1 zpmx)

what is the exact reason for this error massage.

it not allow me to settle the agreement.

former_member365422
Contributor
0 Kudos

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

Answers (1)

Answers (1)

randhir_mishra
Participant
0 Kudos

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