hi I am using Navison Financials-2.60. My fiscal year starts from April 1st. I am not able to decide how to post he opening balances from the last fiscal year ie before 31st march. I am thinking of importing the data by a dataport in the g/l Entry Table.The opening balances of customers will go in the customer ledger entry table also. So i am importing the same amount in he General Ledger as well in the customer ledger. I want to know that is this the right way to feed the opening balances . Is there any other suitable way to do the same???.I will like to know the other possible ways to feed the opening balances. Do the opening balance entries are also created in the respective registers. Thanks Ritesh
quote:
Originally posted by ritesh_lko
hi I am using Navison Financials-2.60. My fiscal year starts from April 1st. I am not able to decide how to post he opening balances from the last fiscal year ie before 31st march. I am thinking of importing the data by a dataport in the g/l Entry Table.The opening balances of customers will go in the customer ledger entry table also. So i am importing the same amount in he General Ledger as well in the customer ledger. I want to know that is this the right way to feed the opening balances . Is there any other suitable way to do the same???.I will like to know the other possible ways to feed the opening balances. Do the opening balance entries are also created in the respective registers. Thanks Ritesh
You might feed Table 81 with G/L, Customers and Vendors entries and use the standard Post function. Just remember to leave all the Posting Groups blank. Anna
We did a dataport into the Sales Journal and let Navision do the posting. If you enter a Balancing Account that is the same as the Sales account for the customer you will get a debit and a credit to the Sales GL account resulting in a net of 0. The Customer Ledger will be updated correctly and your G/L will be in balance (assuming you’ve imported your GL balances separately). Django