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

Cancelled

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 $[url removed, login to view] 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

Skills: C Programming, Engineering, Software Architecture, Visual Basic, Windows Desktop

See more: 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, i need a code for programming, excel add in programming, delivery by courier, courier journal, courier job

Project ID: #4321045

12 freelancers are bidding on average $159 for this job

deepbluetech

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

$250 USD in 3 days
(131 Reviews)
5.4
expertcoder1vw

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 in 5 days
(34 Reviews)
5.2
rajhansh

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

$150 USD in 3 days
(19 Reviews)
4.2
hbxfnzwpf

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 in 4 days
(14 Reviews)
4.1
adim

More than 10 years experience in Excel and VBA.

$156 USD in 4 days
(8 Reviews)
4.1
WangJinHao

Hi, could you check my PM, please?

$150 USD in 2 days
(4 Reviews)
3.1
vikashgadia

excel vba expert to complete all ur project requirement.

$100 USD in 2 days
(4 Reviews)
2.8
vgrichards

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 in 5 days
(7 Reviews)
2.8
srdas2012

Hi,Please check PMB

$128 USD in 4 days
(6 Reviews)
2.6
igors233

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

$175 USD in 1 day
(1 Review)
2.0
pythonshell

consider it done . !!! check pm.

$200 USD in 6 days
(2 Reviews)
1.9
Nenad1526

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 More

$100 USD in 7 days
(3 Reviews)
1.6
halfbloodprince2

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 More

$250 USD in 10 days
(0 Reviews)
0.0
myax

Hi, very simple for me. Please see PM.

$200 USD in 2 days
(0 Reviews)
0.0