Dataport - Item & Item Ledger Entry

edmasto65

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?

snyktp

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

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

Thanks fort the help. Both of these worked!