Welcome, Guest. Please Login.
05/14/25 at 10:16:58
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
Items do not show in AP-C (Read 6324 times)
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Items do not show in AP-C
Reply #15 - 10/06/06 at 11:08:06
 
oops...After looking into this further, it appears that the transaction enters DBA on the post date, as mentioned earlier by David.
 
but...  since the item is on a PO, when it is received that is when you incur the expense under the accural accounting system.  You do not incur the expense until you receive the item, because if it is lost, broken, incorrect you do not owe the vendor for the goods (usually).
 
so...I think it is acceptable to use the post date as the date the invoice is entered, because as far as the IRS is concerned, you have already incurred the expense when you received the goods.
 
HOWEVER... with AP-B enter vouchers, to make the amounts come out properly you could enter the post date and invoice date at the same time, since there is no intermediate step (receiving) to accrue the expense on a particular day.
 
sorry if this is confusing.
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Items do not show in AP-C
Reply #16 - 10/06/06 at 11:36:43
 
Actually, it makes perfect sense and confirms the way I thought it worked.
 
Thanks!
 
We still haven't figured out why some receivers will not come up in
AP-C in the first message that started this thread.  Sad
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Items do not show in AP-C
Reply #17 - 10/06/06 at 11:42:13
 
I have noticed 2 reasons for this:
 
1.  Receipt date is after invoice date
 
2.  Sometimes DBA "burps" and a receipt is only half a receipt.  What I mean by this is we will see that inventory has been increased and the PO has 0 left on it, but it never makes it into RNI.  I have no idea why this happens, but our workaround is to receive the PO again, and then adjust out the inventory in question.  So far we have been lucky and it hasnt involved a PO for a non-inventory item.  I suppose you could delete the errant lines in the database, but I do not know the correct files to use.
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Items do not show in AP-C
Reply #18 - 10/06/06 at 12:12:56
 
Another reason why we have not been able to see PO receipts is because the PO was closed (for some reason by some person..!). If you look in PO-D there will be multiple lines for PO's with more than one date of receipt, and if a line for the PO you are looking for has a "C" in it, you need to reopen it to see the receivers.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Items do not show in AP-C
Reply #19 - 10/09/06 at 04:45:01
 
Quote from wildco   on 10/06/06 at 11:42:13:


2.  Sometimes DBA "burps" and a receipt is only half a receipt.  What I mean by this is we will see that inventory has been increased and the PO has 0 left on it, but it never makes it into RNI.  I have no idea why this happens, but our workaround is to receive the PO again, and then adjust out the inventory in question.  So far we have been lucky and it hasnt involved a PO for a non-inventory item.  I suppose you could delete the errant lines in the database, but I do not know the correct files to use.

 
My work around is to not affect inventory, but enter the invoice in AP-B as a manual invoice with the offset to RNI account.  Our experience shows it is usually the AP aging and A/P-C that did not post properly when the po receipt transaction only partially processes.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Items do not show in AP-C
Reply #20 - 10/09/06 at 06:40:46
 
That's a great idea.  What do you do to clear the RNI account?
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Items do not show in AP-C
Reply #21 - 10/09/06 at 08:55:54
 
Quote from wildco   on 10/06/06 at 11:42:13:

1. Receipt date is after invoice date


 
When is the Invoice Date ever AFTER the Receipt date?
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Items do not show in AP-C
Reply #22 - 10/09/06 at 09:03:32
 
Quote from wildco   on 10/09/06 at 06:40:46:
That's a great idea.  What do you do to clear the RNI account?

 
The RNI account is cleared through the GL by charging the AP invoice to (in our case) A/C 2021 Received Not Invoiced. (The RNI GL account was charged when the PO receipt took place and so was the inventory GL Account)
 
   PO Receipt - debits Inventory and credits RNI GL
   AP Invoice entry - debits RNI and credits A/P GL
 
The report PO-I-F, Recevied Not Invoiced, does not show the partially processed transaction on it, so there is nothing to clear here.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Items do not show in AP-C
Reply #23 - 10/09/06 at 10:39:09
 
Perfect, that will work great.  What about your totals for RNI account matching the RNI report?  Does this process throw you off?
 
The receipt date can be after the invoice date in event of a mistake (i.e. 2007 instead of 2006).  Also, I think it is actually receipt date after POST date, since it is likely that all receiving will be after the invoice date as in shipping time.
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Items do not show in AP-C
Reply #24 - 10/09/06 at 10:39:50
 
Quote from kevind   on 10/09/06 at 08:55:54:
When is the Invoice Date ever AFTER the Receipt date?

Not often enough Wink
 
Seriously though, it does happen to us. Our principle suppliers deliver direct to us on their trucks. Since they are regional, most of the deliveries are completed the same day. Not everyone seems to care when the invoicing is done, or that it's dated for the date of delivery, but rather the date that they're actually doing them.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Items do not show in AP-C
Reply #25 - 10/09/06 at 12:00:13
 
Quote from wildco   on 10/09/06 at 10:39:09:
Perfect, that will work great.  What about your totals for RNI account matching the RNI report?  Does this process throw you off?


 
Absolutely not, as long as you process the PO Receipt transaction and AP-B entry in the same period.
 
I balance the RNI report montlhy to open packing slips and General Ledger RNI. That is how I learned I must use the GL for RNI in order to process the invoice through AP-B.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
lizzleanne
Browser
*




Posts: 10
Re: Items do not show in AP-C
Reply #26 - 10/25/06 at 14:29:09
 
WOW!  Talk about getting off on a tangent...I still do not see an answer to the original question....
 
I too have a situation where I am trying to process an invoice for items recieved on a PO.  The items were recieved but AP-C does not recognize them when I try to process the invoice.  It does ask if I want to view all receiver and low and behold theare there but still won't let me process the invoice against them.  Dates ARE NOT THE ISSUE HERE!  So, what I did seems to be a pretty easy fix...I reopened the PO, then I went in and received all the lines again using 0 for the quantity and Voila!  I was able to enter the invoice in the normal fashion.
 
Hope this helps...
 
Liz English
Air Dimensions Inc.
Back to top
 
 

Liz English
Air Dimensions Inc.
www.airdimensions.com
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Items do not show in AP-C
Reply #27 - 10/25/06 at 16:22:45
 
If you reopened the PO, then it must have been closed via PO-K which would be the reason you couldn't invoice it in the first place.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
lizzleanne
Browser
*




Posts: 10
Re: Items do not show in AP-C
Reply #28 - 10/26/06 at 13:41:19
 
Reopening alone did not work.  It still would not allow me to process against so that is when I tried receiving it again with 0 quantities then is was there...??
 
Liz
Back to top
 
 

Liz English
Air Dimensions Inc.
www.airdimensions.com
WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: Items do not show in AP-C
Reply #29 - 01/07/16 at 09:28:26
 
Quote from cathyh on 10/05/06 at 07:08:17:
There are two dates in PO Invoices, the invoice date and the post date.  The invoice date is the date on the invoice, the post date is the date that can not be before the receiver date.  MY AP person always makes the post date the date of the receiver or later.

 
I bought an item from Amazon on 12-24-2015.  The dollars cleared the credit card on 12-24-2015.  Amazons' invoice date is 12-24-2015.
 
We received the item on 1-4-2016.  
 
What month and year should the expense be in?
 
Thanks,
Laura  
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1 2 
Send Topic Print