Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Lot Number

Posted on by 26
Hi,
 
How can you use lot numbers without using SN specific tracking in standard system?
 
If customization, how would this apply to the item ledger, i want a cost to be applied to a whole batch of items not single items
Categories:
  • gdrenteria Profile Picture
    gdrenteria 12,030 Most Valuable Professional on at
    Lot Number

    Hi, good day
    I hope this can help you, and give you some hints.

    The Complete Guide to Lot Numbers

    Best Regards
    Gerardo

  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 144 on at
    Lot Number
    You can disable serial number tracking while keeping the lot-to-lot option enabled. If costs need to be applied to the entire batch, you’ll need to adjust the costing method in either the inventory setup or the item setup. Switching to the average costing method can provide relatively consistent cost calculations.
     
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,246 Super User 2024 Season 2 on at
    Lot Number
    Hello,
     
    You can turn off SN Specific Tracking while keeping Lot Specific Tracking on.
     
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 338 on at
    Lot Number

    My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your query.
    In Microsoft Dynamics 365 Business Central, Lot Tracking allows you to track groups of items by Lot Number without requiring Serial Number (SN) tracking. This functionality is available out of the box and is particularly useful for managing inventory in batches, where a single cost applies to the entire batch (rather than individual items).

    Here’s how you can use Lot Numbers without Serial Numbers for tracking and costing:


    Option 1: Standard Lot Tracking in Business Central

    Lot numbers can be managed without Serial Number tracking using the Item Tracking Code configuration.

    Step 1: Configure the Item Tracking Code

    1. Go to Item Tracking Codes:

      • Navigate to Tell Me (search) and type Item Tracking Codes.
    2. Create or Edit a Tracking Code:

      • Create a new tracking code or edit an existing one, such as LOT TRACKING.
      • Set up the following fields:
        • SN Specific Tracking: Leave this unchecked (this ensures no Serial Number tracking is applied).
        • Lot Specific Tracking: Check this option (enables Lot Number tracking).
        • Lot Warehouse Tracking: Check this if you want to track Lot Numbers at the warehouse level.
        • Other options (e.g., Expiration Date, Manufacturing Date, etc.) can be configured based on your needs.

    Step 2: Assign the Item Tracking Code to an Item

    1. Go to the Item Card for the item you want to enable Lot Number tracking for.
    2. Assign the Item Tracking Code you configured above (e.g., LOT TRACKING).

    Step 3: Use Lot Numbers in Transactions

    • When creating transactions (e.g., Purchase Orders, Sales Orders, or Production Orders):
      • Enter or select the Lot Number in the Item Tracking Lines window.
      • For a batch of items, the Lot Number is applied to all items in that batch.

    Step 4: Cost Application for Lot Numbers

    • Business Central automatically applies the cost to the entire Lot during transactions.
    • The costing method you’ve defined for the item (e.g., FIFO, Average, or Standard Cost) will be applied to the entire batch (Lot Number), not individual items.

    Option 2: Using Customization to Enhance Lot Tracking (If Necessary)

    If the standard system does not fully meet your needs, customizations can be made to extend the functionality. Here are some examples:

    Scenario: Cost Per Batch Instead of Per Item

    In the standard system, costing applies at the item level even when using Lot Numbers, but the Lot Number itself is not directly used for costing calculations. If you want to apply cost per Lot (batch):

    1. Customization to Track Cost by Lot:

      • Create a custom field for Lot-specific costs in the Item Ledger Entry table or a related table.
      • Modify the posting logic to calculate costs at the Lot Number level rather than individual item entries.
    2. Customization for Lot-Based Costing Reports:

      • Develop a custom report or page to show aggregated costs and quantities for Lot Numbers. This can provide insights into cost by batch.
    3. Modify Posting Behavior (Optional):

      • Modify the cost application logic (e.g., Codeunit 22 - Item Jnl.-Post Line) to distribute or calculate costs per Lot Number rather than individual items.

    How Lot Tracking Applies to the Item Ledger

    In the Item Ledger, Lot Numbers are used to group inventory transactions and apply costing. Here's how it works:

    1. Lot Numbers in the Item Ledger:

      • Each transaction (e.g., purchase, sale, or transfer) creates an Item Ledger Entry.
      • The Lot Number is stored in the Lot No. field of the Item Ledger Entry table (Table 32).
    2. Cost Application:

      • Costs are applied to all items within the same Lot Number during transactions.
      • The Cost Amount (Actual) field in the Item Ledger Entry will reflect the total cost applied to items in the lot.
    3. Tracing and Reporting:

      • Lot Numbers can be traced throughout the system using the Item Tracking Entries table (Table 337).
      • Reports such as Lot Availability by Item or Item Ledger Entries by Lot Number can provide visibility into inventory movements and costs for specific lots.

    Key Benefits of Using Lot Numbers

    1. Batch-Level Traceability:
      • Lot Numbers enable tracking of a group of items from procurement to sale, including production and transfers.
    2. Simplified Costing:
      • Costs are applied to batches rather than individual items, which is ideal for items manufactured or purchased in bulk.
    3. Compliance:
      • Lot tracking helps with regulatory compliance for industries that require batch traceability (e.g., food, pharmaceuticals).

    Common Use Cases

    1. Batch Manufacturing:

      • Lot Numbers can represent a production batch, with costs calculated at the batch level.
      • Example: A batch of 100 units is produced, and a Lot Number is assigned to the entire batch.
    2. Bulk Purchases:

      • Lot Numbers track a shipment or delivery of items purchased together.
      • Example: 500 units purchased together are assigned the same Lot Number, and their cost is shared across the batch.
    3. Warehouse Management:

      • Lot Numbers enable precise tracking of inventory at the warehouse level.
      • You can use the Lot Warehouse Tracking option to ensure Lot Numbers are tracked during warehouse activities.

    Best Practices

    1. Consistent Lot Numbering:
      • Use a consistent Lot Number format (e.g., YYYYMMDD-BatchNo) to ensure traceability.
    2. Costing Method:
      • Choose a costing method that aligns with your requirements (e.g., FIFO for first-in, first-out inventory handling).
    3. Train Users:
      • Ensure users understand how to assign and use Lot Numbers in transactions.
    4. Monitor Reports:
      • Regularly review Lot-related reports (e.g., Lot Availability by Item) to ensure accurate tracking and costing.

    Conclusion

    • Standard System: Use the Item Tracking Code to enable Lot Number tracking without Serial Numbers. Costs are applied at the item level but grouped by Lot Number.
    • Customization (Optional): If you require cost calculations specific to Lot Numbers, customizations can be developed to extend the standard logic.
    • Reporting and Traceability: Utilize out-of-the-box reports or custom reports for detailed insights into Lot-specific inventory and costing.

    This approach allows you to manage costs and inventory efficiently at the batch level using Lot Numbers without Serial Number tracking.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans