All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
Hi David,
The following should work out for you:
1) Create a report in MM.ITEM with the Detail Segment mm.item.
2) Use xx.count as a Select Field with Operator EQ and value "0"
3) Use COMMON.date as a Select Field with Operator GE and prompt FROM DATE
4) Use COMMON.date as a Select Field with Operator LE and prompt THRU DATE
5) Define xx.count with the following attributes: DAT=INT
JFY=R
LEN=1
VAL=/ITEMS[item.urn]+0
6) Set up the following Footnote: AL START start.macro
7) File and translate your report.
8) Create a macro called start.macro with the following code:
ZZ%K(/ITEMS),
COMMON.e.date^END,
COMMON.b.date^MM.PUR.STATS.date,
[EMAIL PROTECTED](MM.PUR.STATS.vend.item)
@Add(@MM.PUR.STATS.vend.item.rcv.qty.us,/ITEMS[MM.PUR.STATS.vend.item]);
@Next(MM.PUR.STATS.vendor);
@Next(MM.PUR.STATS.date)'>END},
""^END^MM.PUR.STATS.date^MM.PUR.STATS.vendor^MM.PUR.STATS.vend.item
9) File and translate your macro.
10) Translate your report again.
That should do the trick. The DPM MM.PUR.STATS keeps track of Purchasing
Statstics for Items. Our DO loop counts up the number of items. Our Select
Field xx.count specifies that the count must be equal to "0".
Please let me know if you have any questions.
Thanks,
Brian Schmit
Sr. Programmer, Picis
Direct: 781 557 3315
Fax: 781 557 3140
100 Quannapowitt Parkway
Suite 405
Wakefield, MA 01880
[EMAIL PROTECTED]
www.picis.com
Please visit www.picis.com/meditech for additional information about our NPR
Report Writing Trainings.
The information in this email is confidential and may be legally privileged. It
is intended solely for the addressee. Access or use by any other person to this
internet email is not authorized and may be unlawful. If you are not the
intended recipient, please delete or destroy this email. If you do not wish to
receive future emails from the sender, please reply directly to this email
requesting you be removed from any mailing list.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Zelward
Sent: Friday, June 16, 2006 9:45 AM
To: [email protected]
Subject: [MEDITECH-L] iItem Dictionary Report
All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
