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/.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
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