Find Jobs
Hire Freelancers

Create a custom Access query for Skus, barcodes and QTY

$10-30 USD

Complété
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
Décerné à :
Avatar de l'utilisateur
hi.. i am expert in query for ms access..please send me sample table according your situation regards bahrul
$25 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
MIAMI, United States
5,0
18
Méthode de paiement vérifiée
Membre depuis déc. 16, 2011

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.