Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
"Item Ledger Entry" - Entries not the same than Item Journal
Alkro
Member Posts: 115
Hi, we have a problem and we can't find the source.
We have an temporary table where users fill in some data about items and quantities. Then, with a process, this lines goes to an Item Journal and Post it. In this Item Journal, we only put "Positive Adjmt." or "Sale".
This process, the idea is, user want to convert an item A to an item B, and the process must do a Sale with A and a Positive Adjt. with B.
Problem is that in any cases, when user complete a line with Item A, and -3 quantity (for example), when they post, in ILE Table, appear 3 entries, for example with:
1 -- Item A - Type: Sale - (-20 Quantity)
2 -- Item B - Type: Purchase - (-17 Quantity)
3 -- Item A - Type: Positive Adjtm. - (3 Quantity)
Strange is 1 & 2 because correct entries must be:
1 -- Item A - Type: Sale - (-3 Quantity)
2 -- Item A - Type: Positive Adjtm. - (3 Quantity)
or
1 -- Item A - Type: Sale - (-3 Quantity)
2 -- Item B - Type: Positive Adjtm. - (3 Quantity)
In C/AL code, we never put an "Purchase" Type.
Anybody knows why could be this "problem"?
BR
We have an temporary table where users fill in some data about items and quantities. Then, with a process, this lines goes to an Item Journal and Post it. In this Item Journal, we only put "Positive Adjmt." or "Sale".
This process, the idea is, user want to convert an item A to an item B, and the process must do a Sale with A and a Positive Adjt. with B.
Problem is that in any cases, when user complete a line with Item A, and -3 quantity (for example), when they post, in ILE Table, appear 3 entries, for example with:
1 -- Item A - Type: Sale - (-20 Quantity)
2 -- Item B - Type: Purchase - (-17 Quantity)
3 -- Item A - Type: Positive Adjtm. - (3 Quantity)
Strange is 1 & 2 because correct entries must be:
1 -- Item A - Type: Sale - (-3 Quantity)
2 -- Item A - Type: Positive Adjtm. - (3 Quantity)
or
1 -- Item A - Type: Sale - (-3 Quantity)
2 -- Item B - Type: Positive Adjtm. - (3 Quantity)
In C/AL code, we never put an "Purchase" Type.
Anybody knows why could be this "problem"?
BR
0
Comments
Rishi
Rishi