Hi All,

I have been trying to create a base to manage our project purchasing and accounts payable process. We are a residential building company and run around 12 projects at once, with detailed and extensive project budgets.  These budgets are broken into categories relevant to the building stage, including materials, consultant services, accepted trade quotations, etc. Most of these line items are products from supply agreements, contract rates from contractor agreements, etc. These agreements are valid for approximately 12 months, and the items within the agreement form a catalogue (inventory), I guess. The line items for materials are the actual product per the supplier's catalogue, enabling us to order the products from our budgets accurately.
I want to be able to select several rows within a budget to all be included on a purchase order generated in Airtable or, in some way, on a branded PO PDF template. The table would then register that these items have been purchased, not allowing them to be purchased again. In another table, we have our accounts payable data extracted using an OCR reader, ready to be matched to the PO's.

We use unique project numbers and PO numbers. I want to build an interface that enables us to match our POs with invoices we receive and then assign the invoice to the category on the project budget.

This also needs to have the functionality that if an account has been received and no PO has been raised for it, that we can raise a PO or allocate the expense to the budget without a PO, if we accept the invoice.
I eventually picture this in an interface that my team can use quite easily to accurately purchase and record actual expenses in a very detailed way, against the project budget.

Any help would be much appreciated