Welcome, Guest. Please Login.
05/08/25 at 08:24:40
News:
Home Help Search Login


Pages: 1
Send Topic Print
PO receipts problem (Read 1083 times)
perrinmfg
Browser
*


I love YaBB 1G -
SP1!

Posts: 45
PO receipts problem
06/10/03 at 12:53:10
 
Several months ago after installing one of the most recent DBA updates I noticed a problem with PO receipts.  Many old POs that had been closed for several years are showing double receipts in IN-A.   The received POs screen in IN-A shows the correct receipt on the correct date but also shows the same PO being received for the same quantity on a different date, some several years later.
 
The duplicate receipts did not effect on hand stock but do show up in PO-D.  I've noticed that the affected POs have two entries for each PO, one marked closed and one unmarked.
 
Is there any way to correct this issue except for maintain database? and if not which files do i need to fix?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: PO receipts problem
Reply #1 - 06/11/03 at 07:57:16
 
Maintain Database on the files BKAPHPO and BKAPHPOL
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Chris@Highlight
Ex Member



Re: PO receipts problem
Reply #2 - 06/12/03 at 10:58:42
 
We have had similar problems with PO receipts since updating to 2002.4 with IS Tech Support Update 05/16/03.  We have also had a couple of receipts that were unable to be found by AP-C.  Very strange.  I have reindexed and have not run into the problem again, yet.
 
Another observation we had is that the receipts are no longer in chronological order when viewed through IN-A.  This is very puzzling to me.  How can we get this back to "normal"?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: PO receipts problem
Reply #3 - 06/12/03 at 12:18:24
 
The IN-A lookup is indexed by part number, not a combined index of part number + date.  However, before you reindexed the file, the records were physically in the file in chronological order based on when they were received so it appeared in date order.  You can reconstruct that order by using the Pervasive Rebuild utility on the BKAPHPOL file and under Options - Settings, select Key Number 9 which is the Receiver Number.  That will reorder the file chronologically.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print