ITEMMAST or ITEMLOC add/change Approval

There is no flow for this (not that you couldn't create one) but if you turn on Item Master / Item Location auditing then you can run auditing reports to capture any changes.

I just wasn't sure the possibilities of capturing the information to be sent as an approval, similar to the REQ approval we have, because there isn't a way to lock that data like there is in the RQ header.  I did build a query that looks at specific fields and is sent out via our MS reporting services, but I am trying to think of other ways to disseminate this information to the appropriate users. 

 

We have an issue with the way our Item Master controller communicates changes to others.  I was thinking a flow would at least give visibility and would help control any possible issues up front.

You could do that in Process Flow or Smart Notification I would think. We send a nightly price change report to Supply Chain.

I have a report sql that will show all items added since a date - the VATs attach it to the minutes (Here are all items added since last we met). You want to query the item master and send an email when a part number has changed or some such?

Are you using PFI/IPA ? ........ If yes, I guess you can design a flow to track changes....

SQL for items added daily:
select i.ITEM as "Lawson", m.DESCRIPTION as "Manufacturer", i.MANUF_NBR, 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
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 = @SYSDATE


If you put that in a smart note or PFI and ran it nightly, it should email users with all items added to the system.

You are correct that Items and Locations to not have a pending approval status like requisitions so you have two main options:
1. Create a custom table / form to stage the item add/changes and then trigger a flow for approval. After final approval level is met the flow will add the inventory item to the necessary transaction forms via standard Lawson IC APIs. Logic based on stock or non stock items will determine transactions to IC11.1, PO13.1, IC81.1, IC12.1, IC12.2.
2. Let the users perform the transactions as they do today directly in IC, but trigger a review flow after the fact. This would route through an approval process, but unfortunately could only take retroactive actions if a rejection is required. Could do the same with a Smart Notification for after the fact reviews of data changes.

Infor added a trigger for this in Version 10. An approval process would be a snap.