You’re offline. This is a read only version of the page.
1,710
Hello Friends!! Can someone suggest how could I include opening/beginning balance for bank accounts?? I have followed the link to understand but this seems like used in Navision 2009. Is it the same procedure for including in Navision v4.0 or I need to follow any other step and how?? It would be very helpful if someone gives an idea.
*This post is locked for comments
Do you have any bank account ledger entries for the selected Bank Account? Please open the Bank Account Ledger Entries form and check whether there are any ledger entries for the selected bank (the bank account selected in the Bank Account Reconciliation).
You may use General Ledger -> Periodic Activities -> Bank Account Reconciliations.
Alternatively, please use the below link:-
http://dynamicsuser.net/forums/p/65550/345925.aspx
Best Regards,
MMV
OK. Thanks for the reply. It is for Exim Bank I mean the opening balance but when I enter other bank accounts like Commercial, UCB Bank with opening balances in the same batch would not it create confliction?? And how could I access the BANK1 1 - Bank Rec. Worksheet in Navision v4.0?? Could you please suggest??
Hi,
Amount is in the Currency of the current transaction. If the Currency Code in the "Gen. Journal Line" (in the current line) is different from the LCY code in "General Ledger Setup", there could be difference in Amount and Amount (LCY) - (Amount in Local Currency)
You can post all the transactions in one batch; separate batches are not required.
The reason for the above error is:-
The Total of all the above Transactions will lead to 10000 (Debit). Each Journal Entry requires that the transaction amount totals to 0 (zero), i.e Debit and Credit must match. In your case, as it's the opening balance, you need to make one more line to enter the Opening Balance Control account (with a Credit of 10000).
Best Regards,
MMV
OK. I try to make it clear. When I put the actual amount in Navision's amount field first say 12,000 it then converts this amount to 155.84 in the Navision's amount (LCY) field - For The 2nd Picture. Why this happens?? And two more things: do I need to create separate Batches for each bank account BEGBAL1, BEGBAN2 and how could I access the following card or worksheet in Navision v4.0??
When I try to post it shows the following pop-up message:
Thanks a lot Friend. Worked.
i) I just had to write the amount in amount (LCY) field.
ii) But when I write the actual amount in Navision's amount field first it shows some another calculation. Like it is converting the amount and showing the total amount for picture 2.
There are two differences while putting the amounts: (May I know the difference??)
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
