It is possible to manage an inventory in Airtable using multiple tables. The usual workflow for this kind of situation would be to have a table for each product, client, and sales order (as a many-to-many relationships / junction table). You could track each sales order date fields and the number fields can track how much is due for each sales order.
I recommend checking out our Inventory Tracking Template as an example for an Inventory management workflow in Airtable.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .