Hi, there.
Finally, i have worked out my 1st db, stock control. This db contains item master, location, costing table and pricing table, stock card, monthly stock summary reports. going to be more....
Now, i need your ideas what are the other essential reports required for users in general?
For costing table, what are costing methods are availabe? Pls explain me the most often used ones and how the formula would be?
BTW, i have a stock balance report by item. I created it by building up relationship 1 item to many item ledger (stock card) Right now, i need item balance by location, how should i do it?
Any relationship to build? like 1 item has many location???
Pls speak out and ur efforts would be my extra Ohm for me to further develop my stock control.
Thanks in advance
Finally, i have worked out my 1st db, stock control. This db contains item master, location, costing table and pricing table, stock card, monthly stock summary reports. going to be more....
Now, i need your ideas what are the other essential reports required for users in general?
For costing table, what are costing methods are availabe? Pls explain me the most often used ones and how the formula would be?
BTW, i have a stock balance report by item. I created it by building up relationship 1 item to many item ledger (stock card) Right now, i need item balance by location, how should i do it?
Any relationship to build? like 1 item has many location???
Pls speak out and ur efforts would be my extra Ohm for me to further develop my stock control.
Thanks in advance
