Forum Discussion

Experienced User

4 years ago

Solved

Duplicate Journal Entries on Import

Hello, We have a billing system that is seperate to AccountRight and each day we hve a journal batch that is created that we import to bring those transactions into AccountRight. We have had instances where there have been duplicated transactions. I ahve checked and the transactions do not exist in the import file. THis has happened several times and initial we though it was just a user error accidentally importing teh file twice. We are now very careful and beleive that this is not the case but are still getting isntances of transactions being duplicated. Has anyone come across this before ?

Thanks

Karen

Komal_S
3 years ago
Hi KarenP1

We have investigated your import file and there are duplicate records in the import file itself due to which duplicate records are being imported. Please clean the import file and ensure one transaction ID is only entered once and you will be able to import succesfully.

Feel free to post should you have further queries.

5 Replies

Replies have been turned off for this discussion

SupportNoteGuy
MYOB Staff
3 years ago
Hi KarenP1 - sorry for the late reply, and sorry to hear about your strange importing issue...

I haven't come across anything like this before - are you still experiencing the issue?
KarenP1
Experienced User
3 years ago
Hi Adrian
We seem to have the issue intermittantly, and yes unfortunately we are still having the problem. Not sure what the solution is to be honest as I can't work out what the trigger is
thanks
Karen
Komal_S
MYOB Staff
3 years ago
Hi KarenP1

Are those entries automatically imported through API from the third-party app or do you manually import them using File>>Import/Export Assistant? If the import is manual, please attach a sample import file here so we can test this further.

If not, the issue would be with the integration between the third-party app and the software, in which case you would have to reach out to the billing system to get this fixed.
KarenP1
Experienced User
3 years ago
Hi Komal

The files are manually imported using the File->Import/Export Asissitant. I've attached an example file.

thanks
Karen
PCPAS-MYOB Journals 2022-03 Batch 00666 (2022-03-11).txt114 KB
Komal_S
MYOB Staff
3 years ago
Hi KarenP1

We have investigated your import file and there are duplicate records in the import file itself due to which duplicate records are being imported. Please clean the import file and ensure one transaction ID is only entered once and you will be able to import succesfully.

Feel free to post should you have further queries.