Set for material inventory � `mtrl_set`
Table: mtrl_in (primary) & mtrl_out (child)
linked by mtrl_in_no & mtrl_out_no (one to many).
Each inventory item `mtrl_in_no` has specific number and `mtrl_out_out` uses same no.
Example: mtrl_in_no: 1a�`qty_in` - 100 pcs (one record)
Mtrl_out_no: 1a-`qty_out` - 50 pcs / 10 pcs / 30 pcs (3 records)
Report: on mtrl_set : report calculated field:
ttl_qty_in: total(qty_in,grp->inventoryin)
ttl_qty_out: total(qty_out,grp-nventoryout)
balance: ttl_qty_in-ttl_qty_out
result: ( 100-90) - balance =10
this works fine
problem: in case a new item added `SAME INVENTORY` in table: `mtrl_in`
example: 2a � 300 pcs
and it does NOT have even ONE qty_out record for 2a.
total(qty_out,grp->inventoryout)
evaluates to `0` (zero)
it just ignores qty_out figures of 1a.
and balance shows as: 400 (when it should show as : 310).
If create one dummy record for 2a in mtrl_out with qty: 1 then the total of qty_out is generated correctly. (309 )
(qty_in & qty_out are required fields in field rules)
would appreciate if can point out what am I doing wrong. Have tried linking with inventory but the report generation goes into long calculations & about 450 pages are generates as there are over 2000 records in `mtrl_out` & over 50 inventory items but the problem is same while with link as made the report is instant & decent 80 pages
Rgds,
v.p
Table: mtrl_in (primary) & mtrl_out (child)
linked by mtrl_in_no & mtrl_out_no (one to many).
Each inventory item `mtrl_in_no` has specific number and `mtrl_out_out` uses same no.
Example: mtrl_in_no: 1a�`qty_in` - 100 pcs (one record)
Mtrl_out_no: 1a-`qty_out` - 50 pcs / 10 pcs / 30 pcs (3 records)
Report: on mtrl_set : report calculated field:
ttl_qty_in: total(qty_in,grp->inventoryin)
ttl_qty_out: total(qty_out,grp-nventoryout)
balance: ttl_qty_in-ttl_qty_out
result: ( 100-90) - balance =10
this works fine
problem: in case a new item added `SAME INVENTORY` in table: `mtrl_in`
example: 2a � 300 pcs
and it does NOT have even ONE qty_out record for 2a.
total(qty_out,grp->inventoryout)
evaluates to `0` (zero)
it just ignores qty_out figures of 1a.
and balance shows as: 400 (when it should show as : 310).
If create one dummy record for 2a in mtrl_out with qty: 1 then the total of qty_out is generated correctly. (309 )
(qty_in & qty_out are required fields in field rules)
would appreciate if can point out what am I doing wrong. Have tried linking with inventory but the report generation goes into long calculations & about 450 pages are generates as there are over 2000 records in `mtrl_out` & over 50 inventory items but the problem is same while with link as made the report is instant & decent 80 pages
Rgds,
v.p
Comment