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 > > > > 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 the > > Yahoo! Terms of Service. > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > > protection around > > http://mail.yahoo.com > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > > 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 the > Yahoo! Terms of Service. > > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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/