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