Error 0: Unexpected import error - Object reference not set to an instance of an object

Question

Hello,

I received the above error message and my files were skipped.

I tried to import a new sale from a third party software (Shiftcare), chose service sale (as it is services relating to the NDIS), i matched the items correctly (to the best of my knowledge). I don't know what could be wrong. I have attached the error report log screenshot.

Any help would be greatly appreciated.

importlog 14.11 error report MYOB.txt

CloverQ · Answer

Hi @xranton

No worries. Importing often takes a bit of trials and errors to get it right. Whenever you are stuck with no clue, the best way is recording the same transaction in AccountRight then export it, comparing the exported time with your import file in Excel to spot the difference. Fix and test your import file with 1-2 transactions only until it imports successfully, then you can prepare the rest of the data the same way.

When you do the find the time to test it, I'd suggest to check out these Help articles, they should guide you through it:

Using an import template

Importing and exporting tips

Import options

Please feel free to let us know how you go.

xranton · Answer

Hi @CloverQ,

Thank you for your reply.

I am not really proficient in using MYOB to the full extend as is not my job really. I will try to do some tricks probably next week, when i will have some time. It is more that certain though,  that i will need your assistance, please.

I'll let you know when the time  is right.

Kind regards,

Christos Antoniadis

CloverQ · Answer

Hi @xranton

Thank you for the update.

It's very helpful to know that service layout is the one to use for this sales transaction. Then as explained in my initial reply, record this transaction in AccountRight manually, export it so you can compare the exported file with your import file using Excel to spot the difference.

Please feel free to let us know how you go.