User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
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.
Convertion of bank file to PSBD format
Tue, 02/10/2009 - 4:24am
Hi Iam working on converstion of bank file to PSBD format. I wrote a custom SQR to convert the file. But its still showing wrong format. I checked with the file layout also.
Did anybody worked on this before. If so can you please send me the SQR for this conversion process/.
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
I would use an application engine instead of an SQR to do that. Transforming bank statements from a file that the bank provides, such as a BAI file, into the PeopleSoft Business Document layout (PSBD) should be straight forward once you know the layout that PS requires it to be in.
The layout could be find PeopleSoft Enterprise Banks Setup and Processing 9.0 PeopleBook, Chapter 8 (Setting Up the Bank Statement Import Process). You would want to look at section "Transforming Bank Statement Files to a PSBD Layout" to get the file layout PS will be looking for.
Good luck!
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
Post new comment