RM Historical Aged Trial Balance 1

[PTina]

Scenario:
Great Plains 7.5, Remote User (citrix)
1 Sales Invoice, 4 payments (Cash Receipts) applied against each other.

The invoice is fully applied (the apply documents look ok)
The payments also look ok with the apply records pointing
to the invoice.

When an Historical Aged TB is printed (excluding fully
paid & applied documents) these transactions still come up
as outstanding.

I've run check links and Reconciled outstanding documents,
batches, Current Customer Info.

The user got an error while doing the cash receipts (the
next receipt number in setup got cleared).

I figured that checklinks and reconcile would do the trick
since the apply records look intact but no such luck.

I would greatly appreciate any help ...

 

[klewis10367]

Try a normal Trial Balance. I believe until you move these transactions to history they will continue show up in the normal trial balance.

 

[klewis10367]

That is until you use paid transaction removal to move the invoice to history the invoice will still show in the History Trial balance. Once the invoice is fully applied the status changes to History, but it is not moved to History ( seperate table) until the paid trx removal.

 

[PTina]

I did think of this but none of the other invoices\receipts that are fully paid show up when I check to exclude fully paid/applied documents. This suggest that there is some thing wrong with these transactions, but what I don't know.

I'm wary of running Paid Trx Removal (last resort) because we may want to void something from history at a later date.

Any other suggestions?

 

[klewis10367]

What is the staus of the invoice? If you are on version 6.0 or higher in sql2000 have you tried deleting the RM00401 table in Query Analyzer and then running checklinks against the Sales Series> Open and historical transactions. This will verify that you have no corruption in your open and historical tables.

 

[PTina]

I noticed something wierd with one of the payments so I unapplied it, ran check links and reconciled.

Now the inquiry screens show the sales invoice with the unapplied amount. I will have the user enter a new payment to apply to the document, and void the original payment that was messed up. Hopefully that will sort it out.

Strangely though, the Historical Aged TB doesn't show the invoice as outstanding but the Aged TB with options does? Is this cause for concern?

Thank's to everyone who responded with suggestions.

 

[klewis10367]

No, because since you have unapplied amounts it will not show up in the History Trial Balance, only the Aged trial balance.

 

[PTina]

New Problem Arise:

I had set the Posting setup for sales to Post to GL so that we could catch any batches coming out of correcting the earlier problem (GL appeared to be fine.)

The bank account is now not balancing even though it was
balanced and reconciled before. I don't see any trx in GL
to be posted; I'm not even sure why the bank a/c was
updated when the Post Through flag was off.

I also notice that the original suspect trx has one of the
distribution accounts missing (writeoffs).

I'm thinking that the solution here is to do an adjustment
in the bank account and remove history for the trx with
the missing distribution. Can anyone think of a better
solution?

 

[VictoriaYudin]

Did the user already void the cash receipt that was suspect? That would cause the Bank Rec to be off.

 

[PTina]

Yes, The suspect payment was voided. But we had turned off Posting through GL so we weren't expecting it to update that module.

I just had the user do a bank adjustment for this issue, so I'll see how it goes from there.

Thanks

 

[stef315]

Response to part of your problem....

The bank Reconciliation Module is updated at the same time the Receivables Management module is. When you turn off the post through, the General Ledger is the only module that isn't updated at that time.

Hope that clears that part up at least.