RE: [Axapta-Knowledge-Village] Re: Inventory valuation reconciliation to GL

[James Flavell]

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:36To: 
  [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:57To: 
    [EMAIL PROTECTED]Subject: 
    [Axapta-Knowledge-Village] Re: Inventory valuation reconciliation to 
    GLHi JamesThanks 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.ThanksMark--- 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.Sharing the 
    knowledge on Axapta. 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.