Supplier Prepayment Balance
Remaining prepayment we have paid to each supplier as of a date, per division. For seeing company money still held by suppliers.
Questions It Answers
- Which suppliers still hold our deposit, and how much?
- What is the total unused purchase prepayment at month end?
- Why doesn't the supplier deposit show up when making a purchase invoice?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Position as of a date (up to and including). Empty means today. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Supplier | One supplier only; pre-filled from the role's default when set. |
| Balance | Filter by remainder: > 0 for suppliers still holding a deposit, = 0 for fully used. |
How To Read It
| Column | Meaning |
|---|---|
| Division, Supplier Code, Name, Address | One row per supplier per division. |
| Balance | Deposits paid (Supplier Prepayment form) minus deposits used as payment on purchase invoices, up to the filter date. |
| Payment Type | The prepayment type used. With more than one type, balances are summed on one row. |
Why The Numbers May Differ
- Deposits are kept per division: a deposit paid from division A cannot pay a division-B invoice.
- An invoice can only use deposits dated no later than the invoice date.
- Amounts are in the transaction currency, not converted; Supplier History shows them in the default currency.
- The one-by-one detail is on the prepayment card in Supplier History.
Menu Location
- Procurement / Purchase Reports / Supplier Prepayment Balance
/report/repsupplierdp