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.
Microsoft Certified Technology Specialist
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Business Management Solutions Specialisthttp://www.navisiontech.com 0
Comments
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Business Management Solutions Specialist
http://www.navisiontech.com
Example:
Value Entry - Document Number - XYZ001 = -87.92
GL - same Document Number = 15.63
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Business Management Solutions Specialist
http://www.navisiontech.com
Not sure how you have yours setup, but the differences may be the services of assembling and disassembly which may have caused your imblance
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Business Management Solutions Specialist
http://www.navisiontech.com
Shouldnt disassemblies be posted with consumption and output too?
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Business Management Solutions Specialist
http://www.navisiontech.com