Hi
We will implementing NAV 5,but our client will using BARCODE SCANNER for their ITEM…My question is if we needed for Third Party Tool(ex. LSR) to use the Scanner? or NAV 5 can handle That with Third party…
hoping for your reply
TY
Hi
We will implementing NAV 5,but our client will using BARCODE SCANNER for their ITEM…My question is if we needed for Third Party Tool(ex. LSR) to use the Scanner? or NAV 5 can handle That with Third party…
hoping for your reply
TY
Barcode scanner attached to computer work fine in Navision. You print your barcodes from Nav as well.
We use Symbol radio frequency scanners, running MCL software. We have a dedicated PC running MCL-Net, which communicates with the scanners via the RF network, and also via ODBC to the Navision SQL database for on-line validation that the scanners request.
We then have a bespoke application written in Navision, which picks up scanned transactions from the dedicated PC (from a flat file), and uploads them to Navision. I would advise against letting the scanners update Navision directly. Control this using lots of error checking, using Navision code.
We used a third party to help us set all this up. It’s a lot of work to set up, but scanners are really useful for the users.
Andy
Hi Andy
A newbie to NAV, Navision and this forum, I’m currently managing a project on a deploying a Fixed Asset System. Also, the company will soon be migrating its ledgers to NAV 2009 (currently uses Navision). I’m evaluating a number of fixed asset solutions, including NAV 2009’s Fixed Asset granules but the NAV evaluation is stalling a bit.
Issue
Our NAV partner does not have capability to integrate an off the shelf mobile barcode scanner and its software, yet to be bought, with NAV 2009 to track fixed asset lifecycle changes.
You mentioned that you used a third party to help you set all this up. It’s a lot of work to set up, but scanners are really useful for the users.
Question
Who was the 3rd party and how much did they charge?
Thanks
Vela Kuhen
first, in your process design, what the scanner will do and what/how you plan to update NAV? this is what you need to plan.
normally barcode is used to represent code or no… what the handheld will read is the code or no. of the item. then, you need a few more coding to allow updating into NAV.
i have made some automation tasks in production floor and warehousing using barcode to update journals in NAV.
but first, you need to describe further on your plan.
Dear Joe
Thanks for replying. Attached picture illustrates how the two of the projects I’m working on (A Fixed Assets and a Helpdesk deployement) will come together to enable asset management in a more structured and controlled manner. The top of the picture shows the stages in asset life-cycle and the bottom part shows what happens when an asset is taken out for repairs and then gets redeployed. It’s not set in concrete, as we are yet to finalise the policies and procedures, but illustrates how asset management should work. If NAV is used, the green and red arrows are manual updates performed by relevant staff, as the two systems will not be integrated.
Note: Where it says “Asset Scanned” we need a barcode scanner that can scan and update the info.
I hope this answers your question. Please help.
Thanks
Kuhen
what you plan to do when ‘engineer sent to location’ and when ‘asset returned’?
it seems to me, you have 2 options, FA Reclass. Journal or Maintenance.
when you use FA Reclass;
you can use dataport to interface the bacode captured data into FA Reclass. table, and you automate the other required entries to other fields, then user can open the FA Recalss. Journal form and post. This is simpler but you don’t see the process.
when you use Maintenance procedure, the basic is the same, but you need to work with Purchase Invoice and Maintenance Registration. you can use dataport to update 2 tables, Purchase Invoice and Maintenance Registration.
Hi Joe,
Thanks for the reply.
Question: How big of a taks is using " dataports" to reconcile barcoded database with NAV Fixed Asset granules.
If NAV is chosen, we’ll go for all fixed asset granules except insurance. Our NAV partner is estimating many thousands to develop NAV Fixed Asset granule compatability with an off the shelf barcode software and many thousands more if a non-NAV fixed asset solution is chosen.
As our accounting system is NAV 2009, which option is less developement intensive?
Whichever the system we choose will have to improve employee productivty at the right price but price alone is not the deciding factor.
Thanks
Kuhen
i cannot say precisely, but you need to talk with your consultant / partner, because the partner will do the work for you.
you need to clear yourself on the 2 parts involving barcode scanning, design and document it. so then when you meet partners, they can work with the simplest and most effective solution.
if you say, it involve thousands, may be what you describe is not the whole scope of requirement. it should be more complex than just scanning matter.
Hi Joe - Thank you very much for the response. Apologies for my late reply.
One vendor with experience in integrating Navision fixed assets with asset tracking system says this is how our requirements would be met. On paper it works for us. Do you foresee any technical issues within NAV 2009 by following the below steps?
Thanks
Kuhen
Items are scanned via the barcode scanner and salient information is included at the time of scanning on the scanner itself.
Barcode Scanner is downloaded using a simple desktop utility. The output file is in csv format
A script within Navision picks up the file and adds the new assets to the database (the vendor will work with our NAV partner, requires half a day’s work, on the scripting side)
Items to be delivered to customers are scanned against a customer number barcode.
Barcode Scanner is downloaded using a simple desktop utility.
A script within Navision picks up the file and records the assets new location.
Items to be disposed are scanned
Barcode Scanner is downloaded using a simple desktop utility.
A script within Navision picks up the file and records the asset disposals (including reasons etc).
Location details recorded on scanner either manually or via location barcode.
All items within the location are scanned
Barcode Scanner is downloaded using a simple desktop utility.
A script within Navision picks up the file and records the asset status (missing, found, relocated, as per database)
it’s basic operation. i believe it can work well for your company. also, it takes shorter time to develop the required dataport, or other object ; at least when compared to integrating to another barcode featured software into NAV.
good luck.
Thanks Joe and Others for your considered responses. I’ll close this thread now.
[:D]