RE: [Axapta-Knowledge-Village] Inventory Closing

[Van Den Langenbergh Gunther]

that's what i say


From: Jim Jo [mailto:[EMAIL PROTECTED] 
Sent: vrijdag 17 september 2004 9:28To: 
[EMAIL PROTECTED]Subject: RE: 
[Axapta-Knowledge-Village] Inventory Closing

I think you can turn off average cost using the standard cost. But in this 
case the cost is considered known !. The cost is a standard .. and profit and 
loss on issue and reciept can be tracked from the accounts!.
 
If its not stanndard cost , axapta always uses an average cost on every 
sales !.
 
Right ?
 
JimVan Den Langenbergh Gunther 
<[EMAIL PROTECTED]> wrote:

  
  If financial inventory is on (inventory dimension) 
  average cost is not per item but per batch (I think this is what you mean by 
  "actual cost").
  The only way to not have awp (temporary is to use 
  standard cost (inventory model group)
  
  
  From: James Flavell 
  [mailto:[EMAIL PROTECTED] Sent: donderdag 16 september 2004 
  15:56To: 
  [EMAIL PROTECTED]Subject: RE: 
  [Axapta-Knowledge-Village] Inventory Closing
  
  I 
  guess you know by now why it is average if you dont already have the stock 
  purchased but if you already have it purchased I believe it takes the actual 
  cost (cant total remember right now but I believe so) right!?? Maybe I am 
  thinking of the case when batchnumber is part of financial inventory and all 
  of a batch is priced the same and so average cost of the batch is basically 
  still the same as the actual cost (can someone confirm does Axapta ALWAYS do 
  average cost at time of sales invoice even if actual cost is 
  known???)
   
  BTW 
  can anyone tell me is it possible and where to turn off the average cost ... 
  my customer would prefer zero cost to be posted if the actual cost is not 
  known (or alternatively the estimated sales cost to be based on the 
  purchase line amount the sales is reserved against).
   
  ThanksJames
   
  
    -----Original Message-----From: Van Den Langenbergh 
    Gunther [mailto:[EMAIL PROTECTED]Sent: 
    16 September 2004 19:01To: 
    [EMAIL PROTECTED]Subject: RE: 
    [Axapta-Knowledge-Village] Inventory Closing
    My personal recommendation:
    recalculate every day (interesting for adjusted 
    production calculations and because of performance => closing will be 
    faster)
    closing (= recalculate and close) can be done 
    monthly
    
    
    From: Jim Jo [mailto:[EMAIL PROTECTED] 
    Sent: donderdag 16 september 2004 11:58To: 
    [EMAIL PROTECTED]Subject: RE: 
    [Axapta-Knowledge-Village] Inventory Closing
    
    yep .. thanks ... 
     
     but whats the frequency that you recommend for a recalculation 
    run ... i suspect if the transaction volume is high then you have to run it 
    daily ???? wrong ???? 
     
    jimVan Den Langenbergh Gunther 
    <[EMAIL PROTECTED]> wrote:
    
      
      
      Hi Jim,
       
       
      temporary (before closing or recalculation) your 
      value will be wrong in many cases:
      f.i. 
      suppose you buy and invoice 100 pieces of an item at 
      $20 a piece. (there is no history before this point)
      later you buy again 100 pieces at $40 a piece but 
      they are only received , not invoiced.
      First thing: AWP is always used temporary (before 
      recalculation/closing)
      You sell 50 
      pieces.
       
      You could think that temporary 50 
      pices are drawn at $30 (because of temporary 
      AWP)
      This is not true. When 
      "physical value" is off (inventory model group) these 50 will be drawn at 
      $20 because the last 100 don't have financial price (because no invoice), 
      so it doesn't add to the AWP for the 
      moment.
      If you recalculate/close after the 
      last 100 are invoiced it will correct the AWP to $30 and so also the issue 
      of 50 pieces.
       
      Try it for for many examples, it is 
      always a case of: "stock can be issued before all financial value is 
      known, so it is issued a a wrong price".
       
      So you see that recalculation 
      is necessary also if you chose 
AWP. 
       
      So the rule is: invoice prices (for purchases) 
      and cost calculation (for production) sets the financial value for 
      incoming stock and because you could have issue transactions before you 
      know the definite price for stock you will always have to 
      recalculate/close
       
      hope this 
helps,
       
       
      greetz,
       
      Gunther Van den Langenbergh 
      (Belgium)
      
      
      From: Jim Jo [mailto:[EMAIL PROTECTED] 
      Sent: donderdag 16 september 2004 8:10To: 
      [EMAIL PROTECTED]Subject: 
      [Axapta-Knowledge-Village] Inventory Closing
      
      Hi all ..
      May be this could be a foolish !
      Correct me if am wrong !
      Costing method used - FIFO !
      From my understandin when you do a recalculation Axapta adjusts the 
      inventory values of those items which were drawn from the inventory on 
      average cost price to the cost price by lot id.
      Jus curious .. why cannot it be done while doing the transaction 
      itself.
      And if you use the weighted average costing method there wont be any 
      settlements proposed when you do a recalculation.
      Please comment !
      Regards
      Jim.
       
       
      
      
      Do you Yahoo!?New 
      and Improved Yahoo! Mail - Send 10MB messages! Sharing the 
      knowledge on Axapta. Sharing the knowledge on 
      Axapta. 
    
    
    Do you Yahoo!?Take 
    Yahoo! Mail with you! Get it on your mobile phone. Sharing 
    the knowledge on Axapta. Sharing the knowledge 
    on Axapta. Sharing the knowledge on 
    Axapta. 


Do you Yahoo!?Yahoo! Mail is new and improved - Check 
it out! 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.