Accounting help

Yahoo Archive
1
The way I can tie it out is that I wait until the end of the day, when no one is doing transactions and I do a capture and post. Once that is complete, I print the Received But Not Invoiced report and compare it to the G/L. If they don't match at that point, I know I'm in trouble and it's the old needle in the haystack to find the discrepancy. But be sure that you have done a capture before comparing to the G/L.


[Non-text portions of this message have been removed]
2
Ok accounting Gurus,



When your Received but not Invoiced report shows a different number than
your trial balance, what and where do you hunt for the problems?



I'm at a loss. I thought it might have been invoices that were adjust
to zero, but I can't imagine being the total that we are off.



TIA







M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa@...>



[Non-text portions of this message have been removed]
3
Usually you can find everything in the "inventory wip recon report".

This will report all transactions that hit gl accounts.

Sent from my iPhone

On Mar 28, 2011, at 11:42 AM, "Manasa Reddy" <manasa@...> wrote:

> Ok accounting Gurus,
>
> When your Received but not Invoiced report shows a different number than
> your trial balance, what and where do you hunt for the problems?
>
> I'm at a loss. I thought it might have been invoices that were adjust
> to zero, but I can't imagine being the total that we are off.
>
> TIA
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@... <mailto:manasa@...>
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
4
Usually a "cut-off' issue. I created a report to look at transactions dated
prior to the end of the month with a processing date after the end of the
month.



Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 . Fax 401-596-1050
<http://www.maxsonautomatic.com> www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Monday, March 28, 2011 12:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Accounting help





Ok accounting Gurus,

When your Received but not Invoiced report shows a different number than
your trial balance, what and where do you hunt for the problems?

I'm at a loss. I thought it might have been invoices that were adjust
to zero, but I can't imagine being the total that we are off.

TIA

M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com> >

[Non-text portions of this message have been removed]





__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5993 (20110328) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



[Non-text portions of this message have been removed]
5
I agree it seems to always be a cut off issue. I will confesses mine rarely balances.

Joe

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Ok accounting Gurus,
>
>
>
> When your Received but not Invoiced report shows a different number than
> your trial balance, what and where do you hunt for the problems?
>
>
>
> I'm at a loss. I thought it might have been invoices that were adjust
> to zero, but I can't imagine being the total that we are off.
>
>
>
> TIA
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@... <mailto:manasa@...>
>
>
>
> [Non-text portions of this message have been removed]
>
6
There is also input from the Purchase Journal (PJ) which is the activity from the AP vouchers (Version 9.04.506c). If anyone can let me know how to get the purchase journal activity by supplier code that would be really helpful.



You should then be able to compare net activity by supplier to narrow down the search for the offending transactions.



Tim Hager

Controller

Diba Industries, Inc.

tim.hager@...









From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Turner
Sent: Monday, March 28, 2011 12:45 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Accounting help





Usually you can find everything in the "inventory wip recon report".

This will report all transactions that hit gl accounts.

Sent from my iPhone

On Mar 28, 2011, at 11:42 AM, "Manasa Reddy" <manasa@... <mailto:manasa%40weldcoa.com> > wrote:

> Ok accounting Gurus,
>
> When your Received but not Invoiced report shows a different number than
> your trial balance, what and where do you hunt for the problems?
>
> I'm at a loss. I thought it might have been invoices that were adjust
> to zero, but I can't imagine being the total that we are off.
>
> TIA
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@... <mailto:manasa%40weldcoa.com> <mailto:manasa@... <mailto:manasa%40weldcoa.com> >
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]



********************************************************

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If you are not the addressee, any disclosure, reproduction,
copying, distribution, or other dissemination or use of this transmission in
error please notify the sender immediately and then delete this e-mail.
E-mail transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted lost, destroyed, arrive late or
incomplete, or contain viruses.
The sender therefore does not accept liability for any errors or omissions
in the contents of this message which arise as a result of e-mail
transmission. If verification is required please request a hard copy
version.

********************************************************


[Non-text portions of this message have been removed]
7
Manasa,

Have you varified that the receipts on the RNI report really aren't invoiced?

We occasionally have seen cases where the RcvHead.Invoiced doesn't update when the AP Invoice is posted.

Epicor has a fix program for this on the AR "Shipped Not Invoice" and may have one for the AP RNI as well. The program fixes the issues when you run the program but, as I understand it, doesn't prevent them from happening.

Thanks,

NB

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Ok accounting Gurus,
>
>
>
> When your Received but not Invoiced report shows a different number than
> your trial balance, what and where do you hunt for the problems?
>
>
>
> I'm at a loss. I thought it might have been invoices that were adjust
> to zero, but I can't imagine being the total that we are off.
>
>
>
> TIA
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@... <mailto:manasa@...>
>
>
>
> [Non-text portions of this message have been removed]
>
8
Thanks to all of those that responded....I'll check it out and get back
to you guys as to what the problem was, but I have a feeling it is the
"cut-off" issue.







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Nathan
Sent: Monday, March 28, 2011 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Accounting help





Manasa,

Have you varified that the receipts on the RNI report really aren't
invoiced?

We occasionally have seen cases where the RcvHead.Invoiced doesn't
update when the AP Invoice is posted.

Epicor has a fix program for this on the AR "Shipped Not Invoice" and
may have one for the AP RNI as well. The program fixes the issues when
you run the program but, as I understand it, doesn't prevent them from
happening.

Thanks,

NB

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Ok accounting Gurus,
>
>
>
> When your Received but not Invoiced report shows a different number
than
> your trial balance, what and where do you hunt for the problems?
>
>
>
> I'm at a loss. I thought it might have been invoices that were adjust
> to zero, but I can't imagine being the total that we are off.
>
>
>
> TIA
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@... <mailto:manasa@...>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
9
Ed, would you be willing to share that report with me?



Email address is manasa@....









Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Edward F. Fox, Jr.
Sent: Monday, March 28, 2011 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Accounting help





Usually a "cut-off' issue. I created a report to look at transactions
dated
prior to the end of the month with a processing date after the end of
the
month.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 . Fax 401-596-1050
<http://www.maxsonautomatic.com> www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Monday, March 28, 2011 12:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Accounting help

Ok accounting Gurus,

When your Received but not Invoiced report shows a different number than
your trial balance, what and where do you hunt for the problems?

I'm at a loss. I thought it might have been invoices that were adjust
to zero, but I can't imagine being the total that we are off.

TIA

M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >

[Non-text portions of this message have been removed]

__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 5993 (20110328) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
10
A few items that we have found with the Received But Not Invoiced Report (RBNI):

You must run the COS/WIP process first.

Though Vantage allows you to "pick a date" in the past and it looks like it will run properly it will not. I think this report is very misleading.

Example: You received something on Feb 27. The invoice date is March 2. If you run the report on March 1st and pick Feb 28 as the cut-off date -- that invoice will show on the report. If you decide to rerun the report on March 10th and pick the cut-off date as Feb 28 that invoice will NOT show on the report. The report only looks at if the transaction is not invoiced – it does not compare the invoice date to the cut-off date. I reported this to Epicor as a bug – they said it works properly (I disagree).

Our internal procedure is we do not do any receiving or invoicing in the next month until we have ran the RBNI and tied it to the Trial Balance. Also, we ALWAYS have the date amtch the fiscal period – this helps solve most of the timing issues. We able to balance - or at least identify the transaction with mismatched date and fiscal period.

Finally we created some BPMs to help make sure the dates match the Fiscal Period. This has helped reduce the errors.

Hope this helps.