on 02-15-2011 10:35 AM
When trying to do Final settlement - automatic
Error Message: no item category available (table T184 zb1 zpmx)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.