Balance transfer

[Former Member]

Dear Experts,

For balance transfer I have created 5 conversion accounts ( GL conversion,Customer Conversion ,Vendor Convrsion,Stock conversion and Asset Conversion accounts).

Now can anyone please tell me how I will do the balance transfer - What accounting entry in SAP and How:?

Suppose my Balance is below:-

Customer= 1000000

Vendor= 2000000

Asset= 3000000

Stock=1000000

GL=3000000(Debit)

GL=4000000(credit)

I need the suggession, please right answer will be appreciated and get points.

[Former Member]

Narasimhulu's dubt are correct.

If you need to migrate data from non sap system, you can use LSMW (application and transaction) or ECatt (T-code: secatt ) .

Migrating sap -2- sap you can use data migraton workbench.  in order to create a have to migrate

[narasimhulu_konnipati]

Balance transfer means balance carry forward to next year or migration from non-SAP to SAP?

If it is non-SAP to SAP, create one initial balance transfer / upload account for each account type and do it.

If it is balance carry forward, use F-07 and transfer them.

Thanks,

[former_member198032]

Hi,

I am not sure but maybe this documentation can be helpful for you.

http://help.sap.com/saphelp_banking80/helpdata/en/b5/033f4626904ce2b82fc747649a9daa/content.htm

Regards,

Cristiano

[madhusoodanan_ramachandra]

Hi Mridula,

There is an error in your example.  Always trial balance should be tallied.

I've made changed to vendor balance to make total debit - credit = 0.

Customer  1,000,000.00

Vendor     (4,000,000.00)

Asset        3,000,000.00

APC - Accumulated depreciation (4,000,000.00 - 1,000,000.00)

Stock        1,000,000.00

GL             3,000,000.00

GL            (4,000,000.00)

Journal entries would be as below...

Description	Debit	Credit
Customer	1,000,000.00
Customer Conversion Account		1,000,000.00
Vendor		4,000,000.00
Vendor Conversion Account	4,000,000.00
Asset APC	4,000,000.00
Asset Accumulated Depreciation		1,000,000.00
Asset Conversion Account		3,000,000.00
Stock	1,000,000.00
Stock conversion Account		1,000,000.00
GL	3,000,000.00
GL		4,000,000.00
GL Conversion Account	1,000,000.00
Final Entry
Customer Conversion Account	1,000,000.00
Vendor Conversion Account		4,000,000.00
Asset Conversion Account	3,000,000.00
Stock conversion Account	1,000,000.00
GL Conversion Account		1,000,000.00

You need not post any entry manually to stock.  When initial stock upload is done from MM side, the system will automatically post stock related entry.

Hope this clarifies your doubt.

Best Regards,

Madhu

Excuse Typos, if any.....

[Former Member]

Hi Madhu,

Your answer is really helpful, but one confusion how the final entry to be posted, through F-02?

How system will react because Customer and Vendor, asset are Recon account not directly posted, please help more

thanks

mridula

[madhusoodanan_ramachandra]

Hi Mridula,

Yes.  You can post the final entry through FB01 / F-02.  The end result is, all the conversion account balance will be zero.

Best Regards,

Madhu

[Former Member]

Hi Madhu,

It is done, thanks a lot

[Former Member]

Hi Madhu,

Can you give me some input as below?

I am doing accounts mapping in ECC 6.0 version with new GL accounting. Now my scenario is my two company codes one is in Uganda another in Kenya. I have created one Common chart of accounts for the client at Chart of accounts level then assigned it to both the company codes. Remeber my company codes are in two country.  But when I assigned the Common chart of accounts to the company codes system is automatically taking the different currency and posting period.

Now can you have any idea is there any need to create Group chart of account? if yes, then why?

I will appreciate your reply/suggesstion.

mridula

[madhusoodanan_ramachandra]

Hi Mridula,

Normally, global company codes parameters are assigned to leading ledger and region specific parameters are assigned to non-leading ledger.  I'm not sure why common COA and group COA are discussed here.  The purpose of group COA is more for global consolidation and reporting.

Your question needs a detailed analysis of the design and then prepare adequate cut over plan.

Best Regards,

Madhu