How can the allocation of an automatically assigned payment made to a Supplier on a particular date be viewed?
Example: Below is a supplier to be paid, the 1 - 30 day invoices. So you pay the supplier in this example $7599.20 via the “Payments” Tab, New Payment, select account and Payee “Supplier” etc and Payment made, Manager automatically allocates to oldest outstanding Job done. All perfect and OK.
Now some days later there is a query and I wish to determine what purchase Invoices were allocated to that payment of $7599.20?
If I assigned the Purchase Invoices to the “Payment” made at the time there is no trouble determining what was allocated to the payment at any point.
If custom fields are used on Invoice the data can be pulled / filtered but extra work.
- So how can the allocation of an automatically assigned payment made to a Supplier on a particular date be viewed at a later date?
- Can Custom Reports answer this somehow by flagging the payment allocated date and reporting?