MYOB AccountRight Premier Version 19.16 - Import Data

Question

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 :

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 44705 2023-9-2 10043116(07.14) P 52000 "$8,257.00 " "$9,082.70 " SUPERMARKET GST $0.00 $825.70 $0.00 GST $0.00 $0.00 $0.00 B 5 1 30 $0.00 *None 107

SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 44706 2023-9-2 10043118(07.14) P 52000 "$12,217.31 " "$13,439.04 " SUPERMARKET GST $0.00 "$1,221.73 " $0.00 GST $0.00 $0.00 $0.00 B 5 1 30 $0.00 *None 107

SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 44707 2023-9-2 10031162(07.06) P 52000 "$15,344.21 " "$16,878.63 " SUPERMARKET GST $0.00 "$1,534.42 " $0.00 GST $0.00 $0.00 $0.00 B 5 1 30 $0.00 *None 107

SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 44708 2023-9-2 10031167(07.06) P 52000 "$9,606.02 " "$10,566.62 " SUPERMARKET GST $0.00 $960.60 $0.00 GST $0.00 $0.00 $0.00 B 5 1 30 $0.00 *None 107

SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 44709 2023-9-2 10031165(07.06) P 52000 "$16,474.83 " "$18,122.31 " SUPERMARKET GST $0.00 "$1,647.48 " $0.00 GST $0.00 $0.00 $0.00 B 5 1 30 $0.00 *None 107

SINOWELL INTERNATIONAL PNG LTD SOHO ENTERPRISE - RABAUL RABAUL X 44713 2023-9-2 10031151(07.06) P 52000 "$10,623.77 " "$11,686.15 " SUPERMARKET GST $0.00 "$1,062.38 " $0.00 GST $0.00 $0.00 $0.00 B 5 1 30 $0.00 *None 107

Finally, i got a result from MYOBPLOG 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

mike_james · Answer

Hi&nbsp;Koksoon&nbsp;, on the first line of the log, a value 44705 appears:&nbsp;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&nbsp;That value is a date number in Excel which has been converted to a value. You need to format the date column as dates before saving as a text file.

koksoon · Answer

Hi, Mr Mike,&nbsp;May i know how to format the date column from the excel ? Appreciate you can let me know. Thanks a lot for your reply.&nbsp;RegardsKok Soon

mike_james · Answer

Hi&nbsp;Koksoon&nbsp;, dd/mm/yyyy will work.

koksoon · Answer

Hi, Mr Mike,&nbsp;Already tried to format all dates from the excel and import the data again,&nbsp; result still the same, error on invalid date. For your information, the number you highlighted with red colour 44705 is purchase number.&nbsp;&nbsp;RegardsKoksoon&nbsp;

mike_james · Answer

Apologies, I wrote too soon. The date next to it (2 0 2 3 - 9 - 2 1) should be in dd/mm/yyyy format.

Forum Discussion

MYOB AccountRight Premier Version 19.16 - Import Data

10 Replies

Looking for something else?

Related content

MYOB AccountRight Premier Version 19.16 - Import Data

AccountRight Premier v19.16

MYOB AccountRight Plus & MYOB AccountRight Premier

MYOB AccountRight Premier Perpetual Licence

Upgrade from AccountRight Premier V19.5

Pre purchase questions for AccountRight Premier purchase

Importing Items in Accountright Premier

How do I move from Accountright to Accountright Premier?

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	44705	02-09-2023	10043116(07.14)		P		52000	$8,257.00	$9,082.70			SUPERMARKET		GST	$0.00	$825.70	$0.00			GST	$0.00	$0.00	$0.00	B			5	1	30		$0.00		*None	107

SINOWELL INTERNATIONAL PNG LTD		SOHO ENTERPRISE - RABAUL	RABAUL			X	44706	02-09-2023	10043118(07.14)		P		52000	$12,217.31	$13,439.04			SUPERMARKET		GST	$0.00	$1,221.73	$0.00			GST	$0.00	$0.00	$0.00	B			5	1	30		$0.00		*None	107

SINOWELL INTERNATIONAL PNG LTD		SOHO ENTERPRISE - RABAUL	RABAUL			X	44707	02-09-2023	10031162(07.06)		P		52000	$15,344.21	$16,878.63			SUPERMARKET		GST	$0.00	$1,534.42	$0.00			GST	$0.00	$0.00	$0.00	B			5	1	30		$0.00		*None	107

SINOWELL INTERNATIONAL PNG LTD		SOHO ENTERPRISE - RABAUL	RABAUL			X	44708	02-09-2023	10031167(07.06)		P		52000	$9,606.02	$10,566.62			SUPERMARKET		GST	$0.00	$960.60	$0.00			GST	$0.00	$0.00	$0.00	B			5	1	30		$0.00		*None	107

SINOWELL INTERNATIONAL PNG LTD		SOHO ENTERPRISE - RABAUL	RABAUL			X	44709	02-09-2023	10031165(07.06)		P		52000	$16,474.83	$18,122.31			SUPERMARKET		GST	$0.00	$1,647.48	$0.00			GST	$0.00	$0.00	$0.00	B			5	1	30		$0.00		*None	107

SINOWELL INTERNATIONAL PNG LTD		SOHO ENTERPRISE - RABAUL	RABAUL			X	44713	02-09-2023	10031151(07.06)		P		52000	$10,623.77	$11,686.15			SUPERMARKET		GST	$0.00	$1,062.38	$0.00			GST	$0.00	$0.00	$0.00	B			5	1	30		$0.00		*None	107