• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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!