PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/20/2018 1:17 PM by  FrozenIT
Extract New Items
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
FrozenIT
Lawson Administrator
Private
Basic Member
(12 points)
Basic Member
Posts:6


Send Message:

--
08/14/2018 4: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
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    08/15/2018 6: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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2824 points)
    Veteran Member
    Posts:966


    Send Message:

    --
    08/15/2018 8:04 AM
    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
    Lawson Administrator
    Private
    Basic Member
    (12 points)
    Basic Member
    Posts:6


    Send Message:

    --
    08/20/2018 1: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!
    You are not authorized to post a reply.