MultiValue Tech Tip!

How many of us would like to have a list of what was entered today, what's due today, or what shipped today? I imagine there are a couple of us anyway. Here are 2 easy ways to get such a report. We'll use Sales Orders entered Today for our examples.

This example may be useful as a wIntegrate Query. The idea here is to use a dict item that will compare today's date with that on a record. I created a dict item, Z_TODAYS_ORDERS , with the following v-code:

IF (DATE()=F1) THEN 1 ELSE ""

Using Info/Access, I can now select and list those Sales Order entered today:

SORT SO WITH Z_TODAYS_ORDERS BY SOLD_TO_NAME SO_NO DATE SOLD_TO SOLD_TO_NAME TOTAL SO_AMT HEADING"'T' Sales Orders for Today 'L'" ID-SUPP

From Kore Technologies Website

menu
menu