ICTRANS Location and SOH-QTY

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
LisaLisa
New Member Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1020
Veteran Member
You may just want to run IC220 for the date range.
LisaLisa
New Member Send Private Message
Posts: 0
New Member
Ok, thanks!