Skip to Content
0

Mid month convention (US) for old company codes

Apr 30 at 02:06 PM

50

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bernhard Kirchner
May 02 at 06:15 AM
0

Hi,

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

best regards

Bernhard

Show 1 Share
10 |10000 characters needed characters left 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

0
Jayesh Narwaney
May 02 at 03:20 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0