Format Excel File for Jonas Construction Software AP Import
$250-750 USD
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.
Rif. progetto: #15698128
Info sul progetto
13 freelance hanno fatto un'offerta media di $428 per questo lavoro
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
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
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
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
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
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