PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/22/2016 3:22 PM by  SYED
Bank Rec Interface
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
mcl
Private
Private
Advanced Member
(67 points)
Advanced Member
Posts:29


Send Message:

--
02/04/2009 1:16 PM

    A Lawson newbie, so be easy, please.  Thought easiest interface to tackle would be flat file .txt from bank to Lawson Bank Rec.  On LSF9 so I see two options--CB185 flat file  and  CBSTMTREC database file.  Any suggestions?    With importdb, do I list all fields in header record, comma separated, or just the fields I want to upload?  Would Add-Ins be a better upload option?  Thanks

    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    02/04/2009 1:24 PM
    Go easy? No way!
    I've seen clients do a number of different approaches, but you're on the right track.

    Depending on what format the file is from the bank, you can either
    1) use CB185 flat file format (most of the times I "clone" this program for clients and tweak it to bank's spec)
    2) use Excel addins to upload to CB80. The trick here is that you don't have anywhere to key in the transaction number on the form, so you are uploading to a number of hidden "PT" (position-to) fields in order to "position" to the correct row. It sounds difficult, but it's really not that hard. And, once you set it up, you can save and re-use the upload .UWF file each month.
    Thanks for using the LawsonGuru.com forums!
    John
    Sam Simpson
    Private
    Private
    Veteran Member
    (673 points)
    Veteran Member
    Posts:239


    Send Message:

    --
    02/04/2009 3:38 PM
    We do use PFI on this. We use a combination ScanFileClient and Datastage to transform
    the input into a 71 length flat file (CB185-TAPE). Then sent an email to the users to run
    the CB185 upload program. any error found on the input file is sent back to the bank.
    SYED
    Dir of Finance
    Brookdale Hospital
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    08/22/2016 3:22 PM
    John,
    When I use CB 80.1 to upload, the return message is this transaction does not exist which is not true. You mention that there are hidden fields. Can you explain how to get to those transaction number rows.

    Thanks
    Attachments
    You are not authorized to post a reply.