Skip to main content
Question

Migration job for Manual Voucher

  • March 17, 2025
  • 3 replies
  • 50 views

Forum|alt.badge.img+7

Today we use external voucher assistant, but our users find this to be a bit troublesome due to creation of excel, convert to .txt and then upload. 

I got a question about using a migration job instead, but before starting to build such file I want to know if someone else done this and if so, was it successful? 

 

Thanks in advance.

/Tobias  

3 replies

Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • March 9, 2026

Hi ROXTOBBRI, we are interested in the same thing. How have you been doing?

I have been thinking for a while about how to solve it.
I guess it is possible but it requires a bit more than a regular migration job. It may require a multi step job.

I have a batch job on the subject in the back of my mind. I will come back if I get the hang of it... ;-)


Forum|alt.badge.img+19

Hi, 

 

I’ve worked countless clients. It’s rare to find external voucher ab being too difficult. That is too difficult even after we make the process as easy as possible. 

The STDVOU template (IMO) is rarely used.  We copy the template to make it far easier to work with. Limit the number of columns, order the columns for easy user entry, use external file template control to skip the header record, and allow loading of a CSV file.  

When you have a good template, the user uses a CSV file as the users template for loading the data.  You then control the external voucher process in terms of automations. 

The trick is to make the process as user friendly as possible, and STDVOU template is IMO not a user-friendly template. 

When I’m called into to assist client issues, it’s somewhat common to see clients using that STDVOU template. It only takes a few minutes to make the process more user friendly. 

Perfect no, but not something I see receiving numerous complaints. 

Best regards, 

Thomas


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • March 11, 2026

Hi again, the shortcoming of the csv interface is that you can't keep more than one tab in Excel. If you have calculations or other data for the accounting, it disappears when saving it as csv. 

But, above all, you can't see what errors are on the rows without looking for them in IFS. Seeing the errors on the lines directly in Excel is priceless. Especially in cases where another person has created the Excel manual voucher and therefore needs to be contacted about the errors. 
Large volumes of manual vouchers is also a thing for us. 

Sorry, csv files are not good enough for us regardless of whether it has a nice look and they are easy to create and load. We need to see the errors directly...