All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Try using a CON= statement in the attributes of your volume field. [EMAIL PROTECTED] Thank you, Mitch Lawrence Senior Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management Tel: 361.881.3408 Fax: 361.888.6117 Mob: 361.549.8456 AIM: a1d13 MSN: [EMAIL PROTECTED] [EMAIL PROTECTED] If someone has "Made your day", send them a Spirit Buck! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, September 07, 2006 6:25 PM To: [email protected] Subject: [MEDITECH-L] NPR Help Needed All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== Hello All, I have written an NPR to create a download file from the MM Module. In MM there can be more than one Vendor associated with an Item. In my NPR I have included a macro from a KB article to calculate the volumes for each Item. When my file creates I get the correct volumes, but the volumes show up on each subsequent vendor record for the item. I then tried only selecting vendor.order.no EQ "1", but my volumes were incorrect. I would like to blank out any record for the same Item after the first vendor has been written to the file, but I would take just blanking out the volumes so it does not carry forward on the other vendor records? I am in desperate need of a solution, and I have limited NPR experience, so I am looking for any help. Here is an example of what I am talking about. My computed field for item 5002436 is 191 You can see that it shows in both records. 5002436 ADAPTOR IV CLAVE MALE HOSPIRA 119560101 HOSPIRA 119560101 191 CS 107 5002436 ADAPTOR IV CLAVE MALE OWENS & MINOR 32181195601 HOSPIRA 119590101 191 CS 107 (This is the record I would like to zero out) Thank you in advance, Gail Johnston, Business Analyst/Programmer Information Technology Willamette Falls Hospital 1500 Division Street Oregon City, Oregon 97045 503-656-1631, Ex. 3317 FAX # 503-657-6940 [EMAIL PROTECTED] ========================================================= IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should contact the sender and delete the message. Any unauthorized disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
