Please enable JavaScript.
Coggle requires JavaScript to display documents.
Global Inventory, RCN, Formulas: - Coggle Diagram
Global Inventory
ADD TO CARTPopulate the [FulfillmentControlNumberCartItems] table
- Status defaults to InCart status
Items visible to Logged in User with UserId and ControlNumberPartId props.
Items can be originated from multiple CNs for the same user.
- Reserved qty includes In Cart and Saved for Later status
REQUEST FOR APPROVAL
- Cart Items in InCart status are;
- Deleted
- inserted into the [CartItemApprovalRequests] table
- Requested items may be broken up into multiple RequestGroups depending on ControlNumberOwnerId.
- e.g. Create 1 RequestGroupId for Production and another one for Financials
- [CartItemApprovalRequests].[Status] defaults to Pending
- Reserved qty includes Pending status
Items can be viewed in master / detail pages.
Master being groups and detail being parts.
REQUEST PROCESSING
- for Unselected Items;
- Update [CartItemApprovalRequests].[Status] to Rejected
- for Selected Items;
- Auto Disposition on Original CN.
- Update [CartItemApprovalRequests].[Status] to Approved
- Create FulfillmentControlNumbers
- Multiple Possible depending on LocationId and ControlNumber
-
-
-
-
Formulas:
Reserved Qty:
FulfilmentControlNumberCarts.OrderQty (Incart ,SavedForLater status)
+
FulfillmentControlNumberRequests.OrderQty (Pending Status, Approved Status)
On Hand Qty
Actual Qty - Reserved Qty