Free development tools

Last updated 21 jan 205

This is the list of  development tools that i use.
maybe not the best, but it get my jobs done, and its FREE.
i will update the list over time.

1. Fiddler, AJAX sniffing tools, i use this to debug my AJAX object.
http://www.telerik.com/fiddler

2. Microsoft Web Expression 4. web editing tools, oftenly compared with dreamweaver. its unbelievable MS give such great tools for free
http://www.microsoft.com/en-us/download/details.aspx?id=36179

3. notepad2
notepad, but pumped up with standard code writing tools. recognize syntax, indentation, show whitespace, etc. a very lightweight coding tools, one my essential tools
http://www.flos-freeware.ch/

4. DBComparer
Compare database? why? because compare text is too mainstream.
http://dbcomparer.com/Download/

AX Retail : how to set POS layout for specific user

By default, the layout is set on Register. If you need to differentiate the layout for specific user, here's how to do it :

1. Go to Retail >> Common >> Workers
2. Select worker you want to change, and click edit
3. Go to Retail Section
4. Change "Layout ID" (i assume you already have the specific layout ready)

MSSQL : Find Last Day and First Day of the month, and previous month

Get First Day of this month
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) 

Get Last Day of this month
SELEC DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))) 

Get First Day of the last (1) month
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0)

Get Last Day of the last (1) month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0))+1,0)))

Get First Day of the last (2) month
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 2, 0) 

Get Last Day of the last (2) month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 2, 0))+1,0))) 

and so on...

LS Retail : Activate float entry automatically after login

What you want :

LS POS to automatically show Float Entry window during login,

Solution :

go to Store Card and do the following :
1. check Safe Mgnt. in Use"
2. Select "POS Start Amount Method" to "Fixed Bag" or "Flexible Bag"


Tested on LS 7.1

Native FDB database limit

ever wonder about that? here's the explanation that i've got from partnersource

The maximum database size for a Microsoft Dynamics NAV native database is summarized in the following table:

Microsoft Dynamics NAV Version Maximum Database Size in GB
2.50 - 2009 256 GB
2.00 - 2.01 32 GB

By default, customer licenses have a maximum database size of 64 GB. However, the maximum database size can be increased to 256 GB for versions 2.50 to 2009 by adding granule 1370 - Database Expansions per 1 GB to the license (a maximum of 192 of granule 1370 can be added to a license).

Notes:
• The version of the Microsoft Dynamics NAV executables determines the maximum database size.
• The maximum size of an individual database file is 130,922,000 bytes. If you try to expand a database file beyond this size, you receive the following error message:

The maximum permitted value is 130922000

Therefore, any database larger than this must be expanded by using multiple database files.
To see the licensed size of a database in Microsoft Dynamics NAV, click File, click Database, click Information, and then click the Database tab.

Important:
Large databases should not be used on systems that do not support HotCopy. HotCopy is available in Microsoft Dynamics NAV 3.01 and later versions of Microsoft Dynamics NAV

bad practice #1

this is a list of things that you shouldn't do or you should avoid in NAV.

this thing based on my experience during implementation, so its fairly subjective and i (VERY HAPPILY) welcome any arguments or experience sharing to broaden my knowledge

1. implement items with heavy transaction with serial number. the adjust cost operation will take a very long time to finish. its not strictly forbidden, but if you could.. please avoid it. and if you do, i recommend you do the adjust costing in a non-working hours.

2. combine #1 with Automatic Adjust Costing : Always (in Inventory Setup). the adjust costing will be performed during the posting process, and it happens during working hour (mostly people posts during that time rite?). that way, you will put other users into risks of couldn't perform their jobs, because all the needed resources will be locked by the ongoing process (posting).

3. combine #1 with Average Cost Calc Type : Item & Location & Variant (in inventory Setup). the adjust costing will (potentially) getting longer, if not forever... :).

4. Backdate posting. it will lead to a long time adjust costing (potentially). actually it's not forbidden to do this. but it'll potentially cause a lot problem if its become a usere's habit. i promise you, it will... especially if you're
using NAV 4xx.


that's it for now.. let's make NAV a better place :)

Generate Production Order from Sales Order

1. Browse the sales order (or create one)
2. Click Order > Planning. Sales Order Planning Form will be opened.
3. Click Functions > Create Prod. Order. Options Form will be opened.
4. Choose your options based on your preferences and click Yes Button
5. Production Order will be generated

additional info :
Order Type - Item Order : the Production Order will be generated based on the selected item in Sales Lines
Order Type - Project Order : the Production Order will be generated based on all item in the Sales Order