ISTech Support Forum - AP-C not showing all line items from PO-I-E

Welcome, Guest. Please Login.

	04/29/24 at 03:35:42 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›

Pages: 1

AP-C not showing all line items from PO-I-E (Read 1704 times)

JamesO Member Posts: 66	AP-C not showing all line items from PO-I-E 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...
Back to top	IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: AP-C not showing all line items from PO-I-E Reply #1 - 04/28/19 at 17:35:09 Do they show on PO-I-F? Have the PO's been closed?
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

JamesO Member Posts: 66	Re: AP-C not showing all line items from PO-I-E Reply #2 - 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.
Back to top	IP Logged

JamesO Member Posts: 66	Re: AP-C not showing all line items from PO-I-E Reply #3 - 04/30/19 at 06:53:42 How do we fix this to get the Line items on the AP-C
Back to top	IP Logged

prophet

Full Member

Posts: 215

Re: AP-C not showing all line items from PO-I-E
Reply #4 - 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.

IP Logged

JamesO Member Posts: 66	Re: AP-C not showing all line items from PO-I-E Reply #5 - 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.
Back to top	IP Logged

JamesO Member Posts: 66	Re: AP-C not showing all line items from PO-I-E Reply #6 - 05/01/19 at 14:01:29 bump
Back to top	IP Logged

JamesO Member Posts: 66	Re: AP-C not showing all line items from PO-I-E Reply #7 - 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.
Back to top	IP Logged

prophet Full Member Posts: 215	Re: AP-C not showing all line items from PO-I-E Reply #8 - 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.
Back to top	IP Logged

JamesO

Member

Posts: 66

Re: AP-C not showing all line items from PO-I-E
Reply #9 - 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.......

IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›