Oracle Analytics and AI

Cathy A-Marks

Mobile Inventory/Requisitioning Module

Round up if quantity ordered is not divisible by standard order quantity

If an order is placed using a quantity that is not divisible by the standard order quantity then round up to standard order quantity.

Example:

Purchase Orders are set to be ordered in Case quantities each CASE has 6 Eaches. Using self-service requisition a user creates a requisition for 3 EA. Currently the PO will be for .5 CS.  We would like to see the system round it up to 1 CS.

Thank you

J Holliday-Bass

This request is a priority request which allows for better inventory controls with the client's business model;

Rule logic:

1. Divisibility Check:
   • Define a base unit (e.g., case pack size, standard quantity) — let's assume 5 for this example.
   • For each inventory item quantity:
     • If divisible by 5 → no change
     • If not divisible:
       • Round up to the nearest multiple of 5 if rounding up is preferred
       • Or round down if minimizing overstock is preferred
       • Or round to the nearest multiple of 5 if balance is preferred
2. Example:
   • Quantity: 47 → Nearest multiple of 5 is 45 or 50
     • Round up → 50
     • Round down → 45
     • Nearest → 45 (since 47 is closer to 45 than 50)

Considerable Options for making this change:

• ERP Integration: This logic can be embedded in inventory update scripts, batch processing jobs, or API endpoints.
• Custom Script: generate a Python script or SQL logic that applies this rule across a dataset.
• Automation: ability to schedule a job to run during inventory reconciliation or order processing.