Sage 100

 View Only

  • 1.  v2017 Is there a way to export DateUpdated and Tim

    Posted 04-16-2018 13:14
    v2017 Is there a way to export DateUpdated and TimeUpdated from AR_CUstomer using VI? The fields are not available.


  • 2.  RE: v2017 Is there a way to export DateUpdated and Tim

    Posted 04-16-2018 13:22
    Did you go into Options and select to Export Read Only Fields?


  • 3.  RE: v2017 Is there a way to export DateUpdated and Tim

    Posted 04-16-2018 13:23
    That works! Thanks.


  • 4.  RE: v2017 Is there a way to export DateUpdated and Tim

    Posted 04-16-2018 14:05
    As always, I prefer an Excel Query. I surmise that this is something for the client to run?


  • 5.  RE: v2017 Is there a way to export DateUpdated and Tim

    Posted 04-16-2018 14:26
    Yes. The client wants to automate a daily export of records modified within the last 24 hours. They have another application they will be importing to. They have Alerts & Workflows so I mentioned they could automate the export using Crystal.


  • 6.  RE: v2017 Is there a way to export DateUpdated and Tim

    Posted 04-16-2018 15:28
    Since they have Alerts & Workflows, it could also be used to generate a text file, HTML or several other file layouts. We use it to upload inventory on hand quantities to a third party website.


Related Content