I want to build a dashboard to get the total import and export of the part according to the trandate date but I don’t know what types of transactions in partran will affect the inventory and which trantype is the import and export?
select distinct TranType from PartTran
select * from PartTran
TranType
ADJ-CST
ADJ-PUR
ADJ-QTY
ADJ-SUB
ASM-INS
DMR-ASM
DMR-MTL
DMR-REJ
DMR-STK
DMR-SUB
INS-ASM
INS-DMR
INS-MTL
INS-STK
INS-SUB
MFG-CUS
MFG-PLT
MFG-STK
MFG-VAR
Mfg-Ven
MTL-INS
PLT-MTL
PLT-STK
PUR-CMI
PUR-INS
PUR-MTL
PUR-STK
PUR-SUB
PUR-UKN
RMA-INS
STK-ADJ
STK-AST
STK-CUS
STK-INS
STK-MTL
STK-PLT
STK-STK
STK-UKN
SUB-INS
SVG-STK
Thank you very much have a nice day 