Forum Discussion
Thanks Mike, we will give it a go and let you know how this works.
Hi Mike, I have attached a CSV report that we are trying to import as I mentioned above. I am sorry but I don't quite get what you mean by a different journal memo. The attached may help. Cheers.
- Mike_James2 years agoUltimate Partner
Hi Watty2487 , thanks for attaching the CSV.
I note that the column layout is designed to suit version 19.x of AccountRight, as per this help page: https://help.myob.com.au/prem19/win/impexptables.htm. However, the current version of AccountRight will attempt to import this file correctly.
If this sale were entered manually, the journal memo field would read"Sale; Care Connect - COMPACKS". In your import file, the journal memo is blank, It would be useful to amend it to read "Import; Care Connect - COMPACKS", then these sales can be easily filtered using Find transactions.
I note there is a cardID column. If you are matching on the customer name this column should be unmatched during the import. If you are matching on the card id, the customer name should be unmatched.
I note that the job code column reads 4-0205. This may be the account number that you want the sales to appear in, but it will be interpreted as a job code, so this code must pre-exist in the file or you will get import errors. If you do have this value set up as a job (as well as all possible values that the import file may contain), then you could run a job P&L to find the sales amounts to be transferred to other GL accounts, per your original question. However, if you do not want to use a job code in the import, this column should be blank, or should be unmatched during the import.
The column headed Terms contains a text phrase. This column does not match any of the available Terms columns, and should be unmatched.
The item code icrm is linked to a particular GL income account, and this cannot be changed during import, hence my suggestion to use journals to transfer sales amounts to other accounts.
If you have any questions please post again.
- Watty24872 years agoExperienced Cover User
Mike, this looks like it has worked. We will be doing a big import next week and will load the journal memo as suggested. It worked on the test I did and I was able to search for the transaction and located it. I will get back to you next week. Cheers.