- 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
Saturday, December 1, 2018
Dynamics NAV - Modify R5808 Item Age Composition to use original receipt dates even if transferred
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment