I want to ask among the TranTypes of PartTran, which TranTypes directly affect the inventory count?

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
:thinking: :thinking: :thinking: :thinking:
is there any trantype the source of which trantype?Kinetic_Hierarchy.InventoryTrans_2021.1.pdf (160.6 KB)
I need documents of TranType eipocor 10.2.3

Thank you so much have a good day

Any Transaction type that contains STK will affect your on hand inventory (STK-*** or ***-STK)

1 Like

@thanvanhai These below, but it would be simpler to just use the InventoryTrans flag rather than types.

3 Likes

:+1: :+1: :+1: :+1: :smiling_face_with_three_hearts: :smiling_face_with_three_hearts:
Thank all very much have a nice day!

How to confirm tran type input and output quantity of warehouse?
I want to use parttran to average parttran’s inventory over a period of time by adding all the transactions by input and output to get the average, but have not yet determined whether parttran’s transactions are import or export.

select * from PartTran


Is there any sign that the transaction is import or export like STK- % and %-STK as import?
Thank all very much have a nice day! :thinking: :thinking: