Reply for this message: Reconcile RAR-SIL-GXR-GLH

["Milt Habeck" <mhabeck@xxxxxxxxxx>]

Dear Barb,

 

The issues noted in the e-mail you addressed to the bulletin board are a substantial concern, of course. The implication is that several internal control subjects require a thorough analysis at your enterprise ... including some subjects that may have a deeper explanation with broader consequences than suggested by the evidence that is currently available on your desk. 

 

Please consider looking at the web page hot-linked below. This page describes a Bells & Whistles® for BPCS product called Internal Control Microscope™ . Perhaps some of the system integrity tests offered by this product could help your enterprise.

 

http://www.unbeatenpathintl.com/Internal%20Control%20Microscope.htm

 

Warm regards,

 

Milt Habeck

Managing Partner

Unbeaten Path International

 

Toll free:  (888) 874-8008

e-mail: mhabeck@execpc.com

web home page:  www.unbeatenpathintl.com

 

 

 

 

 

 

----- Original Message -----

From: Barb VanEe

To: BPCS-L@midrange.com

Sent: Thursday, March 22, 2001 9:57 PM

Subject: Reconcile RAR-SIL-GXR-GLH

I have encountered several situations that are causing discrepancies between A/R - Sales History - General Ledger

 

a.  RAR  has some duplicate invoice records (RI) and only one seems to have made its way to General Ledger

 

b. Sum of RAR transactions do not equal remaining balance (sum RAMT <> RREM)

 

c.  Debit memos with the same invoice as the RI do not seem to have an effect on the RREM of the RI yet some of those RD's manage to

     make their way into G/L

 

d.  Duplicate RP (payment transactions) where only one updated G/L

 

I wonder if anyone else has encountered these same situations

 

Thanks to anyone who can provide some light on this.

 

Sincerely,

Barbara VanEe