Tuesday, January 19, 2010

Accumulated Average explained

For example, if I have a set of data like this:

5, 10, 15, 20 -

Then, I would want to get Accumulated Average of this set as

5, 7.5, 10, 12.5

Where
1st data is 5, as 5 is the only number so far.
2nd data is 7.5, as (5+10) / 2
3rd data is 10 as (5+10+15)/3
4td data is 12.5 as (5+10+15+20)/4

Source:
www.devexpress.com/Support/Center/p/Q242748.aspx

Sunday, January 17, 2010

Saturday, January 16, 2010

To default File Open/Save dialog to Detail view

FileOpenPatcher (Scroll down page)
Info: http://www.netcult.ch/elmue/ElmueSoft-en.htm
Download Link 1: ftp://ftp.netcult.ch/mirror/elmue/FileOpenPatcher.zip
Download Link 2: http://electronix.ch/ptbsync/FileOpenPatcher.zip

Source:
http://forums.techarena.in/windows-xp-support/759768.htm

Thursday, January 14, 2010

How to allow minus inventory yet enforce serial number input?

Requirements:
It can only be done at Location without Bin Mandatory.
In Tracking Specification, you can check options that will enforce serial no. input on various transactions BUT you MUST leave "SN Specific Tracking" unchecked.

Implications:
Serial no. will merely function as information since no strict checking will be performed, ie. a serial no. can have an outbound qty larger that its inbound.
An outbound entry can get an incorrect cost if you entry the inbound transaction later but in wrong order.

Questions on relation between Item Tracking Specification and Costing Method

If SN Specific Tracking is turned ON, will it make a different what costing method we use?
NO
Quote from http://dynamicsblog.wordpress.com/category/navision/page/15/:
if you specify the SN Specific Tracking in the Item Tracking Code card, then regardless of the FIFO (or Specific) method, the system will apply cost according to the serial number assignment

Thursday, January 7, 2010

Assigning different license for each database in a SQL server?

A license can be cut to be used per database (you pay for this option!) (this means a different license can be used for each database on the server). For example if you have a license for 5 users and you have 10 databases, 5 users PER DATABASE can work at the same moment. In this case you MUST put “Save license in database”* to TRUE, otherwise you don’t have this advantage.

*File=>Database=>Alter=>Tab Integration=>Save license in database.

Source:
License file in SQL
http://mibuso.com/blogs/kriki/2009/09/30/license-file-in-sql/

Wednesday, January 6, 2010

Default bahaviors that may required mod

Salesperson can be empty

How VFP evaluate expressions

When a conditional statement has more than one expression, VFP evaluates them one at a time from left to right. As soon as VFP can evaluate the expression, it stops, even if it does not evaluate all conditions.

When defining conditional expressions, define the evaluation order so as to minimize the work that Visual FoxPro must do. Put the most critical condition first. This action saves VFP time; it also enables you to include in the second part of the test conditions that are not otherwise valid.

When you are connecting two expressions with OR, put the one that is most likely to pass first. When you are connecting two expressions with AND, put the one that is most likely to fail first.

Source:
www.webbasedprogramming.com/Special-Edition-Using-Visual-FoxPro-6/ch04/ch04.htm