Report Request Blank Title 81509

The partdtl table will have that you want requirementflag = 1 are the demand records.

The link below is to the schema html built by Sean McDaniel. I use it every day for this kind of research.

http://tech.groups.yahoo.com/group/vantage/files/9.05%20data%20dictionary/

Greg Payne

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Turgeon, Bill
Sent: Friday, December 07, 2012 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Request



I have been asked to create a report that contains the purchased items,
the requirements for the next three months, and total requirements.

Is there a table in Epicor that would contain any of the requirements
for purchased items?

Regards,

Bill Turgeon

Director, Information Technology

Coto Technology, Inc.

66 Whitecap Drive

North Kingstown, RI 02852

Ph: 401-583-7223

Cell: 401-368-9938

Fax: 401-942-0920

E-mail: bturgeon@...<mailto:bturgeon%40cotorelay.com> <mailto:jbentley@...<mailto:jbentley%40cotorelay.com>>


P Please consider the environment before printing this email.

This e-mail and any attachments are for the sole use of the intended
recipients and may be privileged or confidential. Any distribution,
printing or other use by anyone else is prohibited. If you are not an
intended recipient, please contact the sender immediately, and
permanently delete this e-mail and attachments.

[Non-text portions of this message have been removed]


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
I have a request for the following report, can anyone push me in any direction? They want both items posted throug invoing and invoiced or non invoiced receipt items for a period, posted or not with details.

GL Account report. By specific account show Vendor, PO, Part & Invoice # for items that have posted either through AP or receiving. Would also like to choose by part or part class as opposed to GL account. Needs to show all items wether they have a part class or not and show what GL account they posted to wether it was manual AP invoice or through receiving.
I can send you the one I did in Epicor 9, its similar but should get you started

--- On Thu, 8/13/09, Michael McWilliams <mmcwilliams22@...> wrote:


From: Michael McWilliams <mmcwilliams22@...>
Subject: [Vantage] Report Request
To: vantage@yahoogroups.com
Date: Thursday, August 13, 2009, 7:41 PM


Â



I have a request for the following report, can anyone push me in any direction? They want both items posted throug invoing and invoiced or non invoiced receipt items for a period, posted or not with details.

GL Account report. By specific account show Vendor, PO, Part & Invoice # for items that have posted either through AP or receiving. Would also like to choose by part or part class as opposed to GL account. Needs to show all items wether they have a part class or not and show what GL account they posted to wether it was manual AP invoice or through receiving.



















[Non-text portions of this message have been removed]
I have been asked to create a report that contains the purchased items,
the requirements for the next three months, and total requirements.

Is there a table in Epicor that would contain any of the requirements
for purchased items?





Regards,



Bill Turgeon

Director, Information Technology

Coto Technology, Inc.

66 Whitecap Drive

North Kingstown, RI 02852

Ph: 401-583-7223

Cell: 401-368-9938

Fax: 401-942-0920

E-mail: bturgeon@... <mailto:jbentley@...>


P Please consider the environment before printing this email.



This e-mail and any attachments are for the sole use of the intended
recipients and may be privileged or confidential. Any distribution,
printing or other use by anyone else is prohibited. If you are not an
intended recipient, please contact the sender immediately, and
permanently delete this e-mail and attachments.





[Non-text portions of this message have been removed]