EVOPOS can export files ready to be imported into MYOB.


They are 3 formats to choose from:

  • MYOB Sales Export (Reduced Fields)
  • MYOB Sales Export (All Fields)
  • MYOB Retail Manager Format

Setup

Setting the export format and file location:


Exporting the File

The export file will be created when you close the batch in EVOPOS.


By setting the export program in the setup, EVOPOS will export the file when closing the batch in Sales\Options\Close Batch.




MYOB Retail Manager Format

This export uses the same method of exporting as MYOB Retail Manager to MYOB Accounting.


The Nominal accounts defaults are listed below, however they can be changed in Accounts / Nominal by entering the MYOB Nominal code in the Export Code. For example if you wanted the MYOB Nominal for Sales Department 1 to be 41000 you would go to Evopos Nominal: 04-01-01 and enter: 41000 in the Export Code.



Evopos Nominal MYOB Defaults

  • Purchase Orders (Stk-In) 01-01-01 - 11300
  • Inventory Adjmt (Stk-Out) 01-01-01 - 11300
  • Inventory Adjmt (COGS) 05-01-01 - 51000
  • Debtor Difference 01-07-01 - 11200
  • Payments Received 01-09-01 to 01-09-99 - 11101 to 11199
  • Sales (Dept 1 to 9) 04-01-01 to 04-01-09 - 41001 to 41009
  • Sales Difference 04-01-01 - 41001


Note: 

The difference between Sales and Payments Received is normally the Debtor Difference. If this does not match (Settlement Discounts etc) the difference will be entered in the Sales Difference.


Evopos will create the file with the Purchase Orders first, and then the other entries grouped by each day. This means you get summary figures for each day and not the individual transactions. Sales are divided by Department and Payments Received are divided by the Payment Method.



MYOB Sales Export (Reduced Fields)

Individual Items by Transaction. Tab delimited chr(9)

CardName

SaleDate

Part_No

Qty

Description

UnitNet

TotalNet

TotalInc

TaxCode

Tax

LocationID


MYOB Sales Export (All Fields)

Individual Items by Transaction. Full number of fields. Tab delimited chr(9)

Co./Last Name

First(Name)

Addr 1 - Line 1

"- Line 2

- Line 3

- Line 4

Inclusive

Invoice #

Date

Customer(PO)

Ship(Via)

Delivery(Status)

Item(Number)

Quantity

Description

Price

Inc-Tax Price

Discount

Total

Inc-Tax Total

Job

Comment

Journal(Memo)

Salesperson Last Name

Salesperson First Name

Shipping Date

Referral(Source)

Tax Code

Non-GST Amount

GST(Amount)

LCT(Amount)

Freight(Amount)

Inc-Tax Freight Amount

Freight Tax Code

Freight Non-GST Amount

Freight GST Amount

Freight LCT Amount

Sales(Status)

Currentcy(Code)

Exchange(Rate)

Terms(-Payment Is Due)

- Discount Days

- Balance Due Days

- % Discount

- % Monthly Charge

Amount(Paid)

Payment(Method)

Payment(Notes)

Name on Card

Card(Number)

Expiry Date

Authorisation(Code)

BSB

Account(Number)

Drawer/Account Name

Cheque(Number)

Category

Location(ID)

Card(ID)

Record(ID)