ISTech Support Forum
http://www.istechforum.com/YaBB.pl Evo-ERP and DBA Classic >> Manufacturing >> PO receipts problem http://www.istechforum.com/YaBB.pl?num=1055271190 Message started by perrinmfg on 06/10/03 at 12:53:10 |
Title: PO receipts problem Post by perrinmfg on 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? |
Title: Re: PO receipts problem Post by Lynn_Pantic on 06/11/03 at 07:57:16 Maintain Database on the files BKAPHPO and BKAPHPOL |
Title: Re: PO receipts problem Post by Chris@Highlight on 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"? |
Title: Re: PO receipts problem Post by Lynn_Pantic on 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. |
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |