Need buffered store for list of Inbound Shipment details

Issue No: LG-117
Created 6/16/2015 4:52:46 AM
Type Task
Priority Major
Status Closed
Resolution Fixed
Fixed Version 15.3
Description On the Integration of Logistics into Inventory, we will need buffered stores that we'll be using on our dropdowns. For more info, please check out 'vyuPODetails' view on the database. The schema of this view is being used on PO and Inventory Integration on Receipt. It is most likely that the fields on the specified view are needed as well for Logistics Integration.. You may choose to not follow the field names of the view, but we will need to know the mapping of your fields to ours..   Expose a stored procedure to update the received quantity for selected each purchase contract from this store.   There are 2 scenarios in using Inbound Shipment screen.   1. Entering on Purchase contract details without Container details   2. Entering Purchase contract and container details   Buffered Store: Logistics.store.BufferedShipmentReceiptContracts   Alias: lgbufferedshipmentreceiptcontracts   Key field in this store: intShipmentContractQtyId   In case of #1 scenario, intShipmentBLContainerContractId will be -1 and store intShipmentContractQtyId as source key in your receipt table.   In case of #2 scenario, store intShipmentBLContainerContractId as source key in your receipt table.   SP to update Contract Received Qty: uspLGShipmentUpdatePurchaseContractReceivedQty (intShipmentContractQtyId, dblReceivedQty). This SP needs to be called for scenario #1 and scenario 2.   SP to update Container Received Qty: uspLGShipmentUpdateContainerReceivedQty (intShipmentBLContainerContractId , dblReceivedQty). This SP needs to be called for only scenario #2   Call these SPs passing give parameters on saving a receipt transaction.