Epicor 9.05.702A BAQ Help

Link the parts to the part tran (last). That should get you all of the parts and their last part transaction.

 

Charlie Smith

CTCharlie@...

Cell: 860-919-1708

Office: 817-862-9862

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 04, 2015 9:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.702A BAQ Help

 

 

I am trying to get the date of the last PartTran (if any) for each of our items.

Is there a way to only return the maximum PartTran.TranNUm instead of all rows for each item?

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

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.


“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

I am trying to get the date of the last PartTran (if any) for each of our items.

Is there a way to only return the maximum PartTran.TranNUm instead of all rows for each item?


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

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.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

On the phrase builder tab there is an option, select your table then drop down under ‘Which item’, try either first or last. That should do it.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 04, 2015 9:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.702A BAQ Help


I am trying to get the date of the last PartTran (if any) for each of our items.
Is there a way to only return the maximum PartTran.TranNUm instead of all rows for each item?

Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com
[Image removed by sender.]
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.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”



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

Excellent!  Thanks very much!

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 04, 2015 10:52 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: Epicor 9.05.702A BAQ Help

 

 

On the phrase builder tab there is an option, select your table then drop down under ‘Which item’, try either first or last. That should do it.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 04, 2015 9:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.702A BAQ Help


I am trying to get the date of the last PartTran (if any) for each of our items.
Is there a way to only return the maximum PartTran.TranNUm instead of all rows for each item?

Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com
[Image removed by sender.]
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.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”


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


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

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.