Færdiggjort

I need excel or my access programer

I need an automatic inventory reconciliation on excel to do the following:

1. The system should be able to pull the flat file, .csv or txt file and compare Quickbook inventory list that has been exported from Quickbooks.

2. The system should flag each serial number to prompt or message:

S/N Not Found

S/N Found

S/N Wrong Location

S/N Duplicate

S/N "Misread" (This Functional Requirement will dive into Quickbooks database to pull a labeling system A,B,C for inventory count)

S/N "Item Found Not Scanned" (This Functional Requirement will dive into Quickbooks database to pull a labeling system A,B,C for inventory count) This will have another S/N on the Box to indicate three sleeves of inventory. A - B -C , Some boxes will have only A - B serial number that indicate 2 sleeves...etc.:

Boxes defined:

box 1: will have 30 units with three sleeves of 10

box 2: will have 27 units with three sleeves of 9

box 3: will have 20 units with two sleeves of 10

box 4: will have 120 unites with six sleeves of 20

All of these functionalities will enable my warehouse to have a true inventory reconciliation process.

Evner: Excel, Excel Macros, Excel VBA, Microsoft Access, Programming

Se mere: I need excel work, i need excel help in agra, i need excel help, when to use access instead of excel, how to use access with excel, benefits of access over excel, access vs excel reddit, access vs excel pros and cons, excel vs access differences, why use access, microsoft access, data entry, data processing, excel, visual basic, microsoft office, microsoft excel, i need excel freelancer, i need an access database, i need a computer programer friend

Om arbejdsgiveren:
( 1 bedømmelse ) COSTA MESA, United States

Projekt ID: #17095405

Tildelt til:

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$150 USD in 10 dage
(204 bedømmelser)
6.8

9 freelancere byder i gennemsnit $115 på dette job

zu02

Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'm programmer/mathematician since 197 Flere

$250 USD in 3 dage
(50 bedømmelser)
6.1
TechnoGuruu

Hello, I am an IT expert having 10+ years of experience in MS-Excel, functions, macros and automation etc. I checked your project details that you want excel macros to compare data which you exported CSV/Txt from yo Flere

$98 USD in 7 dage
(45 bedømmelser)
5.2
Salesj23

hi there I am an excel and access vba programmer with ability to apply interactive code that will automate the whole of your file as per the instructions depending on the imported file from quickbooks and return the i Flere

$72 USD in 3 dage
(10 bedømmelser)
3.7
alhassanlatif

Hi, I am a professional Access developer I have done many great projects in Access have a look at my profile and I can finish your project. It seems to be not complicated one Send me more details about the work

$88 USD in 3 dage
(2 bedømmelser)
2.9
Sindustrus

hi i am expert in excel vba and macros please consider

$30 USD på 1 dag
(2 bedømmelser)
2.5
FasihMahmoud

Will be to end the project in less than three days Relevant Skills and Experience Will be to end the project in less than three days

$155 USD in 3 dage
(0 bedømmelser)
0.0
$111 USD in 2 dage
(0 bedømmelser)
0.0
$83 USD in 7 dage
(0 bedømmelser)
0.0