Okay
well all seems correct then, from here on in its abit more difficult without the
actual data...., I can only guess that some posting setup is not
correct...
I
suggest you put additional control on your inventory ledger account to only
allow transactions with type 'xxx - Reciept' and 'xxx - issue' this should
at least make sure no other automatic/system posting are ending up
there...
Since
your finanical and physical (delivered but not invoiced) have diff GL can
you compare:
A) invent financial vs GL fin
B) invent delivered but not invoiced vs GL temp.
Are
both different or is it only the 'physical' (delivered but not invoiced) that is
different or is it just the financial that is diff?
When
you say you use the physical invent report to compare what exactly are you
comparing? Which field(s) ont he report against which GL
account(s)?
A few
things I have had experience with:
1)
Misc charge that affects item cost has its offset set equal to the inventory
account so the net effect of any such misc charge is to affect inventory module
but no affect on ledger (debit and credit knock each other off, cant recall if
recon report picks this kind of thing up).
2) If
the temp physical accounts were activated reversals of invoices ended up
putting values in the GL temp account ...this was not Axapta but XAL from what I
recall but maybe its worth checking for Axapta. If possible I always
prefer to advise customers not to use the temp physical GL accounts as things
get more confusing and messy...
Finally which modules are you actually using and what type of transaction
do you do that affect stock? SO, PO, Project, Production?
On
thing
-----Original Message-----
From: markoleary1967 [mailto:[EMAIL PROTECTED]
Sent: 21 October 2004 14:44
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Re: Inventory valuation reconciliation to GL
Hi James
Answers...
* Physical gets posted to a separate GL account to financial.
* Setup is done for AR (sales orders) and AP (purchase orders).
* Posting seems to work consistently for AR and AP.
Hope that makes sense.
Cheers
Mark
--- In [EMAIL PROTECTED], "James Flavell"
<[EMAIL PROTECTED]> wrote:
> Thanks mark,
>
> Next questions:
>
> Have you setup the system so that physical invetory is posted to
GL?
> If so has it been setup to be done in both AR and AP modules?
> If so is it setup to post to the same GL account as financial
inventory?
>
> Thanks
> James
>
> -----Original Message-----
> From: markoleary1967 [mailto:[EMAIL PROTECTED]
> Sent: 21 October 2004 08:34
> To: [EMAIL PROTECTED]
> Subject: [Axapta-Knowledge-Village] Re: Inventory valuation
reconciliation
> to GL
>
>
>
> Hi James
>
> In response to your questions
> * FIFO
> * Close has been run each month before compare
> * Inventory is higher than GL
> * Comparing GL Trial Balance to
> Inventory>Reports>Statistics>Physical Inventory by Dimension
> * Version 3.0 Build#1951.2410/514-90 SP2/OP023-19
> * Inventory accounts have been locked and reviewed for any
journals
> posted to them just in case something got through.
> * Have run reconciliation report and have no variance in the
report
>
> FYI we have negative stock turned on.
>
> Regards
> Mark
>
> --- In [EMAIL PROTECTED], "James Flavell"
> <[EMAIL PROTECTED]> wrote:
> > A few things to get the ball rolling:
> >
> > What type of model are you using? avg, FIFO, STd?
> > I take it you have been running the closing every month (or
before
> you
> > compare invent and GL)?
> >
> > Which module has the higher value?
> >
> > Which reports are you using to comapre the modules?
> > Which version of Axapta (including SP) are you running?
> > Is the invent accounts setup to not allow manual journal
postings
> into them?
> >
> > Have you run any of the reconcilliation reports in the
> > Ledger/Reports/Periodic/Reconciliation, this is probably the
first
> place to
> > start from!
> >
> > James
> >
> > -----Original Message-----
> > From: markoleary1967 [mailto:[EMAIL PROTECTED]
> > Sent: 20 October 2004 14:36
> > To: [EMAIL PROTECTED]
> > Subject: [Axapta-Knowledge-Village] Inventory valuation
> reconciliation to
> > GL
> >
> >
> >
> > Hi All
> >
> > We have an issue where the value of my inventory ledger is
moving
> > independantly of the GL - so therefore we cannot reconcile
GL to
> > physical stock.
> >
> > We have been using Axapta for almost a year now and at year
end
> had
> > to force GL to agree by way of a journal. We are now 3 months
> into
> > new year and have a significant difference already where GL
is
> less
> > than inventory ledger.
> >
> > The setup of Axapta is OK according to our software vendor,
> however,
> > they do not seem to be able to provide the answers to us. We
> want to
> > use a standard report to agree to GL on a monthly basis.
> >
> > We would like any help here, whether it is setup, procedures,
> > problems from other modules, interface issues etc. This
would at
> > least give us some method to try tracing what is going on.
> >
> > Thanks in advance
> > Mark
> >
> >
> >
> >
> >
> > Sharing the knowledge on Axapta.
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------
----
> ---------
> > --
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> >
> > b.. To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> of Service.
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> -------------------------------------------------------------------
---------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> b.. To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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.
