Raw Material Rates
YouTube: How to Configure Rates Displayed in Raw Material Details in Job Orders
How to Configure Rates Displayed in Raw Material Details in Job Orders?
In this tutorial, we will learn how to configure the source and rate type for automatically picking Raw Material Rates in Job Orders. Logic ERP allows you to pick rates either from the Item Master or the Lot Master, helping ensure accurate and consistent raw material costing.
Objective of This Feature
Automatically pick raw material rates during Job Order entry
Pick rates from the Item Master or Lot Master
Support different rate types as per business requirements
Reduce manual rate entry
Improve raw material costing accuracy
Access to the Job Order Configuration
Go to the Configuration Window
Navigate to the Raw Material Settings section
Here, you will find the "Raw Material Rates" option with two choices:
Item Master – Picks the selected rate from the Item Master.
Lot Master – Picks the selected rate from the latest transacted Lot.
Pick Rate from Item Master
Select Item Master under Raw Material Rates.
Choose the required Rate Type from the dropdown, such as MRP.
Save the configuration.
Create a Job Order
Initiate a New Job Order entry.
Transact the required item.
Click on Raw Material Details.
Result
The raw material MRP is automatically picked from the Item Master.
Verify the Item Master Rate
Open the Item Master Setup window.
Search for the same item.
Navigate to the Pack Details section.
Under Item Rates, review the MRP defined for the item.
As MRP was selected in the configuration, the same rate is automatically reflected in the Job Order's Raw Material Details.
Pick Rate from Lot Master
Now, let's change the rate source from the Item Master to the Lot Master.
Return to the Configuration Window.
Set Raw Material Rates to Lot Rates.
Select the required Rate Type, such as Basic Rate.
Save the configuration.
Create a New Job Order
Initiate a new Job Order entry.
Transact the same item.
Open Raw Material Details.
Result
The system automatically picks the Basic Rate from the latest transacted Lot.
Verify the Lot Master Rate
Open the Purchase Voucher window.
Open the Lot Details section.
Check the latest purchased Lot.
Since Basic Rate was selected in the configuration, the Job Order picks from the latest Lot.
Pick Sale Rate from Lot Master
The Lot Master can also be used to pick other rate types
Return to the Configuration Window.
Keep the source as Lot Rates.
Change the Rate Type from Basic Rate to Sale Rate.
Save the configuration.
Create Another Job Order
Initiate a new Job Order entry.
Transact the required item.
Open Raw Material Details.
Result
The system now automatically picks the Sale Rate from the Lot Master.
Key Benefits
Flexible Rate Source: Pick rates from Item Master or Lot Master.
Automatic Rate Pickup: Eliminates repetitive manual rate entry.
Accurate Costing: Uses predefined rates for raw materials.
Latest Lot Support: Automatically picks rates from the latest transacted Lot.
Improved Efficiency: Simplifies Job Order processing and reduces errors.
Best Practice Tips
Use Item Master when standard item-wise rates should be applied.
Use Lot Master when the latest purchased Lot rate should be considered.
Select the appropriate Rate Type according to your costing requirements.
Verify the configured rate source before creating Job Orders.
Final Outcome
After configuring Raw Material Rates, Logic ERP automatically picks the required raw material rate from the selected source—Item Master or Lot Master—based on the configured Rate Type. This ensures faster Job Order entry, consistent costing, and accurate raw material valuation.
Last updated