MYOB AccountRight Premier Version 19.16 - Import Data
Hi, i am using MYOB AccountRight Premier version 19.16 and trying to import data to purchases section. First of all, i am using export data template file from service purchases as below :
Co./Last Name First Name Addr 1 - Line 1 - Line 2 - Line 3 - Line 4 Inclusive Purchase # Date Supplier Invoice # Ship Via Delivery Status Description Account # Amount Inc-Tax Amount Job Comment Journal Memo Shipping Date Tax Code Non-GST Amount GST Amount Import Duty Amount Freight Amount Inc-Tax Freight Amount Freight Tax Code Freight Non-GST Amount Freight GST Amount Freight Import Duty Amount Purchase Status Currency Code Exchange Rate Terms - Payment is Due - Discount Days - Balance Due Days - % Discount Amount Paid Category Card ID Record ID
SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 00044705 2023-09-01 10043116(07.14) P 52000 $8,257.00 $9,082.70 SUPERMARKET GST $.00 $825.70 $.00 GST $.00 $.00 $.00 B 5 1 30 $.00 *None 107
SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 00044706 2023-09-01 10043118(07.14) P 52000 $12,217.31 $13,439.04 SUPERMARKET GST $.00 $1,221.73 $.00 GST $.00 $.00 $.00 B 5 1 30 $.00 *None 107
SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 00044707 2023-09-01 10031162(07.06) P 52000 $15,344.21 $16,878.63 SUPERMARKET GST $.00 $1,534.42 $.00 GST $.00 $.00 $.00 B 5 1 30 $.00 *None 107
SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 00044708 2023-09-01 10031167(07.06) P 52000 $9,606.02 $10,566.62 SUPERMARKET GST $.00 $960.60 $.00 GST $.00 $.00 $.00 B 5 1 30 $.00 *None 107
SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 00044709 2023-09-01 10031165(07.06) P 52000 $16,474.83 $18,122.31 SUPERMARKET GST $.00 $1,647.48 $.00 GST $.00 $.00 $.00 B 5 1 30 $.00 *None 107
SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 00044713 2023-09-01 10031151(07.06) P 52000 $10,623.77 $11,686.15 SUPERMARKET GST $.00 $1,062.38 $.00 GST $.00 $.00 $.00 B 5 1 30 $.00 *None 107
I used the above export data template to amend the date from 2023-09-02 and import data to the service purchases as below :
-10
S I N O W E L L I N T E R N A T I O N A L P N G L T D S O H O E N T E R P R I S E - R A B A U L R A B A U L X 4 4 7 0 5 2 0 2 3 - 9 - 2 1 0 0 4 3 1 1 6 ( 0 7 . 1 4 ) P 5 2 0 0 0 " $ 8 , 2 5 7 . 0 0 " " $ 9 , 0 8 2 . 7 0 " S U P E R M A R K E T G S T $ 0 . 0 0 $ 8 2 5 . 7 0 $ 0 . 0 0 G S T $ 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 B 5 1 3 0 $ 0 . 0 0 * N o n e 1 0 7
S I N O W E L L I N T E R N A T I O N A L P N G L T D S O H O E N T E R P R I S E - R A B A U L R A B A U L X 4 4 7 0 6 2 0 2 3 - 9 - 2 1 0 0 4 3 1 1 8 ( 0 7 . 1 4 ) P 5 2 0 0 0 " $ 1 2 , 2 1 7 . 3 1 " " $ 1 3 , 4 3 9 . 0 4 " S U P E R M A R K E T G S T $ 0 . 0 0 " $ 1 , 2 2 1 . 7 3 " $ 0 . 0 0 G S T $ 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 B 5 1 3 0 $ 0 . 0 0 * N o n e 1 0 7
S I N O W E L L I N T E R N A T I O N A L P N G L T D S O H O E N T E R P R I S E - R A B A U L R A B A U L X 4 4 7 0 7 2 0 2 3 - 9 - 2 1 0 0 3 1 1 6 2 ( 0 7 . 0 6 ) P 5 2 0 0 0 " $ 1 5 , 3 4 4 . 2 1 " " $ 1 6 , 8 7 8 . 6 3 " S U P E R M A R K E T G S T $ 0 . 0 0 " $ 1 , 5 3 4 . 4 2 " $ 0 . 0 0 G S T $ 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 B 5 1 3 0 $ 0 . 0 0 * N o n e 1 0 7
S I N O W E L L I N T E R N A T I O N A L P N G L T D S O H O E N T E R P R I S E - R A B A U L R A B A U L X 4 4 7 0 8 2 0 2 3 - 9 - 2 1 0 0 3 1 1 6 7 ( 0 7 . 0 6 ) P 5 2 0 0 0 " $ 9 , 6 0 6 . 0 2 " " $ 1 0 , 5 6 6 . 6 2 " S U P E R M A R K E T G S T $ 0 . 0 0 $ 9 6 0 . 6 0 $ 0 . 0 0 G S T $ 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 B 5 1 3 0 $ 0 . 0 0 * N o n e 1 0 7
S I N O W E L L I N T E R N A T I O N A L P N G L T D S O H O E N T E R P R I S E - R A B A U L R A B A U L X 4 4 7 0 9 2 0 2 3 - 9 - 2 1 0 0 3 1 1 6 5 ( 0 7 . 0 6 ) P 5 2 0 0 0 " $ 1 6 , 4 7 4 . 8 3 " " $ 1 8 , 1 2 2 . 3 1 " S U P E R M A R K E T G S T $ 0 . 0 0 " $ 1 , 6 4 7 . 4 8 " $ 0 . 0 0 G S T $ 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 B 5 1 3 0 $ 0 . 0 0 * N o n e 1 0 7
0 records imported without errors.
1 records skipped.
0 records imported with warnings.
Error -10: Invalid date.
May i know what is Error -10 ? What kind of invalid date is it ?
Thanks & regards
Koksoon
