Specific Costing for Lot No Tracking

aryus
aryus Member Posts: 5
edited 2012-05-28 in NAV Three Tier
Hi, I have a scenario where raw materials are purchased in KG and are tracked by lot nos. Assigning serial no is not practical. I want to apply specific cost from the Lot no while posting consumption. Is it possible in standard NAV without customization? I'm using NAV 2009 R2 Classic W1 version.

Thanks.

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    As per the coding in OnValidate trigger of Costing method field in Item table NO
    ItemTrackingCode.GET("Item Tracking Code");
  IF NOT ItemTrackingCode."SN Specific Tracking" THEN
    ERROR(
      Text018,
      ItemTrackingCode.FIELDCAPTION("SN Specific Tracking"),
      FORMAT(TRUE),ItemTrackingCode.TABLECAPTION,ItemTrackingCode.Code,
      FIELDCAPTION("Costing Method"),"Costing Method");

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • aryus
    aryus Member Posts: 5
    Any solution for this?
  • james_cs
    james_cs Member Posts: 39
    Just spotted this - hope its still useful.

    If you use FIFO costing with the setting "Lot Specific Tracking" then the outbound entries will be applied to inbound entries by lot - which will be lot specific costing. this is just as it works...

    james
  • mreichenbacher
    mreichenbacher Member Posts: 1
    FANTASTIC!!!! I was aware that specific costing only worked for serialized items, so I was doing a quick search for existing modifications to support Lot specific costing. Your suggestion was EXACTLY what I needed. Thank you, thank you thank you!
  • Yashojit_Pandhare
    Yashojit_Pandhare Member Posts: 38
    Yes.. If you use FIFO with Lot Tracking, you will get Lot Specific Costing!!

Categories