search
Twitter Rss Feeds
MicrosoftArticlesForumsGroups
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml/Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsGroups
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsGroups
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsGroups
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsGroups
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Publisher
Money

Operating SystemsArticlesForumsGroups
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsGroups
Share Point
BizTalk
Site Server
Exhange Server
IIS
Transaction Server

Graphic DesignArticlesForumsGroups
Macromedia Flash
Adobe PhotoShop
Microsoft Expression

OtherArticlesForumsGroups
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Reviews
Search Engines
Resumes

 

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


Pete's Blog   |    Pete's Resume   |    Robbe's Blog   |    Robbe's Resume   |    Archive #2   |    Archive #3   |    Dotnetslackers   |    XmlPitStop   |    Advertise   |   Contact Us   |   Privacy   |   Copyright (c) 2000 - 2009 eggheadcafe.com  All rights reserved.