Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Dec 4 at 3:23 PM Your project needs to develop load programs for each of the items in question. You can use BAPI's to do most of the loads, but you basically must run it through the system as if someone typed it in. You cannot do direct loads to tables - you will not allow the system to hit all the tables it needs to.
So if you need G/L transactions, develop a program to read a flat file, translate it as needed for G/L accounts, cost/profit centers, etc., and run the custom program to read the file and post the entries. Same for A/P and A/R transactions.
As for balance sheet accounts, you make a journal entry to the prior period and roll it forward for the new year. So if the client wants balances of 2011 and transaction level for 2012, you must post a journal entry for each account to 2011 so that you can roll it forward to 2012. From there, the transactions you post will create the balance sheet properly.
- Lou
| | | ---------------Original Message---------------
From: RAMHIM
Sent: Tuesday, December 04, 2012 1:46 PM
Subject: Legacy Data Transfer from Tally to SAP
Hello experts,
I have to transfer legacy transactional data from Tally to SAP. In FI below transactional data to transfered.
For G/L accounts balance Transactinal data
For Vendor open item data Transactinal data
For Customer open item Transactinal data & For Investment orders.
Please clarify my below doubts:-
All the G/L balance mens only balance of Balance sheet items and P/L items to be transfered into SAP? Please confrim if my understanding is right. for this
There are various types of taxes in Trail balances which are booked against various vendors and business wants them in detailed line item wise as it was showing in trail balance.
Business wants all the advances like advance to staff, Deposites and other similar items in SAP as it is displaying in trail balance. In trail balance it showing in detail. lExample Advaces to staff 10000.which further bifurcated in 1000 to A, 5000 to B and 4000 to C.
Advances payment receieved displaying in detail. example Advances 5000 which is futher distributed in 2000 from customer A and 3000 from customer B.
When we transfer all the Advaces, taxes & other balance sheet items as is balance in G/L against the G/L clearing account and at the same will be transfered in SAP with vendor line item with Vendor clearing account.
Please give me the detailed clarification.
Thank you in advance. |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
