Deposit Allocated Amt Issue

We’re running into an invoicing issue where the invoice is showing up as $300,000 even though it should technically just be a $0 invoice.

After doing some digging I realized we took in two cash deposits that total to the amount of the Sales Order, but the issue is that one of the Cash Receipts had to be reversed out and put into the correct month. Now the cash receipt reversal is showing an allocated amount of $326,000 and we have no idea how this got there or how to change it. I believe this is causing the invoice to populate to the $300,000 number we are getting.

image

Has anyone ever experienced this or does anyone know how we might fix this issue?

So the invoice in question is not posted? What type of invoice is it, shipment or misc?

Can you go to the header detail and the allocated deposit tabs and post a screenshot removing when you need to. I would guess your problem is on the invoice.

It has not been posted yet and it is a shipment invoice.

image

I was able to update the allocated amount, but only the wrong way. If I try to change the amount to -29,668.27 then I get the following error.

image

I wonder if it did get applied all crazy like that somewhere else then. Can you look in the customer tracker under Financial>Payments>Applied Deposits and see if you can find an invoice that had that large negative allocation on it. Maybe look in the order tracker under invoices also and see if you have some large negative invoice?

Mike,

It looks like all the deposits are still unapplied since we haven’t posted the invoice yet.

image

There was an invoice created for it a few days ago and a Credit Memo then posted against it, but to me it looks like everything flowed correctly back into unallocated deposits.