A/R problem phantom transactions

Don Bush don at caffco.com
Tue May 26 15:46:06 PDT 2009


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



More information about the Filepro-list mailing list