| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[ - Stored Procedure (SP) to update the inventory based on the feed from SAP|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=]
JDE provide the feed everyday with stock availability at each sub-location level for each item. We need a SP that will accept Item No, Sub-Location, and Quantity to update the inventory.
Note:
- JDE will send 0 for an item and sub-location to indicate that they do not have any inventory left. We are suppose to deplete all the inventory that we have in i21 across all storage locations for that sub-location
- When we receive it, system will put the lot in sub-location 'L100' and storage-location 'Bin1'. However when we get the feed from JDE it will just give us the sub-location 'L100' for that item. We are suppose to then deplete our inventory to match that quantity. They are not worried about which storage location that lot is available in our system. All the inventory movements for manufacturing are maintained within SAP and they do not use i21 for that
- JDE is sending us stock feed every day at sub-location only because this will be used by risk mangement reports.
- I've attached both JDE FD and iRely FD to this ticket. Chakra will handle the IDOC message proecessing part and call this SP for every record in that IDOC message.
|