Re: ACP310 is not showing all the invoices

[MacWheel99@xxxxxxx]

From Al

By comparison of volume, our ITH inventory history file has over 1 million 
records in it & we often access INV300 history with no such trouble except 
... when I had a programming error with additions to the history, the effect 
was for the program to omit some postings ... ie. duplicate addresses got 
skipped.  We do have thousands of transaction history on any one item #.  
Even though different teams of programmers at SSA did different modules, BPCS 
is supposed to have programming standards to allow for reasonable volumes to 
be processed.

Given the volume of data to track, I think people really need better filters 
to limit what they are looking at, than trying to wade through 18,000 
invoices on screen.

Congratulations on limiting your users to a single view ... mine have 
infinite views, crafted by different co-workers with different levels of 
understanding for BPCS & the tools involved & I am often worried about 
whether my users are getting at reliable data.

>  From:    bpcsmaynez@yahoo.com (Jesus Maynez) 
>  
>  Al, thanks for answer.
>  
>  I believe you are right the subfile is not taking more than a specific 
>  number of records. Howeve, the program is created in ASSET and I do not of 
>  any specification of that kind for the subfile. Actually, you dont have to 
>  create the subfile, it created by itself. Perhaps I should check the RPG 
>  code, but I am not very good at it.
>  I was thinking on create another program to review these invoices, but I 
>  would like to keep my users working with that single BPS program.
>  
>  Most of the invoices are paid already, but the company has wanted to keep 
>  that information in the system. Perhaps is time to change some company 
>  policies.
>  
>  Thank you.
>  
>  -----Mensaje original-----
>  from Al Macintyre
>  
>  First idea is that perhaps you have more invoices than the sub file is
>  designed to display ... suppose the field for recording vertical lines on 
>  the screen is 3 digits to 999 ceiling, then when it hits the 1,000 entry 
to go 
>  to screen, the place that it is to put the data is already filled with 
entry # 
>  1 & you get that error message.
>  
>  Then when you recover from the IBM error message you are left with 
whatever 
>  fits vertically in the BPCS subfile for screen which is not all the 
invoices
>  & you get the same set again & again because the subfile cannot build any
>  higher.
>  
>  I have not looked at the code to know that for a fact ... this is my
>  speculation.
>  
>  My suggestion is that you develop a query/400 or other way of viewing
>  invoices that goes after a narrower range, such as by date ranges, so 
users 
>  can get at the data until you figure out what to do with this.

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---