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
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.
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.