Forum Discussion

Koksoon's avatar
Koksoon
Contributing User
2 years ago

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 :

 

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's avatar
    Mike_James
    Ultimate Cover User

    Hi Koksoon , on the first line of the log, a value 44705 appears:

     

    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

     

    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's avatar
      Koksoon
      Contributing User

      Hi, Mr Mike,

       

      May i know how to format the date column from the excel ? Appreciate you can let me know. Thanks a lot for your reply.

       

      Regards

      Kok Soon