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