Dataport - Item & Item Ledger Entry

edmasto65
edmasto65 Member Posts: 3
in NAV/Navision Classic Client
I want to create a dataport to EXPORT all item ledger entries for only ITEMS that have a quantity on hand of > 0. So if the Item has 0 qty on hand, then I don't want any of the ledger entries exported. Any ideas?

Answers

  • snyktp
    snyktp Member Posts: 75
    You can create a report (to pull info from Item table (with Inventory >0 filter) & Item ledger entry table) for this and use Print -> Microsoft Excel.
  • AlexeyShamin
    AlexeyShamin Member Posts: 80
    Hello!
    You can add temprorary data item "Item" (ItemTmp variable). on trigger OnPreXMLPort fill ItemTmp variable by select records from Item (you can use query - it will be faster)
  • edmasto65
    edmasto65 Member Posts: 3
    Thanks fort the help. Both of these worked!

Categories