partical payment amount missing

[SpeedBWild]

I received a payment of $794.40. When I go to cards- sales-summary - and enter customer name I see that the payment has been applied to two invoices. The combined total of the two invoices is $138.00. When I expand the payment information the amount remainding is zero. How do I find the remainding money that doesn't seem to be applied anyplace?


Thanks,
Karen

 

[jazgeek]

would a customer payment summary inquiry show you the outstanding balance?

inquiry>sales>customer payment summary



-----------
and they wonder why they call it Great Pains!

jaz

 

[SpeedBWild]

No, it shows the two invoiced that money was applied to and it shows zero balance available for the payment amount left.

 

[LyleU]

First, try a trial balance (Reports > Sales >
Trial Balance) for that particular account. If the only things that happened are as set out in your first submission, then there should be a remaining credit balance.

Go to Inquiry > Sales > Transaction By Customer. Call up the customer account in question, find the payment transaction and expand the grid. Is there an amount on the second line of the payment transaction in the Amount Remaining field?

Lastly, you can go to Transactions > Sales > Apply Sales Documents. Select the customer and then using the arrows next to the Document No. field, scroll through the payments until you find the payment in question. Is there an amount remaining in the Unapplied Amount field just below the Original Amount field?

I suspect that what you are looking at is just telling you that there is nothing further to apply to your two invoices as they are fully paid.

Lyle

 

[SpeedBWild]

When I go to Inquiry > Sales > Transaction By Customer, enter the customer account and find the payment transaction and theb expand the grid the amount in the amount remaining field is zero. When I click on the amount remaining link for that payment it show the correct payment amount, but it only shows two invoices in the grid below and they only add up to $138.00, not $749.40.


When I go to Transactions > Sales > Apply Sales Documents, select the customer and then use the arrows next to the Document No. field to scroll through the payments until I found the payment in question there was no amount remaining in the Unapplied Amount field just below the Original Amount field.

I can't seem to find where the rest of this money is. Any other ideas?

I haven't had much luck looking at the reports, I will continue to investigate that.

Thanks,

 

[martink1]

Try going to 'tools-utilities-sales-reconcile and reconcile that customers current customer information and outstanding document amounts. The report print out should tell you if the remaining amount was put back on the customers account.

 

[SpeedBWild]

I reconcile this customer but I still can not see or find the outstanding missing balance.

When I look at the Receivable Transactions Inquiry page for the payment in question I see a balance of zero. Does anyone know which tables would hold the data I see on that screen. I am hoping that I find the tables so that I can see what has happened to my missing money.

 

[SpeedBWild]

When I look at an applied payment which tables hold the payment information and which table holds the transactions tha the payment has been applied to? I think I might be able to see what is going on if I have the table relationship.

The other option I am considering is if I am still unable to find the missing money what would happen if I back out the payment transactions and start all over again.