Format Excel File for Jonas Construction Software AP Import

Completato Pubblicato 6 anni fa Pagato alla consegna
Completato Pagato alla consegna

We are an electrical wholesale distribution company. We try and provide valuable services to our customers. I have a customer that would like to import invoices automatically into their system. Typically this is pretty easy to do but this particular customer uses software that has some very unique requirements for importing. I need to have an excel file manipulated automatically with a VBA macro in Excel to allow importing data into the Jonas Construction software. I will provide the raw data from our ERP system in an Excel or CSV file. I would like to have a macro run that will do all the formatting and data manipulation necessary to allow the file to be imported. There are certain values that the user will need to be prompted to enter before formatting. I've attached an example file. This one was manually compiled. The file must start with a H (header) record followed by ab I (invoice record - provided from our ERP system (second attachment) and then a D (Distribution) record. The distribution record is in reference to the I record above it. This D record is used to distribute the invoice to the correct GL account. Then the file will continue with additional invoice and distribution records.

Inserimento Dati Elaborazione dati Excel Visual Basic Visual Basic per App

Rif. progetto: #15698128

Info sul progetto

13 proposte Progetto a distanza Attivo 6 anni fa

Assegnato a:

Harun1986

Hello, I am excel expert and I can make a useable excel that can follow automatically. I will follow your instruction and make exact macro what you want. Relevant Skills and Experience I have the best experience with Altro

$294 USD in 10 giorni
(173 valutazioni)
6.4

13 freelance hanno fatto un'offerta media di $428 per questo lavoro

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Altro

$705 USD in 5 giorni
(530 valutazioni)
8.0
seaanddream

Hi, my name is Sevinc. I read your "Format Excel File for Jonas Construction Software AP Import" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and read Altro

$350 USD in 3 giorni
(264 valutazioni)
7.5
someka

Hello. I have checked your raw data and import data. I have recently completed two quite similar projects. User enter parameters, clicks the button and macro makes the manipulation automatically and gives you a .CSV ou Altro

$345 USD in 7 giorni
(146 valutazioni)
7.0
Vlzinch

Hi, JesterRU! I saw your requirements and I'm 100% confident that I can do this task. I have 10 years experience in Excel and VBA with hundreds of successfully completed projects. Relevant Skills and Experience I hav Altro

$500 USD in 5 giorni
(51 valutazioni)
6.8
shoguna2m

Hello, my name is Andrés. First of all, thank you for considering my bid. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this Altro

$350 USD in 7 giorni
(53 valutazioni)
6.1
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications Relevant Skills and Experience Excel VBA Altro

$470 USD in 5 giorni
(62 valutazioni)
5.8
vw7209238vw

Hi, I can develop the bridge you need to parse the needed data from the excel or csv file . Just need all material to start. Th csv as sample is not showing data Relevant Skills and Experience I have all skills you re Altro

$350 USD in 10 giorni
(30 valutazioni)
5.0
vsprybhanu

Hi, I can format your excel file according to upload the file into software. I have excellent knowledge and experience of manipulating data and apply formatting through VBA programming. Relevant Skills and Experience Altro

$352 USD in 10 giorni
(72 valutazioni)
5.3
nurnga1218

Hi, I don't have any idea with Jonas Construction Software but, if you provide your exact format to be imported (you already attached) well I can make it as you want. Relevant Skills and Experience I am an excel and m Altro

$250 USD in 3 giorni
(32 valutazioni)
4.3