We are still implementing, but there must be a way to write a report that will report the balance as of any point in time. Otherwise, you have a serious internal control issue.
The base report from Epicor relies on the invoiced status in the receiving detail table. That will be updated as soon as the receiving is invoiced. So, yes, the canned report will be problematic. You should be able to write a report, though, which relies on an outer join to the invoice detail table. You could select any records from receiving where the receipt date is less than or equal to the cutoff date and (where the invoice date is null or where the invoice date is in excess of your cutoff date).
I haven't done this yet, but I know I will need to at some point.
Thom Rose
Controller
Electric Mirror, LLC
T 425 776-4946 ext. 1024
F 425 491-8200
A 11831 Beverly Park Road, Building D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com/>
Note: The information contained in this e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use. www.electricmirror.com<http://www.electricmirror.com>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tom Ketterer
Sent: Wednesday, May 07, 2008 12:10 PM
To: vantage@yahoogroups.com
Subject: {Disarmed} Re: [Vantage] Re: Accounts Payable - Received but not Invoiced report
Thanks everyone for the help. I have confirmed the AP clearing account as set up in the AP configuration is teh account I am looking at. Now I just have to work on getting everyone to complete all the correct steps at month end to be able to rely on the report. Thanks. Tom
----- Original Message ----
From: Chris Wallace <chris@...<mailto:chris%40altairusa.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, May 7, 2008 1:01:12 PM
Subject: RE: [Vantage] Re: Accounts Payable - Received but not Invoiced report
You also need to make sure that you post all of your open AP Invoice
Entry Groups before the end of the month.
Chris
_____
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of ctgsfinance
Sent: Wednesday, May 07, 2008 11:52 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Accounts Payable - Received but not Invoiced
report
Yes, the Received but not Invoiced report is the report that should
agree with you AP Clearing Account in the GL. This is a time
sensitive report that needs to be generated BEFORE doing any AP entry
or receipts for the next month.
Dawn
--- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ,
"Todd Hofert" <todd@...> wrote:
>
> If I recall received but not invoiced goes in your AP Clearing
account.
> Look at your setup files to determine which account you have
defined for
> your AP Clearing account.
>
>
>
> Todd
>
>
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups.. com> ] On
Behalf
> Of Tom Ketterer
> Sent: Wednesday, May 07, 2008 2:04 PM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Accounts Payable - Received but not Invoiced
report
>
>
>
> We are running Vantage 8.00.811B with Progress database. I am
trying to
> generate a report to support the dollar amount that shows on the
trial
> balance for the Accrued Payables account (I think this is the
account
> that captures the Purchase Order cost of items recieved that
haven't yet
> been invoiced.)
> I thought I had found the relevant report when I located the AP
report -
> Received but not Invoiced. When I tried to run this for month end,
I
> couldn't get the amount on the report to agree to the trial balance
> amount.
> Can anyone tell me if this is the correct report to generate
support for
> the Accrued Payables account? If it is, any ideas on why it doesn't
> agree to the trial balance amount (time sensitive, cut off related
> issues, exchange rate variance possibly?). If it isn't - does
anyone
> have any suggestions on how to create such a report?
> Thanks.
> Tom Ketterer, CAA
> Director of Finance
> Standard Machine
>
> ____________ _________ _________ _________ _________ _________ _
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
> http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ
<http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]