Hi! Check if purchase of service items have been posted on the general ledger account. That's the most common error I have seen, and the reconciliation report doesn't identify this kind of errors.
Regards Thomas -----Oprindelig meddelelse----- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Koh Meng Chiat Sendt: 23. juni 2005 16:06 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report Hi, I've tried to use the Reconciliation Report in GL. But it still impossible to reconcile the GL balance with the Physical value by item group report. Any idea? --- Steve Wright <[EMAIL PROTECTED]> wrote: > Try this menu... > > General Ledger > Reports > Reconciliation. You > will find Inventory in > there. > S. > > > ________________________________ > > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On > Behalf Of Koh Meng > Chiat > Sent: Thursday, 23 June 2005 3:57 PM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: Re: [Axapta-Knowledge-Village] Inventory > management - Physical > Value by Item Group Report > > > Hi Harry, > > Just want to check. Where / how can i analyze the > variances between Inventory and GL? Can i break > down > the variances into its detail transactions? > > Thanks in advance. > > Best Regards, > > Jack Koh > > > > > --- "Harry (Harshawardhan Deshpande" > <[EMAIL PROTECTED]> wrote: > > > hi > > > > Try this > > > > run the same report as of a date less than the go > > live date say 1 Jan 1990 and see if the physical > > inventory report prints this amount? > > > > regards > > > > harry > > > > > > Koh Meng Chiat <[EMAIL PROTECTED]> wrote: > > Hi Harry, > > > > Yes. We're currently facing some problems as the > > discrepancies between inventory on hand and GL > > inventory are hard to trace. For example, if > there > > is > > a difference of 1511.02 between inventory and GL, > > how > > can one identifies the causes of the differences? > > > > > Do appreciate your valuable advice. :) > > > > Thanks in advance. > > > > --- "Harry (Harshawardhan Deshpande" > > <[EMAIL PROTECTED]> wrote: > > > > > hi > > > > > > The way our client does this is that he > reconciles > > > the total of physical value with the gl balance > as > > > of a particular date. > > > > > > are u facing any problems with this? > > > > > > regards > > > > > > harry > > > > > > > > > Koh Meng Chiat <[EMAIL PROTECTED]> wrote: > > > Hi Harry, > > > > > > Thanks for your prompt reply. Just curious how > > > should the user perform Inventory reconciliation > > > with GL. The steps should it be: > > > > > > 1. Print out Pyhsical Value by Item Group > Report > > in > > > Inventory Management > > > Module as of closing date (ideally month end) > > > 2. Print out Ledger Transaction List in General > > > Ledger Module. OR > > > Print out Reconciliation report (GL > Reports > > > > > Reconciliation > > > > Inventory)?? > > > 3. Compare both reports and find out the > > > unreconciling items?? > > > > > > > > > Appreciate your valuable advice. > > > > > > Best Regards, > > > > > > Jack Koh > > > > > > > > > > > > > > > > > > > > > > > > "Harry (Harshawardhan Deshpande" > > > <[EMAIL PROTECTED]> wrote: > > > hi > > > > > > 1. Yes > > > 2. known value is invoice updated SO/PO, costed > > > production orders etc. Anything before that is > > > floating. (I hope). > > > > > > regards > > > > > > harry > > > > > > Koh Meng Chiat <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > 2 questions: > > > > > > 1. Can i use Pyhsical Value by Item Group > Report > > to > > > reconcile with my GL stock? I think most of you > > had > > > encountered this before as there is no specific > > > report > > > in inventory module which can help to reconcile > > with > > > your GL. (Note: The inventory reconcilation > report > > > does not provide sufficient information in terms > > of > > > GL > > > stocks and stock value in inventory) > > > > > > 2. What is the "Known Value" column in Physical > > > Value > > > by Item Group Report? > > > > > > Appreciate any help. > > > > > > Thanks in advance. > > > > > > Best Regards, > > > > > > Jack Koh > > > > > > > > > > > > > > > ____________________________________________________ > > > > > > Yahoo! Sports > > > Rekindle the Rivalries. Sign up for Fantasy > > Football > > > > > > http://football.fantasysports.yahoo.com > > > > > > > > > Sharing the knowledge on Axapta. > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam > > > protection around > > > http://mail.yahoo.com > > > > > > Sharing the knowledge on Axapta. > > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam > > > protection around > > > http://mail.yahoo.com > === message truncated === __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
