Eswari
Contributing User
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Importing Supplier Card File to make Status Inactive
Hi Clover, Thank you for your prompt response. I retried importing the file by removing all the column fields that weren't required as the objective was to make the Supplier Account Status Inactive. There were four columns in the import file - Co./Last Name, First Name, Card ID, Card Status. The field Co./Last Name was used to match. As advised, the file format was Tab Delimited. However, the record didn't update. The log file shows the record was updated but this is not the case. The import file was opened in Note Pad and it looks good, but kindly check and advise as it's not working. 1 records imported without errors. 0 records imported with warnings. 0 records skipped.791Views0likes2CommentsImporting Supplier Card File to make Status Inactive
Hi, our supplier card file needs to be data cleansed and I need to make supplier accounts inactive as these haven't been used for several years and not all data fields have been updated. The format of the import file was obtained after exporting the supplier card file from MYOB AccountRight. I tried to import the supplier card file after changing the Card Status from N to Y. I imported 3 suppliers to test if the import is successful but the records hadn't been updated. The field Co./LastName was selected for matching. The import file format was csv. The import file contained all fields and I didn't remove any columns/data. There are no addresses against these suppliers and the Card ID is *None The log file shows 3 records imported without error but this is not the case. 3 records imported without errors. 0 records imported with warnings. 1 records skipped. Summary of errors Error -270: Record ID may not be blank. Card not updated. -270 The attached file shows one record. I have chaged the names and the Bank Account Numbers for privacy reasons. All other data are the same. Please assist.Solved882Views0likes4CommentsSupplier Card - Last transaction date
We need to clean up our supplier Card File, by making supplier accounts inactive. Is there a report available within MYOB AccountRight that would show the last transaction date - either last invoice date or last payment date against a supplier? I exported the supplier Card File data but couldn't find a column field that would show this information. The information is available within the Card File window/screen. However, when I attempt to print the information, the data is not displayed as it's not available in selection.Solved1KViews0likes2Comments