Advanced MRP Addon for SAP B1

• User can select without SO type manual. If user select Without SO then user need to select Branch, From Date, To Date and Item manually on header , Based on selected From date, To date and Item code, All Forecast names will show in list, when you select any forecast then then Total Qty comes according to selected fore cast.
• You can select Procurement Type Purchase Order/ Purchase Request like this.

Click on view button – based on the header BOM item all row material and linked Multi-level all BOM items will be load in the matrix

• User can select with SO type manual. when user select With SO then user need to select Branch, From Date, To Date and Item manually on header , Based on selected From date, To date and Item code, All Sales orders show in list like SO No., SO Date, SO Qty and Del Date. When you press Calculate Qty button then All sales order Quantities sum will come on Total Qty field

• You can select Procurement Type Purchase Order/ Purchase Request like this.

Click on view button – based on the header BOM item all row material and linked Multi-level all BOM items will be load in the matrix

• Document Selection: Users can select the required matrix rows using the Generate Document checkbox.
• Net Required Quantity Validation: Documents will be generated only for selected items where Net Required Quantity > 0.
• Procurement Type-Based Generation:
  • Production Order: A separate Production Order will be generated for each item.
  • Purchase Request: A single Purchase Request will be generated for all selected items with Procurement Type = Purchase Request.
  • Purchase Order: Purchase Orders will be grouped based on Order Date and Vendor. Items with the same Order Date and Vendor will be included in a single Purchase Order; different combinations will generate separate Purchase Orders.
• Row-Level Processing: Documents will be generated only for the rows selected by the user.
• Post-Generation Lock: Once a document is successfully generated, the corresponding row will become read-only, preventing duplicate document generation.
• Pending Items: Users can generate documents later for rows that remain pending.
• Status Update: The system will automatically update the status to Closed for each successfully processed row.
• Document-Level Closure: Once documents have been generated for all applicable rows, the overall document status will automatically be updated to Closed.

Example 1- When click on Generate button then selected Procurement type Production order will post row wise and status will be closed after posting automatically.

Example 2 – When click on Generate button then selected Procurement type purchase requests will post row wise and status will be closed after posting automatically.