Balance Account for Recurring Journals

Kaetchen
Member Posts: 106
Hi,
I've setup a recurring jrnl for our monthly bank transactions. But when I try to post it the system displays an error message "Bal. Account No. cannot be specified when using recurring journals in Gen. Journal Line Journal Template Name='RECURRING'....
I wonder whether this is a setup problem or is it in general not possible?
It would be much easier only to enter the Account as you don't have to update the amount for the Balance Account, otherwise we have to create two lines.
Thanks,
Stefanie
I've setup a recurring jrnl for our monthly bank transactions. But when I try to post it the system displays an error message "Bal. Account No. cannot be specified when using recurring journals in Gen. Journal Line Journal Template Name='RECURRING'....
I wonder whether this is a setup problem or is it in general not possible?
It would be much easier only to enter the Account as you don't have to update the amount for the Balance Account, otherwise we have to create two lines.
Thanks,
Stefanie
0
Comments
-
Having the same problem and wishing it were an option to specify the balancing account.0
-
Looks like the solution is to use allocations. The allocations window will allow you to specify the balancing account (i.e. allocate the entry to 1 and only 1 G/L account). In Cronus I created a recurring vendor invoice (Account type Vendor, Account No. 20300190) and then gave a 100% allocaiton to a G/L account number. Posted fine.
Seems that the balancing accounts in the allocation window are limited to G/L Account number. You couldn't balance to a bank account if you wanted to. (we have a recurring journal from bank 1 to bank 2. So we could not use the allocations feature. We just need two recurring journal lines each of the same amount.) That would be a nice feature to be able to allocate to other account types besides G/L (if Microsoft is listening.)
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions