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

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 14

Project Description

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

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online