Physical Count

Is there a way in Sage to determine which bins have not had a Physical Count performed?

  • Since it looks like you are using Sage 500 ERP, I am going to move this post to that Support Group.

    Thanks,
    Derek
  • I am not sure if there is a current tool on the desktop menu to do this, but it probably can be done from SQL by querying the tables timPhysCountTran and timPhysCountTranHist. If I remember, timPhysCountTran has the current count in play, while timPhysCountTranHist has past counts. If needed from the UI, the SQL could be used as a basis for a report or explorer.

    If your company does not have the in-house knowledge for this, then your partner can probably help you out.