Kim,
Thanks for the reply.
Tim Lester
Thanks for the reply.
Tim Lester
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
What kind of information are you looking for? I usually export either the entire report or selected accounts to Excel – Data only and then use formulae, filters and/or pivot tables to get the information that I need.
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
Hi Tim,
My goal is to be able to determine what specific transactions make up the “Periodic Posting Process†entry against our inventory GL.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:f9f232.png@3455fa89.4284808d]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
What kind of information are you looking for? I usually export either the entire report or selected accounts to Excel – Data only and then use formulae, filters and/or pivot tables to get the information that I need.
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
My goal is to be able to determine what specific transactions make up the “Periodic Posting Process†entry against our inventory GL.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:f9f232.png@3455fa89.4284808d]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
What kind of information are you looking for? I usually export either the entire report or selected accounts to Excel – Data only and then use formulae, filters and/or pivot tables to get the information that I need.
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
We have tried to recreate the report and have not been successful because some of the information is in a temporary table that is not created until you run the report.
If you are looking for the transaction type – on the menu screen of the report there is a section called specific transaction type. If you pull that down that field, it will show all the transaction type that appears on the report. Also, attached is a copy of the inventory transactions detail that will explain more on the transaction types. If the attachment does not appear, email me and I will provide it to you.
Deirdre Sykes | Finance Supervisor
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8112 | Fax: 630.325.8197
Celebrating 30 Years of Excellence!
Like us on Facebook: [facebook] <https://www.facebook.com/pages/GSI-Technologies/624368870969219> Click: [linkedin] <http://www.linkedin.com/company/2690732?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A176974291386194698817%2CVSRPtargetId%3A2690732%2CVSRPcmpt%3Acompanies_cluster> and [followlinkedin] <http://www.linkedin.com/company/gsi-technologies?trk=company_name> us on Linked-In
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Hi Tim,
My goal is to be able to determine what specific transactions make up the “Periodic Posting Process†entry against our inventory GL.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:f9f232.png@3455fa89.4284808d]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:41 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
What kind of information are you looking for? I usually export either the entire report or selected accounts to Excel – Data only and then use formulae, filters and/or pivot tables to get the information that I need.
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...<mailto:tim.hager@...%3cmailto:tim.hager@...>>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com%3chttp:/www.matsinc.com>>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com%3chttp:/www.matsinc.com>>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.
[Non-text portions of this message have been removed]
If you are looking for the transaction type – on the menu screen of the report there is a section called specific transaction type. If you pull that down that field, it will show all the transaction type that appears on the report. Also, attached is a copy of the inventory transactions detail that will explain more on the transaction types. If the attachment does not appear, email me and I will provide it to you.
Deirdre Sykes | Finance Supervisor
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8112 | Fax: 630.325.8197
Celebrating 30 Years of Excellence!
Like us on Facebook: [facebook] <https://www.facebook.com/pages/GSI-Technologies/624368870969219> Click: [linkedin] <http://www.linkedin.com/company/2690732?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A176974291386194698817%2CVSRPtargetId%3A2690732%2CVSRPcmpt%3Acompanies_cluster> and [followlinkedin] <http://www.linkedin.com/company/gsi-technologies?trk=company_name> us on Linked-In
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Hi Tim,
My goal is to be able to determine what specific transactions make up the “Periodic Posting Process†entry against our inventory GL.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:f9f232.png@3455fa89.4284808d]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:41 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
What kind of information are you looking for? I usually export either the entire report or selected accounts to Excel – Data only and then use formulae, filters and/or pivot tables to get the information that I need.
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...<mailto:tim.hager@...%3cmailto:tim.hager@...>>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com%3chttp:/www.matsinc.com>>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com%3chttp:/www.matsinc.com>>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.
[Non-text portions of this message have been removed]
We have created a this. email me if you need to see what we did kwhite@...
We are on Epicor 9.05.702A
On Thursday, June 11, 2015 3:01 PM, "Deirdre Sykes dsykes@... [vantage]" <vantage@yahoogroups.com> wrote:
<div id="ygrps-yiv-2046623472yiv2341571261ygrp-text">
<div>We have tried to recreate the report and have not been successful because some of the information is in a temporary table that is not created until you run the report.
If you are looking for the transaction type – on the menu screen of the report there is a section called specific transaction type. If you pull that down that field, it will show all the transaction type that appears on the report. Also, attached is a copy of the inventory transactions detail that will explain more on the transaction types. If the attachment does not appear, email me and I will provide it to you.
Deirdre Sykes | Finance Supervisor
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8112 | Fax: 630.325.8197
Celebrating 30 Years of Excellence!
Like us on Facebook: [facebook] <https://www.facebook.com/pages/GSI-Technologies/624368870969219> Click: [linkedin] <http://www.linkedin.com/company/2690732?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A176974291386194698817%2CVSRPtargetId%3A2690732%2CVSRPcmpt%3Acompanies_cluster> and [followlinkedin] <http://www.linkedin.com/company/gsi-technologies?trk=company_name> us on Linked-In
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Hi Tim,
My goal is to be able to determine what specific transactions make up the “Periodic Posting Process†entry against our inventory GL.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:f9f232.png@3455fa89.4284808d]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:41 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
What kind of information are you looking for? I usually export either the entire report or selected accounts to Excel – Data only and then use formulae, filters and/or pivot tables to get the information that I need.
Tim Hager
Controller
tim.hager@...<mailto:tim.hager@...<mailto:tim.hager@...%3cmailto:tim.hager@...>>
[Primary Logo Auto Signature Fax 0663]
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 11, 2015 11:29 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
I did not. :(
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com%3chttp:/www.matsinc.com>>
Ask us about our clean, green and beautiful matting and flooring
[cid:b0a22e.png@276d7d09.4c80f07e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 3:36 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] RE: E9: Creating query to pull same data as Inventory/WIP Recon report
Did you have any luck re-creating the report?
Thanks
Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 09, 2015 2:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] E9: Creating query to pull same data as Inventory/WIP Recon report
Hi All,
I’m trying to create a query that pulls the same data as the Inventory/WIP Reconciliation report.
It looks like PartTran is involved but it must be more than that.
For example, I ran this report for just our inventory account, just posted, with a date range of just 3/1/2015.
I was trying to see what transaction were in the “Periodic Posting Process†for this date.
The report showed transactions with dates in February (2/25 to 2/28).
There were no transaction with a date of 3/1.
So now I’m trying to figure out what table/field the 3/1 is being compared to.
In short, does anyone know what tables I will need to pull the same data as the Inv/Wip Recon report?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com%3chttp:/www.matsinc.com>>
Ask us about our clean, green and beautiful matting and flooring
[cid:b9afe4.png@0a61fe56.418edc59]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.
[Non-text portions of this message have been removed]
</div>
<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mkp hr {
border:1px solid #d8d8d8;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mkp #ygrps-yiv-2046623472yiv2341571261hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mkp #ygrps-yiv-2046623472yiv2341571261ads {
margin-bottom:10px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mkp .ygrps-yiv-2046623472yiv2341571261ad {
padding:0 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mkp .ygrps-yiv-2046623472yiv2341571261ad p {
margin:0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mkp .ygrps-yiv-2046623472yiv2341571261ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-sponsor #ygrps-yiv-2046623472yiv2341571261ygrp-lc {
font-family:Arial;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-sponsor #ygrps-yiv-2046623472yiv2341571261ygrp-lc #ygrps-yiv-2046623472yiv2341571261hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-sponsor #ygrps-yiv-2046623472yiv2341571261ygrp-lc .ygrps-yiv-2046623472yiv2341571261ad {
margin-bottom:10px;padding:0 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261activity span {
font-weight:700;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261activity span:first-child {
text-transform:uppercase;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261activity span a {
color:#5085b6;text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261activity span span {
color:#ff7900;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261activity span .ygrps-yiv-2046623472yiv2341571261underline {
text-decoration:underline;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261attach div a {
text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261attach img {
border:none;padding-right:5px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261attach label {
display:block;margin-bottom:5px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261attach label a {
text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 blockquote {
margin:0 0 0 4px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261bold {
font-family:Arial;font-size:13px;font-weight:700;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261bold a {
text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 dd.ygrps-yiv-2046623472yiv2341571261last p a {
font-family:Verdana;font-weight:700;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 dd.ygrps-yiv-2046623472yiv2341571261last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 dd.ygrps-yiv-2046623472yiv2341571261last p span.ygrps-yiv-2046623472yiv2341571261yshortcuts {
margin-right:0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261attach-table div div a {
text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261attach-table {
width:400px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261file-title a, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261file-title a:active, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261file-title a:hover, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261file-title a:visited {
text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261photo-title a, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261photo-title a:active, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261photo-title a:hover, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div.ygrps-yiv-2046623472yiv2341571261photo-title a:visited {
text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 div#ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg #ygrps-yiv-2046623472yiv2341571261ygrp-msg p a span.ygrps-yiv-2046623472yiv2341571261yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261green {
color:#628c2a;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261MsoNormal {
margin:0 0 0 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 o {
font-size:0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261photos div {
float:left;width:72px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261reco-category {
font-size:77%;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261reco-desc {
font-size:77%;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 .ygrps-yiv-2046623472yiv2341571261replbq {
margin:4px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg table {
font-size:inherit;font:100%;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg select, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 input, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg pre, #ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 code {
font:115% monospace;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg * {
line-height:1.22em;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-mlmsg #ygrps-yiv-2046623472yiv2341571261logo {
padding-bottom:10px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-msg p a {
font-family:Verdana;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-msg p#ygrps-yiv-2046623472yiv2341571261attach-count span {
color:#1E66AE;font-weight:700;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-reco #ygrps-yiv-2046623472yiv2341571261reco-head {
color:#ff7900;font-weight:700;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-reco {
margin-bottom:20px;padding:0px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-sponsor #ygrps-yiv-2046623472yiv2341571261ov li a {
font-size:130%;text-decoration:none;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-sponsor #ygrps-yiv-2046623472yiv2341571261ov li {
font-size:77%;list-style-type:square;padding:6px 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-sponsor #ygrps-yiv-2046623472yiv2341571261ov ul {
margin:0;padding:0 0 0 8px;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-text {
font-family:Georgia;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-text p {
margin:0 0 1em 0;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-text tt {
font-size:120%;}
#ygrps-yiv-2046623472 #ygrps-yiv-2046623472yiv2341571261 #ygrps-yiv-2046623472yiv2341571261ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-2046623472
Hi Joe!
I've uploaded the notes I got from Epicor support on how the WIP report works (Report notes WIP report). I didn't get as far as creating the report, but it is helpful when you're trying to understand where some of these numbers are coming from.
Jenn
Thanks Jenn.
This will be very helpful.
What I’m looking for similar information behind the “Inventory/WIP Reconciliation†report as opposed to the “Work In Process†report.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:66223c.png@9829f5e6.4ea747df]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, June 12, 2015 10:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Creating query to pull same data as Inventory/WIP Recon report
Hi Joe!
I've uploaded the notes I got from Epicor support on how the WIP report works (Report notes WIP report). I didn't get as far as creating the report, but it is helpful when you're trying to understand where some of these numbers are coming from.
Jenn
[Non-text portions of this message have been removed]
This will be very helpful.
What I’m looking for similar information behind the “Inventory/WIP Reconciliation†report as opposed to the “Work In Process†report.
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:66223c.png@9829f5e6.4ea747df]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, June 12, 2015 10:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Creating query to pull same data as Inventory/WIP Recon report
Hi Joe!
I've uploaded the notes I got from Epicor support on how the WIP report works (Report notes WIP report). I didn't get as far as creating the report, but it is helpful when you're trying to understand where some of these numbers are coming from.
Jenn
[Non-text portions of this message have been removed]
Realize this is a year old but this has become a requirement for us, so looking to see what others did. We are SQL, so SQL Queries or Crystal Report rpt files are fine.
Joe - did you ever solve this?
Kim - would love to see what you did for this.
Thanks.
Tim Lester
Joe - did you ever solve this?
Kim - would love to see what you did for this.
Thanks.
Tim Lester
We started with a BAQ but it was so big it kept crashing. We ended up with an outside contractor writing and SSRS report for us. Runs much better. I would recommend SSRS or SQL (maybe web based)
Thanks Kim