Hi James
Thanks for the two posts, will take me a bit of time to check some things out. Will get back to you. Cheers Mark --- In [EMAIL PROTECTED], "James Flavell" <[EMAIL PROTECTED]> wrote: > Hi Mark, > > I dont know if you have been told what the known and floating value is now > but here form the online help is a good explanation (Known and Floating > value have always been a bit of a stumbling block for users even in XAL...) > > > Physical inventory by item group > Print the physical inventory per item group on the date specified. In > addition to physical quantity and value, specify the Known value and > Floating value. Select Show zero lines if you want items without physical > quantity or value to be printed. > > Examples of Floating value and Known value: > 1) An item is packing-slip updated on September 1, 1999 with the value 100. > 2) A report of September 1 shows a Floating value of 100. > 3) The item is invoice-updated on September 3. > 4) A report of September 3 shows nothing in the 2 fields. > 5) A report of September 2 shows a Known value of 100. > > > > -----Original Message----- > From: James Flavell [mailto:[EMAIL PROTECTED] > Sent: 22 October 2004 16:36 > To: [EMAIL PROTECTED] > Subject: RE: [Axapta-Knowledge-Village] Re: Inventory valuation > reconciliation to GL > > > Hi Mark, > > The preferences not to use temp GL comes from long ago with XAL (before > axapta) as the users tended to just get confused because of the extra > postings that are done and also like I mentioned it was not 100% perfect... > this has kinda rolled over into Axapta in terms of my personal preference > when faced with the choice but I would hope Axapta is now 100% okay and so > it then would come down to more whether the user gets confused and this can > vary greatly so I for sure usually go for no temp accounts to start a > project but explain to the customer they can turn them on if they find it > would really benefit them. Most csutomer tend to prefer the 'old fashioned' > approach of getting a report from the system and making month end accruals > for such temp amounts. So overall most customer I have come across dont need > the temp account for ad hoc reporting during the month, rather it is only > month end they need to report delivered but not invoiced and since they > usually have to provide a report that is proof of this amount then there is > very little benefit from the system doing the temp posting (further more > often they find it hard to reconcile the GL temp amount with the report so > they prefer just to have the report and make an accrual based on that)... > this is my experience anyway. > > As for what you have been comparing, can you detail the before and after > finding out not to include floating value (i.e. what exactly are you > comparing). Currently what do you believe you should be comparing (I > bleieve there are two things you must compare 1-temp GL against delivered > but not invoiced 2-financial against inventory GL) > > The additional control is on the chart of account records on the setup tab > you have the 'posting type' here I think you would set as 'List' and then on > the 'validation list' button make a list of all the posting types accepted > into this account (look for those 'xxx Reciept' and 'xxx Issue'). If > anything without these types tries to go into the account it will not be > allowed (so brief the users of possbile messages before you do it as you > might take a few tries to smooth it all out). > > Just wondering the 150 product groups you have means you have many > different GL inventory accounts? > > Let me know how things stand after your latest findings > Cheers > James > > -----Original Message----- > From: markoleary1967 [mailto:[EMAIL PROTECTED] > Sent: 22 October 2004 16:57 > To: [EMAIL PROTECTED] > Subject: [Axapta-Knowledge-Village] Re: Inventory valuation > reconciliation to GL > > > > 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: > > > > Axapta-Knowledge-Village- [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. > > > > > > Sharing the knowledge on Axapta. > > > > > 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 --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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/
