Purpose of the “Appl.-from Item Entry" field?

pdj
Member Posts: 643
(Using NAV4SP2)
I’m having some problems with Credit Memos and the closing of Item Ledger Entries.
The problem can be reproduced quite simple like this in the Cronus company:
1) Create a Purchase Credit Memo for 2 pieces of Item No. 2200 and Post it.
2) Create a Sales Credit Memo for 2 pieces of Item No. 2200, add the “Appl.-from Item Entry” column, and lookup and pick the open Item Ledger Entry created before.
3) Now post the Sales Credit Memo.
4) Go to the Item Card of 2200 and look at the Item Ledger Entries.
Now I would expect them to be closed, but they are both open. Why???
If you try is again for a different item (also without existing Item Ledger Entries) but without entering the “Appl.-from Item Entry” it works fine.
Of course you could say I should simply tell my users not to fill this field, but we really need to have the sales entries applied to the exact purchase entries (long story) and we need to post the Purchase Credit Memo before the Sales Credit Memo (even longer story).
I have been doing some debugging and ended in codeunit 22, where I found two problems.
One is the Item Application Entry table, which I don’t know anything about. :-( Anyone??
The other one is this condition in ApplyItemLedgEntry which simply rejects the entry I want it to use:
…
IF TempCostApplnChain.GET(ItemLedgEntry2."Entry No.") OR
(ItemLedgEntry2."Entry No." = ItemJnlLine."Applies-from Entry")
THEN <try another entry>
…
Yes, I have searched both MS Knowledgebase (and found nothing) and Mibuso (and found several posts that seem to find this strange but “by design”) – haven’t anyone an explanation or even a solution or just some ideas to solve it?
Thanks in advance.
I’m having some problems with Credit Memos and the closing of Item Ledger Entries.
The problem can be reproduced quite simple like this in the Cronus company:
1) Create a Purchase Credit Memo for 2 pieces of Item No. 2200 and Post it.
2) Create a Sales Credit Memo for 2 pieces of Item No. 2200, add the “Appl.-from Item Entry” column, and lookup and pick the open Item Ledger Entry created before.
3) Now post the Sales Credit Memo.
4) Go to the Item Card of 2200 and look at the Item Ledger Entries.
Now I would expect them to be closed, but they are both open. Why???
If you try is again for a different item (also without existing Item Ledger Entries) but without entering the “Appl.-from Item Entry” it works fine.
Of course you could say I should simply tell my users not to fill this field, but we really need to have the sales entries applied to the exact purchase entries (long story) and we need to post the Purchase Credit Memo before the Sales Credit Memo (even longer story).
I have been doing some debugging and ended in codeunit 22, where I found two problems.
One is the Item Application Entry table, which I don’t know anything about. :-( Anyone??
The other one is this condition in ApplyItemLedgEntry which simply rejects the entry I want it to use:
…
IF TempCostApplnChain.GET(ItemLedgEntry2."Entry No.") OR
(ItemLedgEntry2."Entry No." = ItemJnlLine."Applies-from Entry")
THEN <try another entry>
…
Yes, I have searched both MS Knowledgebase (and found nothing) and Mibuso (and found several posts that seem to find this strange but “by design”) – haven’t anyone an explanation or even a solution or just some ideas to solve it?
Thanks in advance.
Regards
Peter
Peter
0
Comments
-
Item ledger entries are applied against each other.
An item decrease is related to an item increase. Table Item Application Entry makes that relation. This table also makes helps applying costing entries.
Your problem seems to be related to the concept of making Sales before purchase items. You are returning items to vendor before receiving items from customers. So you have to run Adjust Cost – Item Entries batch
Read the Whitepapper Costing for Microsoft Dynamics NAV.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