Hi James
Thanks for the reply, most useful. The report we are using is physical inventory by inventory dimension. We found out yesterday (after I replied to your previous post) that we should not include the floating column or the one next to it. This is different to what we were advised at year end and forced our GL to agree to. We were not advised that our GL should agree to specific columns of the report either, so currently have variances that we will need to write off. We use SO, PO and project, 22000+ items and 130+ product groups. We build projects for stock too. I find it interesting that you say not to use the temp GL inv accounts, may I ask why? Finally, how do I put on the additional controls you suggest, and what happens during the month end process? I am already aware that some people have too much access which may effect inventory and am in the process of designing a new security protocol based on the Lego block principle where a series of small security access rights builds to their overall access level. Can't think of a better way to do it really. Thanks Mark --- In [EMAIL PROTECTED], "James Flavell" <[EMAIL PROTECTED]> wrote: > 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. > > > 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. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> 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/
