March 14, 2008
Fzrinvs
This is the check invoice selection report. We were running a very old version of this report, 3.x, and I wanted to put our mods on the 7.1 version. What a can of worms. We've added two hold indicators and an address type/seq field to the report. First credit memos wouldn't show up and that turned out to be due to the main select statement changing somewhat. I got that fixed and then started having problems with the totals not breaking right for the vendor on multiples. I had to add spriden_id and spriden to the fabinvh part of the select union.
Posted by wendlerb at 2:38 PM | Comments (0)
January 16, 2008
Fgbtrnd/fgbtrnh archive process
We are considering using FOPARCP to archive the transaction tables. Currently the tables have records back to fiscal year 95. You have to be careful running this because it is the same process to purge records as well. Investigating two parameters which do a check reconciliation and grant edit. Not sure if we want to do that. Default value is Y. This was prompted by problems with fis warehouse feed and the transact.sql load. SOU runs through it in about 1/3 the processing speed it takes WOU. Taking too long and causing failure of the load across all 5th sites when we have a day with a lot of records to process.
Posted by wendlerb at 11:10 AM | Comments (0)
March 22, 2007
Invoice Selection - Fzrinvs
I was tracking down an AP check issue annd realized we were running a mod of farinvs that hadn't been pushed forward since banner 3.1 Baseline is now banner 7.1 for the job submission program. Most of our mods on this weren't well documented. So I took the baseline and added wou mods plus documentation. Note that I had to remove the method column to fit in the approval and hold ind. This won't mean much unless we start doing ACH in finance.
Posted by wendlerb at 11:48 AM | Comments (0)
October 11, 2005
Fzruinv
This open invoice report has always been a tricky one. In the past the report has only shown one of the next approver in the queue and not all of them. I changed the main select union to pick them all up and reformatted the output so all the approvers line up.
Posted by wendlerb at 9:01 AM | Comments (0)
August 9, 2005
FZRRBLG
Rush building insurance value report....
Posted by wendlerb at 1:43 PM | Comments (0)
June 23, 2005
FZRUINV
I’ve been fixing an old Open/Unapproved invoice report originally written way back in ’95 long before I got here. It was not set up to handle multiple invoices and the amount calculation was incorrect. I’m surprised that neither Dale or Susan ever mentioned that the amounts were sometimes off. Anyway, Fzruinv now lists out the vendor invoice on multiples and calculates amounts consistent with Banner.
Posted by wendlerb at 3:02 PM | Comments (0)