Sage 100

 View Only

  • 1.  Orphan Amounts in IM Data Files

    Posted 10-20-2020 12:30
    What is DataEntryType "48" in the IM_DataEntryCostCalcCommit table?  Is there a list somewhere?

    I ran a Crystal report to find the orphan amounts in the IM_ItemWarehouse and IM_DataEntryCostCalcCommit tables.  There are three or four records in each table that have values.  I would like to delete any orphan amounts, and would like to verify they are not needed by a legitimate, un-updated transaction.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------


  • 2.  RE: Orphan Amounts in IM Data Files

    Posted 10-20-2020 14:48
    Cancel this post.  Data Type 48 is a PO Receipt of Goods.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



Related Content