on 04-19-2009 5:54 AM
Hi all,
anyone know how to config rounding mechanism just only apply in service charge settlement (SCS) and sales based rent?
Thanks your help in advance.
udin
Edited by: Muhd Mahyuddin Zakaria on Apr 20, 2009 10:07 AM
Hi Zakaria ,
Please see OSS Note 1165950 - Malaysia: Rounding Mechanism
Define Rounding Rules for MYR
Transaction OB90 or View V_T001R
Insert entries for the corresponding company code(s) and the currency MYR. Enter '5' in the rounding unit column.
See Note 2 on the impact of configuring V_T001R and the alternative solution if this entry is not wished.
2. Define condition type DIFF
Transaction V/06
Assign the following attributes:
Condition Class A Discount or Surcharge
Calculation Type B Fixed Amount
Condition Category L Generally new when copying
Group Condition X
Manual Entries D Not possible to process manually
Item Condition X
3. Include the condition type DIFF in the pricing procedure for Malaysia
Transaction V/08
Insert DIFF after the tax condition, with the following settings:
Requirement 013 Rounding as perT001R
Value formula 016 Rounding the total
Base formula 004 Net Value + Total
From - to empty
Statistics empty
Example
A document with 3 line items.
The results before condition DIFF
Item Net Value + Tax = Total
10 6.20 + 0.62 = 6.82 MYR
20 12.40 + 1.24 = 13.64 MYR
30 18.60 + 1.86 = 20.46 MYR
Header 37.20 + 3.72 = 40.92 MYR
Because of the total value of 40.92 MYR, the condition DIFF will have a value of 0.02- MYR on the header level. This will then be distributed to the 3 items as follows:
Item Net Value + Tax - DIFF = Total
10 6.20 + 0.62 + 0.00 = 6.82 MYR
20 12.40 + 1.24 - 0.01 = 13.63 MYR
30 18.60 + 1.86 - 0.01 = 20.45 MYR
Header 37.20 + 3.72 - 0.02 = 40.90 MYR
Note 1: Restricting the rounding for certain document types
If the rounding is only wished for certain type of documents only, create a copy the requirement 13 and add a check based on the document category, using the transaction VOFM. Assign this new requirement instead of the requirement 13 to condition DIFF.
For example: if the rounding is only wished for billing documents only, the following line of coding could be inserted as one possibility:
check: komk-vbtyp ca vbtyp_fakt.
Note 2: Impact on setting up rounding rules for currencies (V_T001R)
Adding an entry on this view for MYR, as mentioned in step 1, will have a cross application impact - e.g in Treasury and Real Estate, roundings will also take place for some calculation.
Therefore, if this impact is not wished, and the rounding is only required in SD, then do not create an entry for MYR in this view.
Without the entry in this view, the standard value formula 016 (as mentioned in step 3) cannot be used anymore. A new value formula is needed to replace this, e.g. value formula 916, with the following content:
form frm_kondi_wert_916.
check: t001r-waers = 'MYR'.
data: lc_rounding like t001r-reinh.
lc_rounding = 5.
xkwert = xkomv-kawrt * ( 1000 / lc_rounding ) / 1000 * lc_rounding.
xkwert = xkwert - xkomv-kawrt.
endform.
Assign this new value formula to condition DIFF and remove the requirement formula 013.
Thanks
Veman
Edited by: veman goli on Apr 20, 2009 5:25 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi veman,
Thanks for your response.
Q1: should I apply only note 1, 2 or both? if need to apply in RE only (without effect SD module)?
Q2: can you brief me more details Note 2: Impact on setting up rounding rules for currencies (V_T001R) how to create a new value formula (also menu path) and how to insert that coding into new value formula?
Thanks.
uddin
Edited by: Muhd Mahyuddin Zakaria on Apr 20, 2009 2:59 PM
Edited by: Muhd Mahyuddin Zakaria on Apr 20, 2009 3:04 PM
User | Count |
---|---|
12 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.