One of the features of the default Lists in SmartList, Excel Reports & Navigation Lists is that you can often see ALL GP transactions for a certain type on one list – Work (unposted), Open (unpaid or not moved to history), and History (moved to history). Now – don’t get me wrong - sometimes this feature is great, but a lot of my Builder Lists are to isolate just one status of GP transactions. (For example, most of my clients that use Sales Order Processing have separate Open & History Lists from builder…) What if you DO want more than one status on a Builder List? On first glance, it seems difficult or impossible – that data is in separate tables and you can’t just start with the open table and add the work table (there wouldn’t be matching records – so you won’t get anything!) Don’t worry – there is another way. For example, you want to build a SmartList for payables transactions for a certain period of time and all of the distributions of these documents. You really don’t care if the documents are paid or not (How they move to History in PM), you still want the documents to show on your list. Matched Tables First Start like normal and add your Transaction table for one status (I like to use open, but you could use history – it doesn’t matter).
Continue reading →