#ygrps-yiv-1617478963 .ygrps-yiv-1617478963ygrp-photo-title { TEXT-ALIGN:center;WIDTH:75px;HEIGHT:15px;CLEAR:both;FONT-SIZE:smaller;OVERFLOW:hidden;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963ygrp-photo { BORDER-BOTTOM:black 1px solid;BORDER-LEFT:black 1px solid;BACKGROUND-COLOR:white;WIDTH:62px;BACKGROUND-REPEAT:no-repeat;BACKGROUND-POSITION:center 50%;HEIGHT:62px;BORDER-TOP:black 1px solid;BORDER-RIGHT:black 1px solid;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963photo-title A { TEXT-DECORATION:none;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963photo-title A:active { TEXT-DECORATION:none;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963photo-title A:hover { TEXT-DECORATION:none;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963photo-title A:visited { TEXT-DECORATION:none;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963attach-table DIV.ygrps-yiv-1617478963attach-row { CLEAR:both;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963attach-table DIV.ygrps-yiv-1617478963attach-row DIV { FLOAT:left;} #ygrps-yiv-1617478963 P { PADDING-BOTTOM:3px;PADDING-LEFT:0px;PADDING-RIGHT:0px;CLEAR:both;OVERFLOW:hidden;PADDING-TOP:15px;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963ygrp-file { WIDTH:30px;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963attach-table DIV.ygrps-yiv-1617478963attach-row DIV DIV A { TEXT-DECORATION:none;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963attach-table DIV.ygrps-yiv-1617478963attach-row DIV DIV SPAN { FONT-WEIGHT:normal;} #ygrps-yiv-1617478963 DIV.ygrps-yiv-1617478963ygrp-file-title { FONT-WEIGHT:bold;}
----- Original Message -----Sent: Friday, March 06, 2015 9:59 AMSubject: RE: [Vantage] E9: Understanding PartFIFOTranWhen you run the stock status – what checkboxes did you click?
I have found difference in costing method between Part and PartPlant.
We also received some product with Typecode K in from RMA’s and they did not print on the stockstatus.
Also look at the differences between sysdate on the transaction vs trandate can cause problems.
Run the Inventory/WIP Reconciliation report for un posted transaction in prior fiscal periods and years.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 06, 2015 8:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Understanding PartFIFOTran
300K+
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:1f97d6.png@85856807.4a98014f]
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, March 06, 2015 9:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Understanding PartFIFOTran
How far off are you in reconciling to the GL?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 06, 2015 6:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Understanding PartFIFOTran
Hi Cathy,
Accounting needs this.
After 4 years of being on Epicor, we are just finding that our inventory GL was never reconciled to Stock Status.
We now have a big gap and we have never captured Stock Status at the end of the month so we need some way to accurately recreate stock status on a given day. With the limitation of the canned Stock Status report, for historical dates, our only choice is to create our own.
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:23e9b8.png@5c72fabc.48a50162]
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, March 05, 2015 2:55 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] E9: Understanding PartFIFOTran
Who really wants this?
Sometimes we put too much work into something because of the customer that really gives no benefit.
What are they getting out of this information – a few dollars?
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 12:01 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Understanding PartFIFOTran
Hello,
I am trying to create a query that will allow me to recreate the information on Stock Status from any point in time.
I was thinking that I would need to connect PartTran to PartFIFOTran in order to get the actual cost of a transaction. (We use FIFO costing).
I also assumed I would link the two tables with the field TranNum.
I then noticed that if a transaction pulled a quantity that spanned multiple cost layers, that I would have a record in PartFIFOTran for each cost layer.
This made sense but then I came across a PartTran that has 149 PartFIFOCost records and the transaction quantity was only 1.
I can adjust my query to account for this but this total blew my mind.
Anyone have an idea of why this would be?
Each PartFIFOTran record has a TranQty of zero except for one of them, which makes it even more weird.
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:3d5d1c.png@af84f053.448e9a75]
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]
This email has been checked for viruses by Avast antivirus software.
www.avast.com