Opening Balances import

anilkumar

hi Experts,

Can anyone give any document on how to enter the opening balances of Detors/Creditors, Bank opening balances/ fixed assets opening entries in Navision 4.00

Thank you for your cooperation.

ssingla

All the balances will be imported using Gen. Journal Lines. Search the forum there are many topics on this.

Search is your best friend.

darshanm

you have to use the dataports for that purpose.

you should know all the related tables for that purpose.

e.g Detors : cust. ledger entry table, detailed cust. ledger entry table
and respective G/L account.

prepare your data in excel sheet. save the excel sheet in .CSV OR
text format

ssingla

you should know all the related tables for that purpose.

e.g Detors : cust. ledger entry table, detailed cust. ledger entry table

:-k

gete

ssingla wrote:

:-k

some part correct & some part wrong

David_Singleton

Alex Chow is writing some great blogs on this topic, I suggest you read them. They are very easy to understand.

http://dynamicsuser.net/blogs/alexchow/archive/2009/07/24/entering-beginning-balance-for-dynamics-nav-navision-for-a-new-implementation.aspx

kapil4dynamics

darshanm wrote:

you have to use the dataports for that purpose. you should know all the related tables for that purpose.e.g Detors : cust. ledger entry table, detailed cust. ledger entry table

What these r used for when it comes to opening. Can u explain, if u can't ,remove it (means edit) from the post as it can be misleading for any first timer. Pls don't take it otherwise.

Alex_Chow

anilkumar wrote:

hi Experts,

Can anyone give any document on how to enter the opening balances of Detors/Creditors, Bank opening balances/ fixed assets opening entries in Navision 4.00

Thank you for your cooperation.

If you still can't figure it out after searching on this forum or on Google, you should find another job.