Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Extract New Items

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
FrozenIT
Basic Member
Posts: 6
Basic Member
8/14/2018 8:43 PM

    I'm interested in creating a flat-file that contains items and item information for items that were created in the last 1 or 2 weeks.  We currently handle charge codes through a third-party application, and depend on manual data entry for all new items, which takes a lot of time. If I can extract the item information, I can build an import task on the other application to automatically run, create those items, and generate charge codes.  I can export all items, but I'm really looking for just those created in the desired time period due to the nature of the import task.

     

    My environment is Single-Tenant Clouded-Hosted v10 being run on Windows hardware.  

     

    Thank you, any help would be much appreciated.

    JimY
    Veteran Member
    Posts: 510
    Veteran Member
    8/15/2018 10:06 AM
      If you have IPA you could create a flow that runs a Sql or Lawson query that looks at the ADDED_DATE field in the itemmast table and produces a file.
      Kat V
      Veteran Member
      Posts: 1020
      Veteran Member
      8/15/2018 12:04 PM
        I would also build a sql with an IPA. I already have a sql for "All Items Added Since" where users put in a date and it lists all new adds to IC11. (Our Value Analysis uses it for attachments to their minutes.)

        If it helps:

        select i.USER_FIELD1 as "Notes", i.ITEM as "Lawson#", m.DESCRIPTION as "Manufacturer", i.MANUF_NBR as "Part#",
        p.VEN_ITEM as "Reorder#", i.DESCRIPTION, i.DESCRIPTION2, p.BASE_COST as "Price", p.UOM as "Buy UOM", i.STOCK_UOM,
        i.ALT_UOM_CONV_02,i.ALT_UOM_02,i.ALT_UOM_CONV_03, i.ALT_UOM_03, i.charge_nbr
        from Lawson.ITEMMAST i
        inner join Lawson.POVAGRMTLN p on i.ITEM = p.ITEM
        inner join Lawson.ICMANFCODE m on i.MANUF_CODE = m.MANUF_CODE and i.MANUF_DIVISION = m.MANUF_DIVISION
        where I.ADDED_DATE >= @SINCEDATE
        order by m.DESCRIPTION, i.ITEM
        FrozenIT
        Basic Member
        Posts: 6
        Basic Member
        8/20/2018 5:17 PM
          Thanks guys, I built off of Kat's query and I've got a job scheduled to pull it biweekly. We're just now spinning up IPA, so this may be one of the first things I end up using it for. Thanks again for the help!