Determining Remaining Balance of Deposit

Epicor ERP 9
1

Hi All.

E9.05.702A

We are trying to create a BAQ that shows how much is remaining on a Deposit Invoice, which is the value shown on the Advanced Billing/Deposit Balance Report.

To test it out, I created a Deposit Billing invoice in AR Invoice Entry for $5,000.

I then did a New Invoice Payment, against the deposit billing invoice, in cash receipt for $5,000.

I then created a miscellaneous invoice against the sales order used in the above steps. As expected the deposit billing amount of $5,000 came in automatically. I reduced the amount down to $3,000 and added an invoice line for $10,000, which
left an open balance of $7,000. So far, so good.

The deposit billing report correctly shows $2,000 left on the deposit.

What I’m trying to figure out is calculate the $2,000 is left from a BAQ.

I can’t clearly see how everything is linked.

Any help will be appreciated.

Joe Rojas

Epicor Application Manager

Nordson MEDICAL

261 Cedar Hill Street

Marlborough, MA 01752 USA

+1.508.597.1392
**Phone
**+1.774.826.9245 Mobile

joseph.rojas@nordsonmedical.com

Quality Works Here

2

The OrderHed table has the balance in DocDepositBal

1 Like
3

Hi Cathy.

Thanks for this! This worked for me.

As I side note, one issue is that the Deposit Balance on the order updates as soon as the deposit invoice is posted as opposed to when the cash receipt is entered.

I was able to work around this, in my case, but this seems a little misleading.

Joe Rojas

Epicor Application Manager

Nordson MEDICAL

+1.508.597.1392 **Phone
**+1.774.826.9245 Mobile

4

I have had a problem also, with how the Advance Billing and Deposit Billing work.

It is on my task list to rework the Order Total screen with Cash receipts.