I am planning to build a database that will help me track my order status and inventory
Below image is the structure draft:
My idea is to have a Proforma Invoice received from my supplier; then received it based on the Proforma Invoice. Can anyone confirm if my structure is correct?
However, I don't have a clue how to put the received item qty back to my inventory? Can anyone give me an advice?