PO Item Group Expression Configuration

YouTube: How to Set Up a Default PO Item Group Expression in Purchase Orders?

How to Set Up a Default PO Item Group Expression in Purchase Orders?

This tutorial explains how to automatically generate Purchase Orders using Item Group Expression Configuration in Logic ERP. With this feature, the system intelligently calculates Purchase Order quantities based on predefined expression formulas configured item group-wise.


Objective of This Feature

  • Automate Purchase Order quantity calculation.

  • Generate PO quantities using predefined formulas.

  • Reduce manual quantity calculations.

  • Improve procurement planning and efficiency.

  • Apply Item Group-wise purchase logic automatically.


Access to Purchase Order Configuration

  • Open Purchase Order Configuration Window.

  • Navigate to Defaults Section.

  • Locate the option labeled as:

“PO Item Group Expression Configuration”

Available Configurations

  • The dropdown displays all predefined expression configurations available in the system.

Action

  • Select required Expression Configuration.

  • Save the Configuration.


Create a New Purchase Order

Transaction Process

  • Initiate New Purchase Order Entry.

  • Define Supplier.

  • Proceed to Item Details Section.


Retrieve Items Using Expression Configuration

  • Click Retrieve Button.

  • Select Retrieve from Item Group Expression.

  • Click OK


Select Item Group and Retrieve Items

System Behavior

  • A new window appears displaying:

    • Item Groups.

Important

  • By default:

    • Only those Item Groups are displayed for which expressions are already configured.

  • Click Refresh.

System Behavior

  • The system automatically:

    • Calculates PO Quantity according to the defined expression formula.

Final Step

  • Click OK

Result

  • Items along with calculated PO quantities:

    • Are automatically retrieved into the Purchase Order


Configure Item Group Wise Expressions

  • Go to Main Menu → Setup Module

  • Open Configurations Menu

  • Select Setup Item Group Wise Expression for PO Calculations

Create a New Expression Configuration

  • Define Configuration Name

  • Select Item Group.

Define Expression Formula

  • Press Space Key in the Expression column.

  • Script Editor opens.

Formula Setup

  • Using:

    • Available Fields

    • Functions

  • Create Required Formula for PO Quantity Calculation.

  • Save the Expression Configuration


Customize and Reuse Configurations

Additional Features

  • Customize Configuration settings as per business requirements

  • Copy PO Expressions from Source Groups to Destination Groups


Key Benefits

  • Automates Purchase Order quantity calculations

  • Reduces manual effort and errors

  • Supports intelligent procurement planning

  • Enables flexible Item Group-wise PO generation

  • Improves inventory management efficiency


Best Practice Tips

  • Define accurate formulas for each Item Group

  • Review expression configurations periodically

  • Use standardized calculation logic across departments

  • Test configurations before applying them in live transactions


Final Outcome

  • Purchase Order quantities are automatically calculated using predefined expressions

  • Item Group-wise procurement becomes faster and smarter

  • Manual quantity calculations are minimized

  • Purchase planning becomes more accurate and efficient in Logic ERP

Last updated