Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
July 2021
July 2021
Import customer cards - identifiers
It appears that recent AccountRight Updates have broken part of the programming used to import CSV Files!
I have been using TransPost to create customer cards, create invoices and mark them as paid etc instead of the very manual and individual process however, in the last couple of weeks AccountRight no longer accepts multiple Identifiers on the Card Import.
We have a customer database of over 1,000 members and categorise them using identifiers and with many falling into sub-sets, we need multiple identifiers on many records.
I have already confirmed with "TransPost" that the CSV file mapping is correct and can provide the TransPost error log files if needed.
Until recently, it was importing the multiple identifiers from the CSV files but now it returns the following error:
21/06/2021 4:10 PM, "Customer Card Import 21 Jun 2021.csv (2)", "Error", "D'Silva", "AccountRight rejected.AccountRight message: IdentifierValueMustBeSingleCharacterAtoZ: 30000 - Identifier Value should be single character from A-Z", "Log", ""
The issue lies in the import not the customer card because we can still manually add multiple identifiers to cards.
Imports - other issues
While on this topic of CSV imports, there are two other areas of this that fail to work as expected/needed:
Would you please investigate and hopefully, correct the programming so that AccountRight recognises and imports the complete data set for these procedures.
Regards
Paul
Solved! Go to Solution.
July 2021
July 2021
I have just replicated this in our sample files and import is working as expected for both Identifiers and Receipt memo fields. I've attached a sample import file here, therefore format your file according to that and let us know if you are still experiencing issues.
In regards to the Customer Since field in the card history, this is not a field that can be included in the Import/Export Assistant at this stage. However, you could look at using the Card List window to include that field, use that copy function to paste that information into Excel before combining that information with your other export from the Import and Export Assistant.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
July 2021
July 2021
Thanks Komal - I will review your file today.
Quick query on a recent topic we had wth Scheduled Transactions: I created a brand new transaction last week and that is now duplicating the entry! What have I missed?
Regards
Paul
July 2021
July 2021
It can happen if two Administrators have logged in from different machines and posted the transaction at the same time. Please ensure that is not the case and send me the screenshot of that transaction's schedule by Private Message if it happens next time too.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
July 2021
July 2021
Hello Komal
I have started the mapping afresh in TransPost using your CSV extract and now the Identifiers field is importing however, the Receipt Memo still does not work as per the attached!?!
July 2021
July 2021
Do you mind attaching the sample file here after removing the sensitive information so I can test if I get the same problem? I'm able to import the Receipt Memo field without any issues.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
July 2021
July 2021
I have attached the sample file as requested.
July 2021
July 2021
It has managed to import the Receipt Memo field on the backup file that you had uploaded for testing the recurring transactions issue. I suspect the problem on your end is due to interference from third party softwares, I would recommend turning them off and then trying again. Alternatively, if your file is online, take a backup copy offline and check if the field is then updated as expected.
As far as your import file is concerned, the data formatting is correct and should work without any problems.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
July 2021 - last edited July 2021
July 2021 - last edited July 2021
Thanks Komal but what do you mean by 'interference from third party softwares"?
How do I identify this/those?
Also, are you using TransPost to import into MYOB?
July 2021
July 2021
Generally, its interference from antivirus, or any backup programs and disabling them temporarily might help, but I'm not using Transpost for import. I've just imported your csv file as it is using File>>Import/Export Assistant.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
3
|
328
|
|||
4
|
329
|
|||
14
|
691
|
|||
3
|
579
|
|||
by
Bel1
October
15
1054
|
15
|
1054
|