ODBC into Navision, getting it to POST

Mauddib

How would you go about connecting to Navision without using licenses?

My plan: We have a lot of pocket PCs with Infrared ports on them. I was thinking of designing an application, JAva, VB or something, to allow them to scan barcodes and populate information into Navision. For example stock transfers. A barcode is scanned, a source and destination location is selected and a transfer made.

My idea: Im sure this is easy enough to do up to the point where the software on the handheld populates automatically an Item Reclass Journal over ODBC. But how do you get Navision to POST this journal? A periodic OnTimer() on the server to check if theres anything in a given journal? Or something else?

The solution offered by our reseller would use the Navision proprierty ODBC which, painfully, uses TWO licenses!!!

GaMBe

DenSter

You can enter data into Navision using C/ODBC, but that does not allow you to run Navision processes. I have no experience with C/ODBC myself, but I assume that uses one license. Just think about the fact that if you have 10 people running around scanning things, and the process only uses one license, that you are lucky to 'only' need one license, instead of one for each person.

For the posting you will need the timer process in a NAS instance. Each NAS instance also uses one license, since it is basically an unattended client session.

So that's where the two licenses come from. It's actually all on one license, but two sessions. You will also have to make sure you have C/ODBC and enough NAS instances on your license. You get one NAS instance for free with the G/L granule.

Mauddib

Our server sits open anyway and always uses a session. We never turn it off. So I was hoping to implement barcoding without using ANY extra licenses (we're a low profit company ). My plan was to use Standard ODBC to populate the journals and then use some kind of software on the server (which is running anyway) to periodically post that journal and hence acheiving the results without using a license.