Hi all,
I have hit a brick wall, and welcome any ideas on achieving real time stock levels.
Database Structure:
I have two tables for inventory...
Products.dbf and Parts.dbf
Parts is the child table to Products.
Products.dbf fields:
Pro_Id
Pro_Name
Pro_Qty -calculated expression (field rule) to count Pro_id from Parts table
Pro_Rma_Qty - calculated expression (field rule) to count pro_id with condition 'RMA' from the Parts table
Parts.dbf fields:
part_id linked to Pro_id
part_name linked to Pro_name
part_sn
part_condition
The Products table field rule expressions table counts the parts table by part_id and gives a qty level.
I have a grid setup with the Products.dbf table and the following fields; Pro_Name and Pro_Rma_Qty
This displays fine, with a base filter to only show Product names that have "Pro_RMA_Qty" thats greater than 0
The issue im running into:
When a user inventories or changes a condition type to RMA on a serial number (part_sn in the Parts table) the new qty level in the parent Products.dbf table is not updated until I manually recalc field rules on the Product table.
Obviously this will not give accurate numbers, until I tell all employees to stop processing until I have recalculated the fields. (which is time consuming with 100,000 records.)
Any ideas on how I can get the field rule to calculate in real time?
Thanks,
James
I have hit a brick wall, and welcome any ideas on achieving real time stock levels.
Database Structure:
I have two tables for inventory...
Products.dbf and Parts.dbf
Parts is the child table to Products.
Products.dbf fields:
Pro_Id
Pro_Name
Pro_Qty -calculated expression (field rule) to count Pro_id from Parts table
Pro_Rma_Qty - calculated expression (field rule) to count pro_id with condition 'RMA' from the Parts table
Parts.dbf fields:
part_id linked to Pro_id
part_name linked to Pro_name
part_sn
part_condition
The Products table field rule expressions table counts the parts table by part_id and gives a qty level.
I have a grid setup with the Products.dbf table and the following fields; Pro_Name and Pro_Rma_Qty
This displays fine, with a base filter to only show Product names that have "Pro_RMA_Qty" thats greater than 0
The issue im running into:
When a user inventories or changes a condition type to RMA on a serial number (part_sn in the Parts table) the new qty level in the parent Products.dbf table is not updated until I manually recalc field rules on the Product table.
Obviously this will not give accurate numbers, until I tell all employees to stop processing until I have recalculated the fields. (which is time consuming with 100,000 records.)
Any ideas on how I can get the field rule to calculate in real time?
Thanks,
James
Comment