Sage 100

 View Only

  • 1.  Importing Wire Transfers

    Posted 12-15-2023 14:43

    I am attempting to import Wire Transfer type payments into Manual Check Entry.  I've added the Check Type field as W BEFORE the Check Number field, but used Next on the Check Number field and it keeps pulling check numbers instead of a Wxxxxxxxx number.  Sage has one posting on it and I've gathered from their posting that they are expecting you to hard code it as W000000001, etc and not use the Next function on the field.  Has anyone successfully done this, and if so, what is the trick?



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------


  • 2.  RE: Importing Wire Transfers

    Posted 12-15-2023 15:35

    This is not an ideal solution in any way and depends if it's an automated import or not, but you could change the first check number to 1, do the import and change it back. 



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------



  • 3.  RE: Importing Wire Transfers

    Posted 12-15-2023 15:50

    Link.



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



  • 4.  RE: Importing Wire Transfers

    Posted 12-15-2023 16:29

    That sucks.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 5.  RE: Importing Wire Transfers

    Posted 12-16-2023 18:25
      |   view attached

    I extracted AP_Options.SequenceNoForWireTransferXfer FROM AP_Options AP_Options in Excel that my client refreshes when they wan to import into AP Manual check as a wire.  Then if there is only one wire number, you set the field as runtime in VI and enter the next wire number.  If there are multiple wire numbers then use replace, enter the wire on the first record and copy down incrementing the wire number.  The import job for runtime is attached.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Attachment(s)

    EXP
    AP_Manual Ck.EXP   90 KB 1 version
    Original Message


  • 6.  RE: Importing Wire Transfers

    Posted 12-17-2023 08:34

    How creative!  Thank you for sharing that, @Michele Herzog!



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


Related Content