Create a custom Access query for Skus, barcodes and QTY
$10-30 USD
Publié il y a plus de 9 ans
$10-30 USD
Payé lors de la livraison
We are using Stoneedge order manager for our inventory control. We just realized that we can't import our Bar-code and the Quantity on hand (QOH) into the system without also including the sku on the same line. This is a problem because we want to be able to scan the bar-codes and count inventory using an app for iPhone call "scan to spreadsheet". From what I have researched it looks like a we need custom Access query to help us with this. Please see the article I found of another user that faced the same problem we have. You will see the reply by Barney Stone at the bottom with a suggestion for a work around to the problem.
[login to view URL]
-----------------------------------------------------------------------------------------------------------
update inventory using only Barcode and QOH?
Printed from: Monsoon Stone Edge User Forum
Topic URL: [login to view URL]
Printed on: 09/16/2014
Topic:
Topic author: mytoybox
Subject: update inventory using only Barcode and QOH?
Posted on: 07/28/2004 1:21:34 PM
Message:
We are about to change our inventory system to use OM and barcoded inventory. The problem is our products all have localSku's that have nothing to do with the barcode #. We were hoping to just add the barcode into the appropriate field in the product form for all the products and then batch download a .csv file with all of our barcodes and the current QOH using the import inventory function. However, the product name and localSku are required fields. I hope this does not mean we have to enter the product name and localSku into the .csv file before importing as that would be a major undertaking and negate any time savings. Can the localsku and product name be changed from mandatory to optional? or is there another way to update our QOH using only th barcode nad QOH?
Replies:
Reply author: Barney Stone
Replied on: 07/28/2004 1:30:44 PM
Message:
The current program cannot import quantity on hand info just using barcodes to indicate which product is which. We could either modify the program to do that, or we could create a custom query to do it. If you are familiar with Access queries, you could also do that yourself. What you need is an Update Query that will update the QOH field based on the Barcode.
Hope that helps,
Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
Monsoon Stone Edge User Forum : [login to view URL]
© Monsoon Commerce, Inc.
-----------------------------------------------------------------------------------------------------------
N° de projet : 6464983
Concernant le projet
1 proposition
Projet à distance
Actif à il y a 10 ans
Cherchez-vous à gagner de l'argent ?
Avantages de faire une offre sur Freelancer
Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux