Welcome, Guest. Please Login.
05/14/25 at 09:49:17
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
Items do not show in AP-C (Read 6319 times)
kevind
Active Member
*****


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

Posts: 634
Gender: male
Items do not show in AP-C
10/04/06 at 11:08:27
 
We have a PO with 3 items on it.  All 3 items were received.
2 on 9/28/06 and 1 on 9/29/06.
 
When we try and enter the Vendor Invoice for the total of these 3 line items,
only the two received on 9/28/06 come up.
The third does not come up.  The receiver correctly shows
them received on 9/29/06 and the Inventory Transaction shows
them as received also.
 
Any Ideas??
 
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
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Items do not show in AP-C
Reply #1 - 10/04/06 at 12:04:15
 
AP-C is date sensitive.. if you say the invoice date is for the 28th then all items received after the 28th are not on the list to pick from, that might be your issue, just a guess.
 Smiley
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   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 #2 - 10/05/06 at 06:11:16
 
Thank you for responding.
 
Correct me if I'm wrong ... Most companies Invoice a product  
the same day they ship it.  Our receivers will ALWAYS be Dated AFTER the Vendors Invoice Date.
 
The Invoice Date for our Vendor Invoice was 9/28/06 and
the GL Date we entered was 10/04/06.
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
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 #3 - 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.
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
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Items do not show in AP-C
Reply #4 - 10/05/06 at 07:22:30
 
We always enter the post date the same as the invoice. I'm not an accountant, but my understanding is that under the Accrual Basis (which I think most if not all of us are required to be by the IRS) it is considered received the date it becomes your responsibility. If the vendor is shipping FOB their plant, then it's your responsibility the date it's shipped. I'm open to correction if I'm wrong.
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
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Items do not show in AP-C
Reply #5 - 10/05/06 at 08:52:52
 
The invoice date is the date on the invoice.  The post date should almost always be the date it is entered into DBA unless you are facing an end of the year situation.
 
DBA ages from the invoice date when determining when to pay the bill.
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 #6 - 10/05/06 at 10:27:21
 
Thanks everyone for your input.
 
The AP-C Plot thickens.
 
I have another vendor that we thought we had missed
entering an invoice for.  When I tried entering the invoice,
I got a message that there were no open receivers, did
I want to view all receivers.
 
After I clicked yes, I got a total of 12 lines on the screen.
This PO had 3 items on it.  They were received on 3 different Days.
The 12 lines on the screen were those 3 receipts repeated 4 times.
The only difference between the 4 different groups of 3 was
the Column labeled 'S'.  Two of the groups had an 'R', one of
them had a 'C', and one of them had a 'P'.
 
1. Why do I have 4 groups of 3 receivers?
2. What is the 'S' column and what do the Codes in it mean?
 
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
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Items do not show in AP-C
Reply #7 - 10/05/06 at 10:28:12
 
Quote from wildco   on 10/05/06 at 08:52:52:
The post date should almost always be the date it is entered into DBA unless you are facing an end of the year situation.

Maybe I'm just picky, but I like to be able to create any report on any data for any date range and know that it will be accurate. The fact you acknlowledge that at the end of year they should agree indicates to me that the concept applies any time.
 
Is there some reason why it's bad in DBA to enter the post date in the past?
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 #8 - 10/06/06 at 04:57:42
 
Quote from David Waldmann   on 10/05/06 at 10:28:12:

Maybe I'm just picky, but I like to be able to create any report on any data for any date range and know that it will be accurate. The fact you acknlowledge that at the end of year they should agree indicates to me that the concept applies any time.

Is there some reason why it's bad in DBA to enter the post date in the past?

 
Prior monthly post dates can cause the $ balance of the  AP Aging Report not to agree with the General ledger account for Accounts Payable.
Back to top
 
 

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


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Items do not show in AP-C
Reply #9 - 10/06/06 at 06:28:34
 
Actually, that is no longer true. The limits on dates allowed in AP-B & AP-C as well as payment dates in AP-H will keep the aging and GL in agreement.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Items do not show in AP-C
Reply #10 - 10/06/06 at 09:48:16
 
I think if the DBA post date is before the Received date AP-C has trouble paying the invoice.
 
Also, we run all reports off the invoice date, and the invoice date is used in the balance sheet.
 
Keeping the post date as the date it was entered would allow you to track who entered the item (if different people work on accounting).  Since DBA operates on an accrual basis, the invoice date is the date that DBA uses to post the expense.  The post date is the date it goes into DBA.
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Items do not show in AP-C
Reply #11 - 10/06/06 at 10:13:06
 
Quote from wildco   on 10/06/06 at 09:48:16:
I think if the DBA post date is before the Received date AP-C has trouble paying the invoice.

Since DBA operates on an accrual basis, the invoice date is the date that DBA uses to post the expense.  The post date is the date it goes into DBA.

 
I was under the impression that the Invoice Date is the date DBA uses to age the bill in AP-Aging, and transaction date is the date DBA uses to post the invoice to the General Ledger in RP batch. If a prior period date is used for posting the invoice, that would change the prior period General Ledger balance for Accounts Payable - would it not?  
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   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 #12 - 10/06/06 at 10:24:35
 
Quote from wildco   on 10/06/06 at 09:48:16:
Since DBA operates on an accrual basis, the invoice date is the date that DBA uses to post the expense. The post date is the date it goes into DBA.

Isn't the Expense (or asset) posted for the date that the item is received
with the liability side of it posting to RNI??
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 #13 - 10/06/06 at 10:48:57
 
Certainly the transaction goes into DBA on the date the transaction is posted in GL-O.  But, I am 99% certain when it posts the amounts to the income statement/bal sheet, it uses the invoice date, and not the post date.  
 
Maybe Lynn can verify this, I dont want to give out incorrect info.
 
If you have reset your period close date at the end of a fiscal year, you will be unable to enter a transaction with a prior date, hence my statement about running into trouble at the end of the year.  Of course, you can roll the date back, enter the invoice, and reset the date, but at some point you need to close the books so you can pay taxes, etc.  At that point, I think you are better off putting in the transaction on the first date of the new year.
 
kevind:  DBA does make a transaction to RNI and inventory when something is received, and you now have to pay for the goods (the accrual system).  Then, when the invoice is posted, it removes it from RNI and puts it into AP.  I should have been more specific.
 
We have always done our receiving/POs this way and do not experience any problems.
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 #14 - 10/06/06 at 10:59:26
 
Thanks for your input.
 
We have never had any problem either ... Until I updated to  
8/11/06.  I see you have not updated.
 
The Problems I have listed above still persist.
 
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
Pages: 1 2 
Send Topic Print