AnsweredAssumed Answered

Help for building "Order & Inventory" database

Question asked by leonhart1981_1 on Nov 23, 2017
Latest reply on Nov 24, 2017 by DanielShanahan

I am planning to build a database that will help me track my order status and inventory

 

Below image is the structure draft:

 

FileMaker order structure idea .jpg

 

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?

Outcomes