ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP-C not showing all line items from PO-I-E
http://www.istechforum.com/YaBB.pl?num=1556303996

Message started by JamesO on 04/26/19 at 11:39:56

Title: AP-C not showing all line items from PO-I-E
Post by JamesO on 04/26/19 at 11:39:56

We are running a PO-I-E for a PO# from received date of 4-15-19
The report comes up with approx 13 line items. When we run the AP-C for that Po # (excludes receivers after 4-19-19) only
2 of the 13 line items show up.

What can I check to see why these other 11 line items are not showing up on the AP-C?

Thank you...

Title: Re: AP-C not showing all line items from PO-I-E
Post by Lynn_Pantic on 04/28/19 at 17:35:09

Do they show on PO-I-F? Have the PO's been closed?

Title: Re: AP-C not showing all line items from PO-I-E
Post by JamesO on 04/29/19 at 06:27:40

Hi Lynn,

Heather just ran the PO-I-F and all 13 line items do show on that report.
Also, the PO is not closed.

Thank you.

Title: Re: AP-C not showing all line items from PO-I-E
Post by JamesO on 04/30/19 at 06:53:42

How do we fix this to get the Line items on the AP-C

Title: Re: AP-C not showing all line items from PO-I-E
Post by prophet on 04/30/19 at 08:39:14

Were those lines that are not showing up in AP-C received into inventory or QC? If they were received into inventory then i would expect to see those records in the BKAPHPOL file for those lines. and I would expect to see the BKAP.POL.RQTYwith the recieved qty in that field. If they are Zero that might be why they are not showing up in AP-C.

Title: Re: AP-C not showing all line items from PO-I-E
Post by JamesO on 04/30/19 at 12:17:59

The 2 lines out of the 13 lines that show on the AP-C are in QC. The other 11 (not seen in AP-C) went right into inventory.
All 13 lines have quantities according to the PO-I-E and PO-I-F. I have not checked the BKAP.POL.RQTY table, As that would have to be done after hours.

Thank you for looking,

Jim O.

Title: Re: AP-C not showing all line items from PO-I-E
Post by JamesO on 05/01/19 at 14:01:29

bump

Title: Re: AP-C not showing all line items from PO-I-E
Post by JamesO on 05/08/19 at 08:16:39

I checked the e BKAPHPOL file . There is a positive quantity associated with the line items in the BKAP.POL.RQTY.

Title: Re: AP-C not showing all line items from PO-I-E
Post by prophet on 05/09/19 at 11:46:08

If you are fairly up to date on EVO go to AP-C and go through the motions, choose to view all recovers. Once the grid comes up scroll all the way to the right and there is a column that says reason. That gives the reason its not able to enter the invoice against it.

Title: Re: AP-C not showing all line items from PO-I-E
Post by JamesO on 05/20/19 at 07:44:58

Lynn had us do this: AP-B posting to the PO/RNI account will work, then PO-K to close the PO

After that was done: The process worked for the RNI report & it is in sync with the GL. The only other item left is apparently these transactions still show up on the RNI column of the Receiving report (PO-I-E). Is there a way we can get that cleared up?

Lynn replied: use Maintain Database on the BKAPHPOL file and change from the RQTY field to the IQTY field.

I then did go into the BKAPHPOL and swapped the now 19 item. There were actually 19 other items that had to be swapped from the BKAP.POL.RQTY to the BKAP.POL.IQTY and vice versa. Example: RQTY had a quantity of 350. IQTY had a quantity of 0.00. These had to be swapped so RQTY ended up as 0.00 and IQTY ended up 350.

The AP-C was run the next day and was clear. They ran a PO-I-E and it showed every thing under invoiced.

That was a good one.

We now think the original issue was because someone inadvertently closed the PO with PO-K??

Thank you all for you assistance.......