GL Entries are not in balance with Value Entries

gvolkov · 2010-07-30

Hello All,

I searched about this issue here, but wasnt able to find anything.

so here it goes...

Noticed that GL Account for inventory does not match with the inventory valuation report, so started digging. narrowed it down to a specific day of when it started, and started looking at transactions. Opened SQL Management studio and wrote couple queries to SUM Value Entries grouped by document number on that specific day and same for GL Entries. To my surprise, all transactions match except ones originating from BOM Journals (Kit BOMs Assemblies and Disassembies).

As far as i know they should match, but please correct me if i am wrong. So the goal here is to find out why these transactions bearing same document number dont match, why is it happenning like that, and how this could be fixed.

PS - Cost Adjustement is set to Always, so all the costs are adjusted at the time of transaction.

gvolkov · 2010-08-02

nobody???

gvolkov · 2010-08-03

I found that some Value Entries dont match the General Ledger. Why would that happen?
Example:
Value Entry - Document Number - XYZ001 = -87.92
GL - same Document Number = 15.63

jannestig · 2010-08-03

Have you taken into consideration the Assembly and disassembly GL accounts ?

Not sure how you have yours setup, but the differences may be the services of assembling and disassembly which may have caused your imblance

gvolkov · 2010-08-03

Well, there is an amount in WIP Account which is then balanced with Accrued Inventory. But that looks like another problem. It looks like the Kit manufacturing process didnt go thru all the way. Reason for that is currently unknown. That amount still is not enough to cover the difference between Value Entry and inventory. This other difference looks like it happens on BOM disassembly. Though, the assembly bom and disassembly boms are exactly the same. Its like there is a bug in Navision or something.

gvolkov · 2010-08-03

I wonder if anyone knows the reason why Assemblies are posted with Output and Consumption, and Disassemblies are posted with Negative and Positive adjustments?
Shouldnt disassemblies be posted with consumption and output too?

GL Entries are not in balance with Value Entries

Comments

Categories