Skip to Content

Mid month convention (US) for old company codes

Hi All

I have few US company codes which requires tax depreciation to start at mid month convention.

At configuration level I have taken period control method as 03/03/03/03.However still it is from period start not mid period.

At 'Use of Half Months in the Company Code' mid month column is blank & I m not able to add anything. I know there is one more way by creating 12 different depreciation keys for 12 different months. But that will be confusing for the users as they have to change depreciation key for different month each time.

Any other way to do it automatically through single depreciation key?

Regards

Pankaj

ghght.png (21.5 kB)
mgcl7.png (28.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 02 at 06:15 AM

    Hi,

    can you please check if table T093C-MONMIT = 15 (half periods)?

    best regards

    Bernhard

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Bernhard

      It is blank. I just did more analysis & found 3 ways-

      a) To populate 'Use of Half Months in the Company Code' field with fixed date as per SAP Note 39416. This doesn't seems to work for us as our company code has been used since more than 5-7 years & it already has data. I read in one of the post that even SAP cannot help on this.

      b) Use 24 periods for tax depreciation & run RACORR10 as per SAP Note 39416. However this will be confusing for users as this will double useful period & expiry periods for all the assets even those which are working for on the basis mid year convention which is working correctly for us.

      c) The third option can be creating 12 different depreciation keys for each of 12 months as the depreciation difference is in 1st & last year (39 years useful life) in our case.I tested this with January & it worked. However the issue now is I want to automatically substitute newly created depreciation according to month. For example-If the acquisition is in January then depreciation key Z001 is automatically assigned once we create asset.If the acquisition is in February then depreciation key Z002 is automatically assigned once we create asset. This is not possible with Tcode-OAYZ as we will have different depreciation keys. I wrote a substitution rule but it didn't worked.

      Prerequisite-

      ANLB-BUKRS = 'US01' AND SYST-TCODE = 'ABZON' OR SYST-TCODE
      = 'AS01' AND ANLA-ANLKL = '1100' AND ANLB-AFABE = '10' AND
      ANLB-VMNTH = '001'

      Substitution-

      Dep. key Constant value Z001

      Not sure of any other option? Pls advice.

      Regards

      Pankaj

  • May 02 at 03:20 PM

    Hi,

    There are two options:

    Option 1 - As mentioned by Bernhard above, you need the company code to use half periods, then it would use your configuration.

    Option 2 - Use an Alternative Fiscal Year Variant for tax areas with 24 periods if you are using 12 periods in General Ledger, with same start and end dates (example: If you are using K4 in General Ledger, use 24 for tax areas).

    Best Regards,

    Jayesh

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jayesh

      Thanks for the information. Option-1 doesn't works me & gives me an error since I have data in my company codes. Option-2 works for me but the company doesn't wants to convert periods to 24 months. Moreover it will even impact mid year convention assets during conversion of 12 to 24 months. Option-3 as mentioned in my previous reply works for us but the only issue is I m not able to write substitution rule.

      Pls advice.

      Regards

      Pankaj