Payment Tracking Table Specs 8. Payment Tracking Table
Purpose: To keep track of all payments to suppliers.
Columns:
Payment ID (Text, Unique ID, could be a Coda ID) PO ID (Lookup - from the Purchase Orders Table) Supplier Name (Lookup - from the Suppliers Table) Payment Amount (Currency) Payment Stage (Select - "Advance," "Partial," "Final") Status (Select - “Pending”, “Paid”) Formulas:
Could have a formula to convert all payments to a standard currency
Could calculate if there are any overdue payments
Coda Packs: Use a pack to integrate to an accounting system if needed.