FICO Data Conversions clarifications

[former_member862468]

Hi,

I am currently working on data conversion project. We have our FY from April to March and we are going live on June 01. I am trying to analyse the FICO objects. I have seen many conversations here but confused between balances and open items. I am trying to use ABAP programs instead of LSMW as much as possible

Master Data:

1) GL Master Data

2) AP Vendor Master Data

3) AR Customer Master Data

4) FA Master Data

5) Cost Centers

6) Profit Centers

Transaction Data:

Note that client wants to use only one offsetting conversion account instead of one account each for GL, AP, AR, FA etc

7) GL Balances

     what is the difference between balances and open items here and how do we post them (can i use f-02 for both) and document types?

     lets say i have GL 600100 which has a balance of $5000. If i want to post it during data conversion, should i post it as Dr 600100 Cr 700100 (this is a        offsetting account used only for conversion)

     how do you post an GL Open Items and what would be the accounting entries

😎 Vendor Balances

     what is the difference between Vendor balances and Vendor Open items.

     lets say if i have 10 invoices pending payment for a vendor 10000, is the posting to KR doc type as Cr 10000 (vendor) Dr 700100 (this is a offsetting account used only for conversion) correct?

9) Customer Balances

     what is the difference between Customer balances and Customer Open items.

     lets say if i have 10 invoices pending payment by a customer 80000, is the posting to DR doc type as Dr 80000 (Customer) Cr 700100 (this is a offsetting account used only for conversion) correct?

10) Historical Data

     If the client asks us to post data from April 1 until May 31, what is the best approach, also here we are circumventing few things such as

     If there is a GR is done but not Invoiced, then these will be just posted as regular invoices (KR) instead of PO - GR - IV sequence

     If there is Invoice (PO based ones) but not paid, then these will be considered as regular open invoices (KR) as above

     like wise for O2C invoices too

I am trying to understand if i missing anything and if i have to follow any sequence. Appreciate if you guys can help with an example and if if i am missing any objects here...

Thanks

Shriya

[former_member862468]

Thank you guys,

Ravi,

you said tax lines should be customer/vendor invoices...should we not skip them in the invoices as we have already accounted them in GL balances.

Also, since our FY closes end of March..our client is asking me to upload the balances for April and May month end. we are going live on June 04. what would be best approach. for May end GL balances, we are using f-02 transaction and posting it as a balance to each GL account.

Do we have to follow any particular sequence..

thanks for your help..

Shriya

[former_member182098]

Thanks for correcting me, I have updated now. Yes you should NOT put tax line on vendor / customer line items.

It does not really make any sense to load balances in Apr, as you are anyway going live in June, you can directly load May balances.

Do you have any bespoke program for journal upload? Otherwise, manually entering would be a huge task. Please ask your ABAPer to create a quick BDC for you.

Otherwise, follow this:

[former_member862468]

Thanks Ravi, we have an exisiting program to upload the GL balances and so we will be using them.

client wants to have balances from April as they want to see the balances each month end from the start of the FY.

what is the general scenario when clients do the conversion in the middle of the FY..

[former_member182098]

Normally they do not do every month, unless they are very specific for monthly financial movements like yours.

Exactly you do the same thing but, twice, it is the only difference. You load GL balances and open items at April End and again incremental financial movements at May.

Please note you only need to input incremental balances at May end, not the original balances, otherwise, they would be doubled with April + May. You should take care of this.

[Former Member]

Hi Shriya

For mid year data transfers, you can move the April balances and open items. All the May items you always have the option of some one from the client side posting themselves if they do not have many transactions. But, as Ravi said, you need to do only the delta balances just before Go-Live in June.

Regards

Sowmya

[former_member182098]

Follow this and use LSMW.

Refer this to understand the basic:

Regarding your questions: It does not matter whether you use single or five or six offsetting account. You should aware that at the end of the transfer your offsetting accounting balance should be zero.

You take trail balance (forget about the vendors / customers as you load them as open items)

All debit balances you debit in SAP and Credit the offsetting account. All credits you credit in SAP and debit offsetting account. Usually, GL open items would not be loaded, it is only balances. Open items are only for vendors and customers.

Note: You should NOT load tax line on the customer / vendor invoices, as they are already accounted for in the GL balances. Otherwise, your Migration account would never be zero.

For Assets, you need to load asset sub-ledger data separately through AS91 and GL balances separately. Use OAMK to set and reset the reconciliation accounts of assets. Once you loaded asset values, put them as reconciliation accounts and nobody should touch them.

You only load historical data line items of vendors or customers. You do  not post goods or invoices receipts again from MM. Mostly, what you can upload is open purchase orders.

Hope this helps.

Regards,

Ravi

[former_member222241]

Hi,

Please also check following :

1. Asset balances (Legacy Asset balances) Gross block and Depreciation.

2. Customer Down Payment.

3. Vendor Down Payment.

4. Asset balances (purchases).

5. G/L balances should include P & L as well as Balance sheet. In balance sheet only Open Items should be taken into consideration.

6. Bank balances (Main, Issue and Receipt).

7. Cash balances.

8. Balances in local as well as foreign currencies.

Regards,

Tejas