Need a piece of software to convert Excel file to TXT for uploading to MYOB

Need a piece of software that will take file called "Synaps 3 [url removed, login to view]" and convert into format like "output may [url removed, login to view]" for me to upload into MYOB. (Sample files are attached)

Software needs to allow"

- Importing xls in format provided

- Smart enough to know that that if the field in "Synaps 3 [url removed, login to view]" call "Amount Paid" is empty or 0 then ignore line.

- Have the ability to allocate product code to the Description in field called "Shipping method" i.e $4.99 FRDLE Courier to NON RURAL address = FRDLE and use as a sales line in export file. There should be ability to add multiple variable into the software for this and allocate Stock code against it.

- The Following is how the fields are mapped in the "output" file compared to the Input file

Co./Last Name = Source

First Name = No used

Addr 1 - Line 1 = Shipping address

- Line 2 = Shipping address

- Line 3 = Shipping address

- Line 4 = Shipping address

Invoice No. = Blank as this is generated by MYOB

Date = Sale Date

Customer PO = Reference

Ship Via = This should be be linked to "Freight stock code" i.e FRDLE = Courier Post or FRNZPOST = NZ Post

Delivery Status = P

Item Number = Product Code

Quantity = Qty Sold

Description = Blank as MYOB picks this up

Price = Sales Price

Inc-GST Price = Sale Price

Discount = 0

Total = Sale price X Qty

Inc-GST Total = Sale price X Qty

Job = Blank

Comment = Ship Ref

Journal Memo = Sale;Source i.e Sale;Trademe or Sales;Sella

Salesperson Last Name = Blank

Salesperson First Name = Blank

Shipping Date = Blank

GST Code = NT

GST Amount = 0

Freight Amount = BLANK

Freight GST Code = NT

Freight GST Amount = 0

Sale Status = I

Terms - Payment is Due = 1

- Discount Days = 0

- Balance Due Days = 0

- % Discount = 0

- % Monthly Charge = 0

Referral Source = Blank

Amount Paid = Blank

Payment Method = Blank

Payment Notes = Blank

Name on Card = Blank

Card Number = Blank

Expiry Date = Blank

Authorisation Code = Blank

Cheque Number = Blank

Inclusive = X

Category = Blank

Card ID = Linked to Source, Should have ability to set in software ie: Source = Trade Me = Card ID: TRADE ME, Record ID = 5

Record ID = Linked to Source

Habilidades: Programación en C, Ingeniería, Arquitectura de software, Visual Basic, Windows Desktop

Ver más: visual basic programming notes, the courier journal, smart software inc, smart input, record journal, programming job address, programming in excel 2013, programming ability test, post and courier, nt job, myob price, journal and courier, job nt, job in nt, job id card, job courier, job as courier, job as a courier, i need sale job, i need a programming job

Información del empleador:
( 21 comentarios ) Auckland, New Zealand

Nº del proyecto: #4321045

12 freelancers están ofertando el promedio de $159 para este trabajo


I am an Excel macro expert and can take on the job. Let me know.

$250 USD en 3 días
(131 comentarios)

I'm an expert database application developer and can develop this software for you as a Windows application using Delphi. Can deliver in 3 days. Thank you for considering my bid. Sincerely, Larry

$250 USD en 5 días
(34 comentarios)

have 7+ experience in programming. Ready to work on your project

$150 USD en 3 días
(19 comentarios)

I am very proficient in c and MS files operation. I have 15 years c++ developing experience now, and I have worked for 5 years, please let expert help you.

$125 USD en 4 días
(14 comentarios)

More than 10 years experience in Excel and VBA.

$156 USD en 4 días
(8 comentarios)

Hi, could you check my PM, please?

$150 USD en 2 días
(4 comentarios)

excel vba expert to complete all ur project requirement.

$100 USD en 2 días
(4 comentarios)

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement. I can create an Excel Macro that will allow you to convert the file.

$75 USD en 5 días
(7 comentarios)

Hi,Please check PMB

$128 USD en 4 días
(6 comentarios)

Greetings, I'm expert in this kind of utility programs. I have provided a demo for you.

$175 USD en 1 día
(1 comentario)

consider it done . !!! check pm.

$200 USD en 6 días
(2 comentarios)

A have a lot of experience in operating with files. I have written the complete software for Magnet Mapping system which, among other things, save the measurements into txt file and generates various kinds of reports f Más

$100 USD en 7 días
(3 comentarios)

I can do this project. I can make a software which convert .xls file into the .txt file format. The software will read all the string from the .xls file and convert if into the .txt output file as per your requiremen Más

$250 USD en 10 días
(0 comentarios)

Hi, very simple for me. Please see PM.

$200 USD en 2 días
(0 comentarios)