Report to show when new items are in stock

SOLVED

Is there a report in sage that will show when a newly created item in sage is received for the first time?  If not do you have any ideas on how I could go about creating one in crystal reports?  

Parents
  • 0

    Purchase Order Receipt History Report?

  • 0 in reply to BShockley

    Is there a way for me to see new items on all received POs? 

    The problem I have is I need to photograph new items when they come into stock.  We have thousands of items. 

    Right now the only way to know is to run inventory, but I have to comb through all the items.  They can be on many pos and part of many different product lines.

    Ideally I would like a report that I could run once a week, and it would say items a, b, and c arrived in stock this week and it would not show all of the other older items.

  • +1 in reply to LittleLee
    verified answer

    This would be easy with Sage Alerts and Work Flow.  In CI_Item there is a field Date Created and Date Last Received.  You could create a report that looks to see if there an item that has never been received (the date last received field is blank) but is on an open purchase order. The report should have the expected date so you know when to expect in.

Reply
  • +1 in reply to LittleLee
    verified answer

    This would be easy with Sage Alerts and Work Flow.  In CI_Item there is a field Date Created and Date Last Received.  You could create a report that looks to see if there an item that has never been received (the date last received field is blank) but is on an open purchase order. The report should have the expected date so you know when to expect in.

Children