Friday, August 15, 2008

Setup FI Fiscal Year Period FICO Periods

The client wants fiscal year to be set from May 1 – April 30 but they use a 4,4,5 accounting period setup meaning that every month end on the last Friday of the month. I am setting for 2006-2007. As you know, the FYV should be year dependent, so how can the periods be set up.

In IMG go to financial accounting global setting then go to fiscal year variant and set the fiscal year variant on year dependent year and follow the following procedure:

1. enter name of month started from may and end on april
2. enter the number of days in a month you want to close for example in may number of days is 28 instead of 31
3. enter period from 01 to 12 started from may to april
4. enter -1 against the month from jan to april

For Example :

Month Number of Days Period Year Shift
May06 28 01 0
June 35 02 0
July 28 03 0
Aug 28 04 0
Sep 35 05 0
Oct 28 06 0
Nov 28 07 0
Dec 35 08 0
Jan07 28 09 -1
Feb 28 10 -1
Mar 35 11 -1
Apr 31 12 -1

Check List for FI Year End Closing FICO Periods

1 Execute Report for InterCompany Activity & Journal Entries
2 Open posting period for next yr
3 Run Business Area's Assignment report.
4 Review list of recurring journal entries
5 Execute Recurring Entries for A/R, A/P, G/L
6 Process Parked A/R, A/P, G/L accounting documents
7 Final Cutoff for the Maintenance of Fixed Asset- Add Transfer and Retire
8 Run Depreciation in Test Run and post
9 Verify Display Log for Depreciation Test Run
10 Capitalize AUC Assets if needed
11 Enter Payroll Data to SAP
12 Verify Depreciation Balances with GL balances
13 Post Depreciation
14 Execute Asset History Report, and retire assets if needed
15 Adjust specific depreciation areas if necessary
16 Reconcile AM subledger with GL
17 Check Bank Data
18 Review AR Open Items
19 Review AP Open Items
20 Execute Pending Invoices
21 Clear Open Item for GRIR, freight
22 Reconciliation of Financial Documents and transactional figures
23 Open new CO Posting Period
24 Compare current (cost estimates) with last current price (Moving Avg)
25 Update current cost price to material master price field.
26 Process Freight charges, Match SD freight to actual
27 Review Internal Order Postings
28 Settle All Orders
29 Verify All Post Goods Issue have been Invoiced (Billing Due List)
30 Review SD Billng Doc from prior mth that have not yet been released to accounting
31 Reconciliation of MM movements in Transit Intra-SAP to NonSAP
32 Reconcile PI Inventory with SAP
33 Perform Manual Adjustment if needed
34 Verify balance of the GR/IR account
35 Post Accruals and Deferrals
36 Clearing of Cancelled Documents
37 Check Profitability Segment Adjustment
38 Aging Report-Reconcile GL balances with subledger balances AP
39 Check the check run numbers
40 Bank reconciliation Data
41 Enter Tax Journal Entry
42 Reconcile GL balances with subledger balances AR/MM/AP
43 Display Balance Sheet Adjustments
44 Post Balance Sheet Adjustments
45 Post Foreign Currency Valuation (foreign exchange)
46 Check generic cost centers for posting with wrong accounts
47 Correct wrong postings on generic cost centers
48 Check Validation dates for Cost Centers, Cost Elements, CO area
49 Check COGI--for both month end and year end
50 Doubtful receiviables
51 Verify In-transist Inventory
52 Reconcile PA to G/L
53 Post Cost Centre Assessments and Distributions
54 Run CO-FI Reconciliation to balance
55 Run BW reports P&L and Balance Sheet
56 Maintain CO yr variant
57 Fiscal Yr Balance carryforward AP/AR/AM
58 Fiscal Yr Balance carryforward CO
59 Fiscal Yr balance carryforward FI
60 Fiscal Yr balance carryforward PCA
61 Set Document number ranges - FI - new year
62 Set Document number ranges AP/AR - new year
63 Generate Financial statement Reports
64 Change Fiscal Year For Assets
65 Year end Closing-- Asset Accounting--final for year end
66 Close CO Posting Period
67 Close Prior A/R Posting Period
68 Close Prior A/P Posting Period
69 Close Prior MM Posting Period
70 Reverse accruals and deferrals for the new month
71 Reconciliation of Financial Documents from old fiscal year and new fiscal year
72 Load Balances, Budget Data for Cost centers, sales
73 Update Retained Earning Account , balance carry fwd

Is There an Automatic Program for MMPV FICO Periods

The client I am working with has an outdated training client. The current posting period right now is November 2004. I have two questions:

1. Does anyone know of a shortcut to get the current posting period updated versus opening each month from Nov. '04 until today.

2. Is there an automatic program that can be set up to change to current period without having to go in manually every month to initiate MMPV.

In IMG, you can go to Logistics - General => Material Master => Basic Settings => Maintain Company Codes for Materials Management. You can then enter the periods that you need to have open.

As far as running something monthly, if you are working only in one general region of the world, you can run program RMMMPERI from SE38 at 00:01:00 on day 1 of each period. You'll need to create a selection variant with a variable to tell it which period to use.

We run into problems with MMPV/RMMMPERI, and have to actually manually schedule it each month. I run it three times - one to open the periods for our Asian plants (at 09:00:00 my time, on the last day of my month), one to open periods for our European plants (at 16:00:00 my time, on the last day of my month), and one to open periods for our US plants (at 00:01:00 my time, on the first day of my month). I've not been able to schedule recurring jobs for the Asian and European plants, because I can't figure out a way to set up a recurrence for the last day of the month. I can do it on day 1, or day 28, or something specific like that, but since the last day of the month can fall on day 28, 30, or 31, I'm not able to do that.

Variants in OB52 to use Multiple Time Zones FICO Periods

Is there anyway to configure the posting periods variants in OB52 to use multiple time zones? For example, if the US is one company code can multiple variants be setup for the different time zones?


In T-code OBBO you can create, if you are need, for every company code a posting period variant which must assign to company code - T-code OBBP. With OB52 you can determine for every posting period variant a posting period for every account type (A,S,D,K,M and +).

Important: In FI it is possibile only two period ranges have to be open at the same time, during of the closing procedure, one for posting period of fiscal year (1-12) and one for special posting period (13-16).

If my answer it is not sufficient, please give me a example for what you want to say with "to use multiple time zones".

Emilia

The Last column in OB52 Screen for authorisation group.
I think this field can be effectively to restrict the posting by different users situated in different time zones. Of course if a user is travelling from one time zone to other, this option may not work unless authorisation group in his user Id is changed.

Allowed OB52 based on company code FICO Periods

If you have several company codes and want your users only to be able to open and close periods
(transaction OB52) belonging to their posting period variant (=company code).

First you configure the Posting Variant :-

1) FI- FI Global Settings - Document - Posting Periods - Define Variants for Posting Periods

2) FI- FI Global Settings - Document - Posting Periods - Assign Variants to Company Code

Second Step:-

Goto SE11 copy the view V_T001B to ZV_T001B_000X (000X indicate the Posting Variant)

In Change mode, tabstrips Selection Conditions Insert line 2 with

Table Field Name Operator Comparative Value AND/OR
T001B BUKRS EQ '000X' AND

Save your entries

Third Step :-

Goto SE54, Options Generated Objects -> Create

Authorizations Group FC31
Function Group Z00F0
Maintenance Type One Type
Overview Screen 65
Single Screen 0

Final Step :-

Goto SE93, Create a new transaction code ZOB52_000X

Start object - Transaction with parameters (parameter transaction)

Transaction SM30, Tick Skip initial screen

Name of screen field Value
VIEWNAME ZV_T001B_000X
UPDATE X

Save your entries.

Now, test your new transaction code ZOB52_000X which will only display the
Posting Variant that you have define in your table view.

Allowed OB52 based on company code

If you have several company codes and want your users only to be able to open and close periods
(transaction OB52) belonging to their posting period variant (=company code).

First you configure the Posting Variant :-

1) FI- FI Global Settings - Document - Posting Periods - Define Variants for Posting Periods

2) FI- FI Global Settings - Document - Posting Periods - Assign Variants to Company Code

Second Step:-

Goto SE11 copy the view V_T001B to ZV_T001B_000X (000X indicate the Posting Variant)

In Change mode, tabstrips Selection Conditions Insert line 2 with

Table Field Name Operator Comparative Value AND/OR
T001B BUKRS EQ '000X' AND

Save your entries

Third Step :-

Goto SE54, Options Generated Objects -> Create

Authorizations Group FC31
Function Group Z00F0
Maintenance Type One Type
Overview Screen 65
Single Screen 0

Final Step :-

Goto SE93, Create a new transaction code ZOB52_000X

Start object - Transaction with parameters (parameter transaction)

Transaction SM30, Tick Skip initial screen

Name of screen field Value
VIEWNAME ZV_T001B_000X
UPDATE X

Save your entries.

Now, test your new transaction code ZOB52_000X which will only display the
Posting Variant that you have define in your table view.