Saturday, December 1, 2018

Dynamics NAV - Modify R5808 Item Age Composition to use original receipt dates even if transferred


  • T339 Item Application Entry
    • Add flowfield for Item No from item ledger entry no
      • Lookup("Item Ledger Entry"."Item No." WHERE (Entry No.=FIELD(Item Ledger Entry No.)))
    • Add date field for OrigRctDate
  • Create routine to update OrigRctDate 
    • Purchase Receipts
      • Filter where Outbound Item Entry = 0 and Transaction Type = 'Purchase'
      • For each entry, copy the original receipt date on all subsequent inbound entries
      • Follow the chain through to the end, and copy the same orig rct date for all
    • All Other Trx
      • Scan through each record in the Item Application entry with a blank OrigRctDate
      • Lookup the inbound entry OrigRctDate, apply it to this record
      • Repeat for all records
    • Postive Adjustments and other positive unknown transactions
      • Find the oldest open purchase rct trx, use the OrigRctDate form there
  • Modify the R5808 Item Age Composition Value
    • Add Routine to calculate InvQty by using Item Application Entry OrigRctDates, but use Item Ledger entry Remaining Quantities
    • Update ItemLedgerEntry Onaftergetrecord to actually run For 1 to 5 for all array variables

No comments:

Post a Comment