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