Devam Ediyor

Format Excel File for Jonas Construction Software AP Import

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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını görün: jonas accounting software manual, jonas login, jonas software training, jonas premier construction software, launch jonas, jonas premier login, premier construction software pricing, jonas premier reviews, salary slip format excel file, changing format excel file perl script, format excel file using visual basic, book format excel file, import excel file magento, import data excel file perl, import large excel file multiple worksheets

İşveren Hakkında:
( 0 değerlendirme ) Danville, United States

Proje NO: #15698128

Seçilen:

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 Daha fazlası

10 gün içinde 294$ USD
(173 Değerlendirme)
6.4

13 freelancers are bidding on average $428 for this job

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community [url removed, login to view]) Relevant Skills and Experience I am an En Daha fazlası

in 5 gün içinde705$ USD
(530 Değerlendirme)
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 Daha fazlası

in 3 gün içinde350$ USD
(264 Değerlendirme)
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 Daha fazlası

in 7 gün içinde345$ USD
(146 Değerlendirme)
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 Daha fazlası

in 5 gün içinde500$ USD
(51 Değerlendirme)
6.8
in 5 gün içinde588$ USD
(139 Değerlendirme)
6.1
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 Daha fazlası

in 7 gün içinde350$ USD
(53 Değerlendirme)
6.1
in 10 gün içinde260$ USD
(99 Değerlendirme)
6.1
dgled

Hi, I have experience in transferring and manipulating accounting databases to [url removed, login to view] files and vice versa. Relevant Skills and Experience I am a professional financial and a guru in Excel and VBA. I create creat Daha fazlası

in 10 gün içinde750$ USD
(37 Değerlendirme)
5.8
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 Daha fazlası

in 5 gün içinde470$ USD
(62 Değerlendirme)
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 Daha fazlası

in 10 gün içinde350$ USD
(30 Değerlendirme)
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 Daha fazlası

in 10 gün içinde352$ USD
(72 Değerlendirme)
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 Daha fazlası

in 3 gün içinde250$ USD
(32 Değerlendirme)
4.3