Creating Data in Value Entry

Dong_Giang
Member Posts: 2
Hi all,
I'm a newbie, want to ask for your instructions about data recording in Value Entry table:
The case is when I post a sales order (using expected cost).
The first time it created 2 records in the Value Entries when shipped only, it assigned the right Entry No. of the G/L Entries table in the G/L Entry No. (Interim Acc.) and G/L Entry No. (Int. Bal. Acc.)
Then I post the sales invoice, it create 4 records in the Value Entry, the first 2 records it assigned the right Entry No. of the G/L Entry table in the G/L Entry No. (Interim Acc.) and G/L Entry No. (Int. Bal. Acc.), to show the expected cost and the adjustment for the expected cost. The last record is also right, show the adjustment for the real cost.
The problem is the 3rd record, it asigned 4 Entry No.s of the G/L Entries table in the G/L Entry No. (Account) , G/L Entry No. (Bal. Account), G/L Entry No. (Interim Acc.), G/L Entry No. (Int. Bal. Acc.). But the assignment are not correct, example:
- In the G/L Entries table, it created 4 entries: 1, 2, 3, 4
- In the Value Entries table, it assign:
+ G/L Entry No. (Account) = 2
+ G/L Entry No. (Bal. Account) = 3
+ G/L Entry No. (Interim Acc.) = 3 <-- why not entry No 1 be assigned here??
+ G/L Entry No. (Int. Bal. Acc.) = 4
Is this the intention of Navision or there are some problem of my database?
Any idea will be appreciated.
Regards
I'm a newbie, want to ask for your instructions about data recording in Value Entry table:
The case is when I post a sales order (using expected cost).
The first time it created 2 records in the Value Entries when shipped only, it assigned the right Entry No. of the G/L Entries table in the G/L Entry No. (Interim Acc.) and G/L Entry No. (Int. Bal. Acc.)
Then I post the sales invoice, it create 4 records in the Value Entry, the first 2 records it assigned the right Entry No. of the G/L Entry table in the G/L Entry No. (Interim Acc.) and G/L Entry No. (Int. Bal. Acc.), to show the expected cost and the adjustment for the expected cost. The last record is also right, show the adjustment for the real cost.
The problem is the 3rd record, it asigned 4 Entry No.s of the G/L Entries table in the G/L Entry No. (Account) , G/L Entry No. (Bal. Account), G/L Entry No. (Interim Acc.), G/L Entry No. (Int. Bal. Acc.). But the assignment are not correct, example:
- In the G/L Entries table, it created 4 entries: 1, 2, 3, 4
- In the Value Entries table, it assign:
+ G/L Entry No. (Account) = 2
+ G/L Entry No. (Bal. Account) = 3
+ G/L Entry No. (Interim Acc.) = 3 <-- why not entry No 1 be assigned here??
+ G/L Entry No. (Int. Bal. Acc.) = 4
Is this the intention of Navision or there are some problem of my database?
Any idea will be appreciated.
Regards
GiangND
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