Hi Allison,
This is a field xx.po.number DAT=FREE JFY=L LEN=10 [EMAIL PROTECTED](MM.PO.urn,MM.PO.item.x)^MM.PO.urn,@MM.PO.number} <mailto:[EMAIL PROTECTED](MM.PO.urn,MM.PO.item.x)%5eMM.PO.urn,@MM.PO.number %7d> xx.last.order.date DAT=DATE JFY=L LEN=8 [EMAIL PROTECTED](MM.PO.urn,MM.PO.item.x)^MM.PO.urn,@MM.PO.order.date} <mailto:[EMAIL PROTECTED](MM.PO.urn,MM.PO.item.x)%5eMM.PO.urn,@MM.PO.order. date%7d> As you can see these fields are almost the same except the last part. This is how to pull info for the last P.O. that uses that item. If you wanted to pull the info for the last time this item was purchased from this vendor then you will need to write a bit more code. The index (item.x) is the index that the purchase order routine uses to search for Pos by item number. For info on the MEDITECH-L you can read the instructions on http://www.iatric.com/information/meditech-info.asp John Toop Humber River Regional Hospital From: meditech-l@MTUsers.com [mailto:[EMAIL PROTECTED] On Behalf Of Allison L. Bowers Sent: May 18, 2007 3:57 PM To: meditech-l@MTUsers.com Subject: [MEDITECH-L] Pulling Most Recent PO Info I have built a report using the DPM MM.ITEM and detail segment mm.item.vendors where I list the item #, mfr, mfr cat #, vendor, vendor cat #, description, packaging, usage qty, and usage cost. I would like to display the last PO number and date for each item. Is this possible? I am new to report writing, so I am not really sure if this can even be done and if so, how to do it. Can anyone help me? Also, I have tried multiple times to get subscribed to the L, but have had no luck. Can anyone help me with this as well? Allison L. Bowers Support Analyst Stanly Regional Medical Center PO Box 1489 301 Yadkin St Albemarle, NC 28002 704-983-8285 http://www.stanly.org <http://www.stanly.org/>
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l
