Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Invoice job for a AP program

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Thomas Busillo
New Member
Posts: 3
New Member
12/1/2006 7:14 PM
    I am not sure that this is the correct forum to post this in.

    I am looking for a job to enter invoices into Lawson automatically. We are looking at AP520 and MA540, but we also need a way to update information after we enter the invoice.

    We are matching an invoice to a Purchase order, and entering the invoice into lawson when a match is found. When a match is not found, we are entering the basic invoice information automatically. The problem is that we need a way to update information after the invoice has already been uploaded, after someone enters information manually. We cannot use a form in Lawson, as we are sending this information from a seperate program.

    From out research it appears that MA540 and AP520 do not allow updates. Is there any other job that will do this, or a work around that will meet our needs.

    Any help will be appreciated. Reply here or send me an email at Thomas.Busillo[at]cgi[dot]com.

    Thanks
    John Henley
    Posts: 3353
    12/1/2006 7:43 PM
      I moved your posting to the Procurement forum...
      Thanks for using the LawsonGuru.com forums!
      John
      Thomas Busillo
      New Member
      Posts: 3
      New Member
      12/8/2006 4:07 PM
        Here is our problem explained a little more clearly. We are looking for a way to input direct invoices (by direct invoices i mean invoices that come in and do not match an existing purchase order already in lawson). We are planning on using AP520 to input invoices. The problem is that AP520 takes 2 CSV files, 1 for the invoice (we will call that inv.txt), and 1 for the distribution files (dist.txt).

        We know we can input inv.txt alone without dist.txt through the AP520 interface. We need a way to upload inv.txt, then send dist.txt at a later time, when dist.txt gets created from our separate workflow. Lawson has told us that AP520 does not allow us to upload dist.txt alone with having inv.txt. (We are sending dist.txt from our custom made interface that interacts with FileNet.)

        We are looking for any way that we can update an unreleased invoice, which came from inv.txt, after it has already been uploaded. We need need this to use some sort of batch program that we can automatically feed these text files into, not use a form within lawson.

        I know this is still confusing, but any help would be greatly appreciated.
        Bill Ianni
        Veteran Member
        Posts: 111
        Veteran Member
        1/27/2007 1:21 PM
          You can load invoice headers with the MS Addin's tool. Then add the distibs later as well.