Previous Thread:   10956.1 Cancelled Payments not being reconciled

9/17/2005 7:01:01 PM    11932.1 turnover ratio
Dear all,  
  
Need information on how Axapta 3.0 (sp1, sp2, sp3) calculates (formula)  
  
the turnover ration on the Items statistics.  
  
According to my tests, depending on the chosen period as well as the  
  
financial dates of purchase orders is somehow taken into account in the  
  
calculation, which may result in negative turnover ratios.  
  
e.g.  
  
transaction          pcs       physica date   financial date  cost  
  
purchase receipt 100       3.2  
  
sales invoice        10  
  
5.2                -4.5  
  
sales invoice         10  
  
10.2              -4.5  
  
purchase invoice 100                             15.2               45  
  
period 1.2. .. 15.2 = turnover ratio = -4.28  
  
inventory model FIFO, physical neg not allowed, physical value included  
  
REgards,  
  
Chris  
  
Posted on technet.navision.com on: Thursday, February 03, 2005