Daybook - Credit control macro - Macros very neat way able add exactly sort functionality need Enterprise Modulus very really simple ones those make big macro aimed credit controllers simply brings list unpaid overdue invoicesWe recommend Enterprise users use power Data List list accessed click Modulus users should paste Process macro assign function DateCurrent line finds invoices over old change Due0Now looks those amount line looking Posted invoices filtering receipts deposits


The Daybook e-letter	news, tips and features to help you get the best from your system



	Credit control macro Macros are a very neat way of being able to add in exactly the sort of functionality you need into Enterprise or Modulus. And very often the really simple ones are those that make a big difference. Here is a macro aimed at credit controllers. It simply brings up a list of unpaid overdue invoices. We recommend Enterprise users to use it to power a Data List., so that the list can be accessed with one click. Modulus users should paste it into a Same Process macro and assign it to a function key. QUERY([INVOICES];[INVOICES]Due Date>=(Current Date()-30);) `This line finds invoices which are over 30 days old. You can change the number. QUERY([INVOICES]; & ;[INVOICES]Total Due#0;*) `Now it looks for those which do not have 0 as the amount due QUERY([INVOICES]; & ;[INVOICES]State=2) `This line is looking for Posted invoices, so filtering out receipts and deposits Back to main newsletter »