Tag Archives: Selection Criteria

HOW TO MATCH OPEN ITEMS IN SAGE X3

Sage X3 uses an automatic matching process when posting open items which are applied to other open items. For example a payment made for some invoices is posted. During this posting process the details are loaded into a temporary table called MTCBATCH. Within this table the documents are matched together, open item entries are marked… Read More: HOW TO MATCH OPEN ITEMS IN SAGE X3 »

Adding run time selection criteria in SQL requester

You may come across a situation where you want to add criteria’s for SQL requester. Follow below instructions to add search criteria to the SQL requester. New Stuff: How to use Import to Excel functionality in version 7? Step 1: Go to Setup> Usage> Reports> SQL requester Parameter definition: If this field is entered, a… Read More: Adding run time selection criteria in SQL requester »