I built a Purchasing base, which keeps track of our inventory purchases.
The hierarchy is as follow:
Inbound Shipments > Purchase Orders > Purchase Orders Line Items
I would like to start keeping track of payments made against Purchase Orders.
For example: Payment reference ABC123 for $100, is to be split as follow:
$30 Deposit for PO1, $30 Deposit for PO2, and $40 Balance for PO3.
Each payment is comprised of deposits, and balances to allocate between multiple PO’s.
I would like to then find a Deposit field and a Payment field in the Purchase Orders base to be able to do some reporting.
Id appreciate any good ideas!