ICTRANS Location and SOH-QTY

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