Advance Billing/Deposit Balance Report

Okay, here's the problem:

When we run the above report it shows that a customer has a deposit
balance of $1,237.10 for a particular Sales Order. But when we invoice
a shipment for that Sales Order, no deposit balance comes over, which is
correct because we used up all the deposit money. I think what happen,
was there was a mistake in the original shipment, which got credited and
reinvoiced. Anyway my question is how do I get the balance off the

Kathy Hambleton
Electron Energy Corporation
717-898-0660 (fax)
Version 5.00.329 upgrade from 3 a month ago.

I don't recall seeing any other complaints about this, so I assume I'm
missing something, but as we are running the system I don't agree with the
logic on the Advance Billing/Deposit Balance Report.

As an example:
Sales Order for 100 units @ $1,000 = $100,000
Deposit invoice for 50% = $50,000
Ship 10 units @ $1,000 = $10,000 less $5,000 deposit plus $500 freight =
invoice $5,500.

Deposit balance should be $50,000 less $5,000 applied to invoice = $45,000.
This is what the Sales Order Tracker Summary shows.
Transactions on the ledger are: Credit for Deposit Invoice $50,000, debit
for applied deposit $5,000, net $45,000.

Deposit per Advance Billing/Deposit Balance Report = $44,500
I assume it is calculated as $50,000 deposit invoice less $5,500 shipping

Has anyone else run into this?

* Rob McFarlin, Controller
* Accel Group, Inc.
325 Quadral Dr.
Wadsworth, OH 44281
* (330)336-0317 x114
* FAX(330)336-1224
* <mailto:RobM@...> RobM@...

This e-mail communication is intended only for the use of the individual to
whom it is addressed and may contain information that is proprietary or
confidential. If you are not the intended recipient (or an employee or agent
responsible for delivering this communication to the intended recipient),
you are hereby notified that any dissemination, distribution, or copying of
this communication is strictly prohibited. If you have received this in
error, please notify the sender immediately by telephone and destroy this
message. Thank You.

[Non-text portions of this message have been removed]