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: salary slip format excel file, changing format excel file perl script, format excel file using visual basic, 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, excel, accounting, financial analysis, bookkeeping, microsoft excel, 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



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 Fazla

%selectedBids___i_period_sub_7% gün içinde 294%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(173 Değerlendirme)

Bu iş için 13 freelancer ortalamada $428 teklif veriyor


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 Daha Fazla

in %bids___i_period_sub_35% gün içinde705%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(530 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(264 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde345%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(146 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(51 Değerlendirme)
in %bids___i_period_sub_35% gün içinde588%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(139 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(53 Değerlendirme)
in %bids___i_period_sub_35% gün içinde260%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(99 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde470%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde352%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(72 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(32 Değerlendirme)