Hi
I would like to ask on how to generate a report on the stock movement transaction record.
E.g I have 5 tables which:
Table 1 as “Opening” which has the field as [Date], [Ref No],[Qtyl
Table 2 indicate incoming to stock as “GRN” which has field [Date],[Ref No] ,[Qty]
Table 3 indicate incoming to stock as “RFP” which has field [Date],[Ref No] ,[Qty]
Table 3 indicate outgoing to stock as “Invoice” which has field of [Date],[Ref No],[Qty]
Table 4 indicate outgoing to stock as “ITP” which has field of [Date],[Ref No],[Qty]
Remarks :
GRN ; Goods Receive Note
RFP : Return from Production
ITP : Issue to Production
Objection :
How to generate a report / query on the [Stock Balance] by linking all the tables above when I input the between date [Start Date] & [End Date] dialog box.
Thank you.
jiajian
I would like to ask on how to generate a report on the stock movement transaction record.
E.g I have 5 tables which:
Table 1 as “Opening” which has the field as [Date], [Ref No],[Qtyl
Table 2 indicate incoming to stock as “GRN” which has field [Date],[Ref No] ,[Qty]
Table 3 indicate incoming to stock as “RFP” which has field [Date],[Ref No] ,[Qty]
Table 3 indicate outgoing to stock as “Invoice” which has field of [Date],[Ref No],[Qty]
Table 4 indicate outgoing to stock as “ITP” which has field of [Date],[Ref No],[Qty]
Remarks :
GRN ; Goods Receive Note
RFP : Return from Production
ITP : Issue to Production
Objection :
How to generate a report / query on the [Stock Balance] by linking all the tables above when I input the between date [Start Date] & [End Date] dialog box.
Thank you.
jiajian
