A/R problem phantom transactions

Don Bush don at caffco.com
Wed May 27 06:52:54 PDT 2009


  I forgot to mention that while the posting problem appears to be 
random, most of the issues relate to the major accounts.
I believe the problem has been corrected by some of the additional 
checks that have been added to the process.
But it doesn't make sense that A/R still balances with G/L.

Don

  At 06:05 PM 5/26/2009, Steve Wiltsie wrote:
>Don,
>
>You haven't provided the version of filePro, operating system, or a
>single line of filePro processing table entries.  How are we supposed to
>be of any help to you?  On first glance, however, it seems like there is
>a lot of deleting of transactions going on in a system that has posting
>problems.
>
>Steve Wiltsie
>microCONCEPTS
>
>-----Original Message-----
>From: filepro-list-bounces+swiltsie=micro-mui.com at lists.celestial.com
>[mailto:filepro-list-bounces+swiltsie=micro-mui.com at lists.celestial.com]
>On Behalf Of Don Bush
>Sent: Tuesday, May 26, 2009 5:46 PM
>To: filePro List
>Subject: A/R problem phantom transactions
>
>
>I need a little help. So I thought I would start here.  Our A/R is
>written in filePro as is most everything except A/P and G/L.
>My problem is this;
>we have found transactions (manually keyed in) that are on the daily
>transaction reports but didn't show up on the customer
>statement. Then sometimes the transaction would show up a month later
>and on a couple ocassions two months later.
>Now here is the weird part.  There is no account that is out of
>balance and the A/R matches the G/L to the penny.
>Most all are payments and we have four  from Sept. 2008  that have
>never shown up on a statement and it is still in balance with
>the G/L . the following files are involved:
>                 ccrmcus -   the customer file
>                 ccacrpost -  this statement post file
>                 ccacrtran -   the common transaction file for records.
>                 ccdeposit -   the daily transaction file for entering
>customer payments
>                 ccacrhist -   the history file of all A/R transactions.
>                 buracr     -   the daily transaction file for invoices
>and credits
>
>here is how they work.
>1.someone in AR enters payments into ccdeposit and run a print of all
>the deposits.
>2. that person then processes the payments which are copied to
>ccacrtran which then updates the customer file and writes a record of
>the transaction
>      to ccacrpost for statements at the end of month as well as
>writting a record to ccacrhist for audit trail history. it then
>deletes the record from ccdeposit
>3.  after the updates the ccacrtran records are deleted for the next
>round of transactions.
>4. At the end of the day the buracr file is processed into ccacrtran
>to do the same updates to the other files. once the records are
>written to ccacrtran and processed
>      they are copied to a save file then deleted.
>5.  once the updates for the buracr records are done the ccacrtran
>records are again deleted.
>
>I have spent MONTHS looking over every single transaction deposit and
>transaction report and have found records that appear to have
>processed and some not.
>All of which I have dumped to multiple spreadsheets.
>
>Without rambling anymore the question is : How can a record process
>or not and still keep in balance with the G/L .  Figures for the G/L
>are all gathered
>independently of  the filePro system.
>
>Any help or ideas would be appreciated. Right now I am at a loss and
>am going home for the day.
>
>Don
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list