Dear experts ,
I am trying to upload a simple excel file to check the external voucher functionality . However , I've got below error. Can anyone of you assist me regarding this matter ?
Solved
Errors in External voucher file load ID
Best answer by Kalpa Veranga
Hi
Looking at the template definition and your file loaded, I can see first column in template is voucher number, and if you are using automatic numbering of M vouchers, it should be empty.
In your loaded data, first column contains value 110000.
Typically, IFS assign the voucher numbers, leaving this off the template. Also, the voucher type would also not be in the template, as the load type would typically drive voucher type. If you need to reference an existing system / numbering process this data can be entered in the reference. This is a common template I use for testing. For real life, add additional attributes, for example the code parts. In this simple example the amounts are all ± in column 3.
All records would have the same load group item (for example A). If the file should create two different vouchers the first group of records could have load group item A, the second group could be B. - For example assume your loading a payroll file that contains true payroll values in the first section (Group A), but then statistical data in the second section (Group B).
Using the above template - My external voucher basic data is shown below.
You can establish any load type, I used P for a very specific reason.
Kind Regards,
Kalpa.
This topic has been closed for comments
Hi
If the issue is still there, could you please attach a screen capture of the setting in External File Template window?
Thanks and Best Regards
Kalpa.
Hi
You can save the file you are trying to upload as a TXT file with comma delimited columns and load again to check if the issue is related to separator
The file is quite simple and I assume looks like this:
110000,,,,,,,,,,,,,45000,,,45000
220020,,,,,,,,,,,,,-45000,,,-45000
This is correct format to be uploaded assuming that you are using the STDVOU system defined file template
However as
Best regards,
Aneta
I was trying to upload excel file as per below.
1 person likes this
1 person likes this
1 person likes this
Hi
Looking at the template definition and your file loaded, I can see first column in template is voucher number, and if you are using automatic numbering of M vouchers, it should be empty.
In your loaded data, first column contains value 110000.
Typically, IFS assign the voucher numbers, leaving this off the template. Also, the voucher type would also not be in the template, as the load type would typically drive voucher type. If you need to reference an existing system / numbering process this data can be entered in the reference. This is a common template I use for testing. For real life, add additional attributes, for example the code parts. In this simple example the amounts are all ± in column 3.
All records would have the same load group item (for example A). If the file should create two different vouchers the first group of records could have load group item A, the second group could be B. - For example assume your loading a payroll file that contains true payroll values in the first section (Group A), but then statistical data in the second section (Group B).
Using the above template - My external voucher basic data is shown below.
You can establish any load type, I used P for a very specific reason.
Kind Regards,
Kalpa.
+1Hi,
You must fill always the Currency Debit, Currency Credit and the Currency Amount Fields, the first field must be empty and you should have filled at least the Account, Accounting_Year and Currency Code.
For values consider the follow example
Curr Debit = 100, Curr Credit = 0 and Curr Amount = Debit - Credit = 100
or
Curr Debit = 0, Curr Credit = 100 and Curr Amount = Debit - Credit = -100
I hope this can help you.
Regards,
André Lima
Kalpa Veranga wrote:
Hi
Looking at the template definition and your file loaded, I can see first column in template is voucher number, and if you are using automatic numbering of M vouchers, it should be empty.
In your loaded data, first column contains value 110000.
Typically, IFS assign the voucher numbers, leaving this off the template. Also, the voucher type would also not be in the template, as the load type would typically drive voucher type. If you need to reference an existing system / numbering process this data can be entered in the reference. This is a common template I use for testing. For real life, add additional attributes, for example the code parts. In this simple example the amounts are all ± in column 3.
All records would have the same load group item (for example A). If the file should create two different vouchers the first group of records could have load group item A, the second group could be B. - For example assume your loading a payroll file that contains true payroll values in the first section (Group A), but then statistical data in the second section (Group B).
Using the above template - My external voucher basic data is shown below.
You can establish any load type, I used P for a very specific reason.
Kind Regards,
Kalpa.
Interesting that the above was copied from another posting and entered as if it came from Kalpa.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.