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 <*> 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/