Find Jobs
Hire Freelancers

Create a custom Access query for Skus, barcodes and QTY

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
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. -----------------------------------------------------------------------------------------------------------
Project ID: 6464983

About the project

1 proposal
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
hi.. i am expert in query for ms access..please send me sample table according your situation regards bahrul
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
MIAMI, United States
5.0
18
Payment method verified
Member since Dec 16, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.