ICTRANS Location and SOH-QTY

 3 Replies
 0 Subscribed to this topic
 39 Subscribed to this forum
Sort:
Author
Messages
LisaLisa
New Member
Posts: 0
New Member

I have several questions about the ICTRANS table:

1) Does the ICTRANS.LOCATION field contain the location in which the stock item is stored?

2) Does the ICTRANS.FROM_TO_LOC field contain the location in which a stock item was issued (to)?

3) Does the ICTRANS.SOH_QTY field contain an item's stock-on-hand quantity at ICTRANS.LOCATION or at ICTRANS.FROM_TO_LOC?

Thanks

LisaLisa
New Member
Posts: 0
New Member
I need to provide 2 years worth of historical data of items that were taken from a location in order to stock other locations (or for patient use).
Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
You may just want to run IC220 for the date range.
LisaLisa
New Member
Posts: 0
New Member
Ok, thanks!