Have been using A4 and now A5 for a long time and just realized that though must have made several databases and tables but not a single set.
Need a small raw material balance system for which think a set would be better.
Made 2 tables: with following fields
Goods in : date_in / lot_no_in / vendor / inventory_category / qty_in / unit_prc / ttl_amt_in
Good out: date_out / lot_no_out / vendor / inventory_category / qty_out / unit_prc / ttl_amt_out
(2nd / 3rd & 4th are character fields)
goods out are entered by lookup table of lot nos which only exists in goods in.
in short, goods which come in are given lot nos and when used from those lot nos. they are recorded accordingly.
created a set:
goods set: goods out (primary) - goods in (child) -
linked lot_no_out to lot_no_in (one to many)
in the set form created global variable `lotoutvar`. (get value
field: lot_no_out)
The report filtered to: lot_no_out=lotoutvar
This all works fine and we get a balance and value of goods balance in hand for a particular lot no..
but here is the problem. We get a reports for records subject at least one record exists for any given lot_no in goods out.. BUT NOT FOR THOSE GOODS WHICH CAME IN AND LOT NO GIVEN BUT NOT A SINGLE PIECE USED FROM THAT LOT.
Hence the entire balance of goods in hand is wrong in such a case as the new goods do not appear in the report.
Please how do we correct this and have even fresh unused goods appear in the set report.. we have tried edit the set by making goods in as the parent table.
Besides reports based on lot nos.. we need to make reports in the set by:
1. Total raw material of particular inventory category and balance In hand
2. Total goods supplied by particular vendor and balance in hand
Do we have to make 3 separate sets with appropriate links or can do it in one only..
Any help would be sincerely appreciated
v.p
Need a small raw material balance system for which think a set would be better.
Made 2 tables: with following fields
Goods in : date_in / lot_no_in / vendor / inventory_category / qty_in / unit_prc / ttl_amt_in
Good out: date_out / lot_no_out / vendor / inventory_category / qty_out / unit_prc / ttl_amt_out
(2nd / 3rd & 4th are character fields)
goods out are entered by lookup table of lot nos which only exists in goods in.
in short, goods which come in are given lot nos and when used from those lot nos. they are recorded accordingly.
created a set:
goods set: goods out (primary) - goods in (child) -
linked lot_no_out to lot_no_in (one to many)
in the set form created global variable `lotoutvar`. (get value
field: lot_no_out)
The report filtered to: lot_no_out=lotoutvar
This all works fine and we get a balance and value of goods balance in hand for a particular lot no..
but here is the problem. We get a reports for records subject at least one record exists for any given lot_no in goods out.. BUT NOT FOR THOSE GOODS WHICH CAME IN AND LOT NO GIVEN BUT NOT A SINGLE PIECE USED FROM THAT LOT.
Hence the entire balance of goods in hand is wrong in such a case as the new goods do not appear in the report.
Please how do we correct this and have even fresh unused goods appear in the set report.. we have tried edit the set by making goods in as the parent table.
Besides reports based on lot nos.. we need to make reports in the set by:
1. Total raw material of particular inventory category and balance In hand
2. Total goods supplied by particular vendor and balance in hand
Do we have to make 3 separate sets with appropriate links or can do it in one only..
Any help would be sincerely appreciated
v.p
Comment