ODBC into Navision, getting it to POST

Mauddib
Member Posts: 269
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
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
0
Comments
-
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.0 -
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.
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions