You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How to get SPEEDCHART_KEY on Voucher Line process through CSV upload

2 replies [Last post]
Guest's picture

I am loading Voucher/Invoice informatoin from CSV file to Voucher Staging tables. The load works fine, the client asked for new requirement to add the SPEEDCHART_KEY which is located on the VCHR_LINE_STG record. I see that it's loading to the table but when the voucher build process runs it omits it from the voucher_line. I believe the voucher_line.SPEEDCHART_KEY has FieldFormula peoplecode behind it...etc

Is there a way to make the SPEEDCHART_KEY remain on the voucher line?


Lepa's picture
User offline. Last seen 1 year 50 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: How to get SPEEDCHART_KEY on Voucher Line process ...

The same issue exists with the delivered voucher upload excel to CI. The SPEEDCHART_KEY is not available to be selected. What you need to do is figure out where in application engine voucher build your values are getting overwritten. You can trace the application engine to do that. I would use that just as a confirmation and I do not recommend customizing voucher build AE. What I would do instead is add a process to fire off right after voucher build to do what you want it to do. This could be a simple AE that updates SPEEDCHART_KEY value for vouchers created by your custom upload. Add the voucher Build AE to a Job definition and then add your custom AE to run after voucher build. Hope this helps.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: How to get SPEEDCHART_KEY on Voucher Line process ...

Thank you for sharing your knowledge! It's much appreciated.