Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Bar Code
Cristina
Member Posts: 35
Hello,
I want to transfer data to and from Navision with an other application. The application is on devices of read bar codes.
In the other application are reading the quantyties and item barcode. The process is like this: the items are received based on a Purchase Order which came from Navision into application, in warehouse are reading the item and quantyties and in Navision has to arrive the scan quantity on the Purchase Order.
The other application is on SQL.
I saw the process like this (but maybe is incorrect)
1. In Navison are created the purchase orders
2. The purchase orders must arrive in the SQL . When the purchase orders is create it has be also in SQL, but how:
-using code on Navision to insert in SQL
-using a message via Navision Application Server and a job in SQL
-using C/FRONT (but C/Front I never use and I don't now how it works)?
3.Then came the process of scan. This process has to be syncronuhs in Navision and the other application.You say to build an automatic process and that are severals way to do this.
But what are this ways?
-to run a job scheduler in Navision all the time and have 1 session always open?
-with a timmer to get the message form MS Mesage (but i don't realy work with timmer) and use NAS?
-C/FRONT?
I want to transfer data to and from Navision with an other application. The application is on devices of read bar codes.
In the other application are reading the quantyties and item barcode. The process is like this: the items are received based on a Purchase Order which came from Navision into application, in warehouse are reading the item and quantyties and in Navision has to arrive the scan quantity on the Purchase Order.
The other application is on SQL.
I saw the process like this (but maybe is incorrect)
1. In Navison are created the purchase orders
2. The purchase orders must arrive in the SQL . When the purchase orders is create it has be also in SQL, but how:
-using code on Navision to insert in SQL
-using a message via Navision Application Server and a job in SQL
-using C/FRONT (but C/Front I never use and I don't now how it works)?
3.Then came the process of scan. This process has to be syncronuhs in Navision and the other application.You say to build an automatic process and that are severals way to do this.
But what are this ways?
-to run a job scheduler in Navision all the time and have 1 session always open?
-with a timmer to get the message form MS Mesage (but i don't realy work with timmer) and use NAS?
-C/FRONT?
0
Comments
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
And it is easier to do do it.
Navision tables are in SQL quite simply exposed to other applications and you can write to them directly from other application. Or you write your own app (or SQL job) that gets data form one SQL DB to another DB.
Rembmber that one system should be leading - pushing data to other DB and pulling it from other DB. This can be also your third app (job).
It's hard to make Navision leading, since you cannot see other DB.
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯