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