Photo credit: Bruno Girin

The Item Tracking Lines form has a Source Table of Tracking Specification.

The Tracking Specification table is used in conjunction with theResrevation Entry table, Item Ledger Entry table and various temporary record handling functionality in order to attach and maintain tracking against items on document lines.

To add a new field, for example, Your Reference, you must first add this field to the Tracking Specification table and place it on screen by modifying the Item Tracking Lines form:

Click to continue →

Photo credit: gitboy

If you or your client use item tracking to any degree then chances are that at some stage you will want to perform a stock take by lot/serial numbers.

In Dynamics NAV a stock take can be performed using a Physical Inventory Journal.

This journal can be automatically populated by running theCalculate Inventory function which gives a picture of what NAV “thinks” the current stock situation is.

Warehouse staff can then perform the physical stock checks in the warehouse, feed any adjustments into the journal and finally post, the negative and positive adjustments hitting the item ledger.

What if we want to easily count stock by lot/serial no. and item track the physical inventory journal?

Or want to run the Calculate Inventory function by lot no./serial no.?

Click to continue →

Photo credit: Bruno Girin

Up until the release of Dynamics NAV 5.00, the application suffered slightly from a lack of any standard way to show tracking information on sales, purchase and warehouse documents.

Microsoft have now started to remedy this situation to a certain degree.

Look at the Sales Shipment report (208) in a Cronus database. Sitting at the bottom of the Options tab is a check box called Show Serial/Lot No. Appendix. Ticking this option will print an appendix page giving a breakdown of the lot/serial information associated with the shipment.

The appendix page hasn’t been applied to all appropriate reports though, so it still leaves some work for us to do…

The following example shows how you can add the appendix page to to any Document type report, using the Purchase Receipt Report (408) to illustrate.

 

 

Photo credit: System One Gang

Should you ever have the need to get a response from a web page and handle that response in Dynamics NAV, you could do this by sending an XMLHTTP request to the page then processing the response text as required.

For this purpose we’ll define a variable which points to the Microsoft XML automation server and the XMLHTTP class:

‘Microsoft XML, v6.0′.XMLHTTP

The C/AL required will be as follows:

Create the Automation object:

Define the reqest:

Send the request:

Process the response:

In the simplified example above, the ASP page called search.asp is responsible for generating the response.

The XML automation server will pass a request to this page then retrieve a response via theresponseText which can then be processed as required.

Photo credit: phatcontroller

CuteFTP is a popular FTP client application by GlobalSCAPE.

This articles demonstartes how to access and use CuteFTP’s transfer engine from within Microsoft Dynamics NAV to upload, rename and delete files on a remote ftp server. It’s slighlty more refined than the somewhat Heath Robinson approach required to use the in built windows ftp client described in an earlier article.

Click to continue →