Sage 100

 View Only

  • 1.  VI Perform logic

    Posted 09-18-2020 08:05
    I have an issue with a client where we import check payments from another system. According to client there is no way to select payments based off dates. The issue is that the source file could include checks that have been imported previously. The import is done through manual check entry..
    According to Sage support we need some perform logic that will check if the bank code and check number already exists in the check history header file.  Has anyone written perform logic like this or have any ideas of how to prevent duplicate checks from being imported..  Any ideas will be welcomed.

    ------------------------------
    Avron Katz
    K-Four Systems, LLC
    ------------------------------


  • 2.  RE: VI Perform logic

    Posted 09-18-2020 09:31
    I can't help with the PL, but there are two general approaches we take with something like this:
    • SQL View to filter the data (setting up a SQL Express, with Linked server to Providex data, if the customer is not Premium), then use the View as the data source.
    • Crystal Report (automated through Visual Cut to export results to a csv) to filter, then use the csv as a data source.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: VI Perform logic

    Posted 09-18-2020 14:10
    I believe @Jim Woodhead and @Alnoor Cassim have experience with this type of logic. 
    ​​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content