Stock & Services
1 min
essential product and services tables \<font color="#4ccfe2">these tables are required to determine the setup of products and services and the relationship between \</font> \<font color="#93a2dd">products and the relationship between the purchasing batches requires products table and reception notes products table \</font> \<font color="#93a2dd">the products stocks table can be used to determine existing stock on hand quantities \</font> reception notes > purchase order information reception notes products > products purchased id = nir product id on other tables product id = products id reception notes products stock > stock quantities received product categories > digitail product categories id = product categories id on other tables products > general product information category = product categories id includes package size as unit (receiving size) subunit (selling size) formula (number of subunits in a unit) e g 50 (formula) tablets (subunit) in a bottle (unit) excludes quantity of stock on hand products stocks > stock quantity product id = products id stock = unit sub stock = subunit service categories service packages > general service information service id = available services id service pacakages products > products bundled with a service package id = service package id product id = products id
