Dear all, At this moment I would like to ask about what the different between Item Ledger Entry and Value Entry in the Navision ver. 3.7 ? When the Item Ledger Entry should be have new entry and when the Value Entry should be have a new entry ? Hope that anyone can help me to explain about this issue Thanks for your kindly help Regards, Grace Vin
Dear all, At this moment I would like to ask about what the different between Item Ledger Entry and Value Entry in the Navision ver. 3.7 ? When the Item Ledger Entry should be have new entry and when the Value Entry should be have a new entry ? Hope that anyone can help me to explain about this issue Thanks for your kindly help Regards, Grace Vin
Hi You book an item in. This is reflected in the item ledger entry and the value ledger entry. You receive the invoice this is a new entry on the value ledger entry. The value entry has many entries (adjust cost item entries) that are ultimately rolled into the cost displayed on the item ledger entry.
Please do not cross post: http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=16845
Continued my question about the Entries, if I create the Transfer Order’s transaction, and I post ship from that transaction. what entries should be created ? G/L Entries, Item Ledger Entries or Value Entries ? And when I post receive from that Transfer Order’s transaction, what entries should be created ? G/L Entries, Item Ledger Entries or Value Entries ? Thanks for your kindly help Regards, Grace Vin
Why don’t you post one and have a look? The registers will give you all the information you need. You could also do your own scenarios to test the entries.
Hi Grace, as Stven says, the only way to learn Navision is to try. Create a test database and make soem test postings. In principle, Item Ledger Entries relate to the physical movement of Items. The Vlaue Entries relate to the financial transactions related to that movement. Dave Cox has also given you some more detailed advise. But please in future, only post once (not three times), and don’t make your posts secret, because then most users can’t see them. We all would like to help you, and the best way to get theat help, is to try using Navision, make posting, and then instead of general questions, you can ask a specific question about the posts you made. Also, can you let us know what your status is, it isn’t in your profile. Are you a Navision user consultant NSC what. It will help us when answerign your questions. So good luck with Navision, and keep those questions coming.
i tried replying to the same topic heading ( duplicate entry) but its locked. the user asked if the system creates value entries and no item ledger entries. the answer is yes. can’t tell when exactly, but in manufacturing module Releases production orders will create more value etires then item ledger entires, which says there are some value entries with no item ledger entries.
Hi Lakshmi Yo can hae numerous value entries linked to an item ledger entry but I have not seen a value entry with NO item ledger entry. Look at the Item Ledger Entry No reference on the value entry line.
Well Steven, never say never. I have seen it happen. Once from a piece of very badly written code in 2.60 moved to 3.10, and once from a disasterous piece of code written in a 3xx system. Basically if it happens, then someone wrote something wrong.
I have seen it happen as well, but not by the system, but by someone “saving time” (bad code) by deleting Item Ledgers instead of reverse posting, “as there was nothing posted after the journal, it should be ok” [:(!] , but when the next document was posted it inherited the value entries from the deleted Item ledgers. [B)]
I should have said “as standard” I have never seen it happen [:D]
Dear all, Thanks for all of your respon and explaination regarding my Navision’s problem at the moment. To Steven, I had already test with some scenarios, but the result as you explain, in the first answer ( means there is no unusual entries had been created ) The problem that I face now was I had seen the historical of the transaction from the Transfer Order and that shown the Value entries had been created without any Item Ledger entries created ( and that is not in the Manufacture Module but in the Financial module → as told by Lakshmi, the Value Entry could be created without any Item Ledger Entry just in the Manufacturing module ). And I have no idea, why it can be happened ?! To Steven an David I am so sorry if there is some posting article with the same subject that had been posted by me in this forum. Reason for that, first I had wrong place to post my problem in the forum ( first I post not in the Beginner Forum ) Hope that I do not do it again in the future So, Do anyone have some tips and trick that I can trace the historical of the wrong transfer order’s transaction ?! Cause it was impact to the G/L ( the interim account would have figure . amount which is there should not be any figure / amount in there ) Hope that anyone could help me please Thanks and regards, Grace Vin
Dear Grace, I think you can use the warehouse module → history —> posted transfer shipment or posted transfer receipt —> click navigate button in the windows, there will be shown the entries affected by the transfer operation. rgds, Johnson “se non e vero, e bene trovato”
Hi Grace, don’t worry abot the cross posting, its all fixed now. Please take a look at this thread : http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=9245 In terms of your question. What you need to do is to create a clean Navision database, and start making lots of test posts to see what happens. Its the best way to learn.
Hi The Value entries are child record to the Item ledger (Parent), “Many to One” linked on Item Ledger entry Number. So as you Adjust Costs or change from Expected Cost to Invoiced Cost, entries in the Value Ledgers are created, also for the stock movement quantities. EXAMPLE: Received but not Invoiced Expected Cost 9.00 When Invoiced the system creates 2 entries, Expected Cost -9.00, Invoiced Cost 9.00. So the net Expected Cost goes to 0, but the audit trail is still there in the value entries. Hope this helps you
Hi David, Thanks for the short explaination about my question. Continued that question, is it possible if there is Value Entries were created without any Item Ledger Entries were created ? Thanks for your kindly attention and help Regards, Grace Vin
No not by normal posting, all Value Ledgers have an “Item Ledger Entry No.” field whickh relates to the parent record, this is the link. On the Item Ledger some of the Value fields allow you to drill down to the value entries. If you are concerned about any of the values on the Value Enrty, you should find the source document number, that will tell you the impact of posting a particular document. An example of this would be the remaining quantity field Item Ledger Entry - Remaining Quantity = 4 Drill Down Value Entry Purchase = 10 Value Entry Sale = -2 (Applied to) Value Entry Neg Adjustment = -3 Value Entry Sale = -1 (Applied to) As this is the end user forum, if you have further concerns, contact your resellers helpdesk, they should be able to offer you more specific information