Royalty Calculation in SD Billing
We have a scenario to calculate Royalty in the Billing document where the base value of the Royalty on which a percentage needs to be applied is on the entire months Billing value of a Condition Type say PR00.
Business has two or four Billing Cycles in a month (fortnightly and weekly) where only the end of month Billing needs to calculate Royalty for the total value of PR00 in the entire month. I have tried this through Condition base value where I am populating the PR00 value in subtotal KOMP-KZWI3 and putting a condition base value against Royalty calculation but I am unable to read the PR00 value for the previous Billing documents for the entire month.
The selection criteria to search for the entire month for such Billing is Billing type; Billing Date and the Payer.
Kindly suggest a Userexit where I can read the previous months Billing value of PR00 Condition or the VOFM Routine.
We will restrict the Royalty condition type only for the end of month Billing through a Requirment Routine.
Please help and provide your valuable suggestion on the above.