I have created csv files to import vendor invoices into sage 200 v7. But It keep saying different format. I would like to ask what encoding type must be used on csv.
I have created csv files to import vendor invoices into sage 200 v7. But It keep saying different format. I would like to ask what encoding type must be used on csv.
Hi Ramadhan
Please confirm exactly how do you plan to import vendor invoices into the Evolution company?
Where exactly and using which module of Evolution do you use to import them?
Kind Regards
Bennie
On the client using Data import module
Thanks Ramadhan
I think the best way forward would be to first carefully study the Data Import/Export guide by opening the link below. It also address your question in details.
I have managed to create a csv file and importation was okay. I faced another issue. After importation when i go to open list of GRV i see all imported GRV and their respective information. After opening one of the invoices Invoice number will be disappeared. How can I fix this to ensure invoice number remains even after viewing the respective GRV. 8284.GRV1_sample.xls
Hi Ramadhan
Sorry, please first confirm: is your query GRV's / Supplier Invoices or Customer Invoices?
GRV with DOCTYPE =2, as I have attached a sample of the file template5164.GRV1_sample.xls
Thanks Ramadhan. But why then referring to invoices in this statement:
" After opening one of the invoices Invoice number will be disappeared"
Do you mean Supplier Invoice ?
Sorry for confusion, I mean suppliers' invoices
Thanks Ramadhan
Are you perhaps working in Evolution ver 10.1.3?
If so, this might be due to a possible software bug. Because all imported Supplier Invoice Numbers are supposed to be available after the import.
Therefore, can you please log this with Evolution Support and describe a ll the steps in detail.
You can open the link below to log the query:
https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465
Else, if not on ver 10.1.3 please test on this version by first downloading it from the Sage FTP website, installing it and creating a demo company.
Kind Regards
Bennie
No this one in evolution version 7
Thanks Ramadhan
I can recall that quite a number of issues may have been resolved on Data Import since Evolution ver 7.
Therefore please test your query on Evolution ver 10.1.3 and if successful consider upgrading to this version.
Kind Regards
Bennie
Hello Bennie, thanks for your help. I have tested on version 10.1.3.002 but the problem persist. When I open source document, supplier's invoice number disappear from the document.
Thanks Ramadhan
The only other advise I have is:
1. No special characters on the Supplier Invoice Number import values
2. On the Inventory Defaults | Goods Receiver Voucher screen is the 'Unique Supplier Invoice Number' option selected? Perhaps its selected and that means all the newly imported SINV's don't have unique numbers? That cause the field to be blank perhaps? Or are all the imported SINV's have unique SINV numbers?
If indeed using unique SINV numbers the best way forward then is to log this query with Evolution Support. I wish I could give you any other advice to consider.
https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465
Blessings
Bennie
*Community Hub is the new name for Sage City