Item stuck in Inspection Processing

#ygrps-yiv-775127758 P.ygrps-yiv-775127758b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-775127758 LI.ygrps-yiv-775127758b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-775127758 DIV.ygrps-yiv-775127758b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-775127758 TABLE.ygrps-yiv-775127758b1e7fd89-0279-4ffe-a16a-1f1bcba0d537Table { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-775127758 DIV.ygrps-yiv-775127758Section1 { }

Review the RcvDtl table for the bad item an updatable BAQ may not work unless you know how to write advanced BPMs for it.
It may be quicker to get a data fix off Epicor or work with a consultant to get it cleaned up would probably only take 30 mins to review and solve.


Sent from my iPhone

On 5 Nov 2015, at 21:06, scooley@... [vantage] <vantage@yahoogroups.com> wrote:

 

Hi We're on E9.05.701


So, this is a little weird but bare with me... We had a bit of a botched start to our implementation so we have some "garbage" that occasionally shows up.  


We have an item that we haven't been able to clear our of the Inspection Processing queue. it's a PO receipt from 2 years ago. Since the time of Receipt, we implemented Serial tracking, which calls for the UOM to not contain fractions, whole numbers only. Well, this receipt was a decimal... so... because no one bothered to try and clean this up, we have this stuck in here because when you try to pass or fail it, it won't allow for decimal places.I asked my Finance manager and she had no problems with me trying to manually update that transaction, but I can't quite figure out how.


I looked through the DMT, there isn't anything for Inspection.  Then I thought maybe I would try and updatable BAQ, but I can't find where this would be stored. When I get the technical details of the field (Passed Quantity), it doesn't give me a table that's found in the phrase Build Search of the BAQ. Is there a table that I might be able to find using MySQL or an External Query?


I could filter out the search and the Inspection pending report to not include that transaction, but 


Any other ideas?



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
DDI:  +44 121 314 1179
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

Hi We're on E9.05.701


So, this is a little weird but bare with me... We had a bit of a botched start to our implementation so we have some "garbage" that occasionally shows up.  


We have an item that we haven't been able to clear our of the Inspection Processing queue. it's a PO receipt from 2 years ago. Since the time of Receipt, we implemented Serial tracking, which calls for the UOM to not contain fractions, whole numbers only. Well, this receipt was a decimal... so... because no one bothered to try and clean this up, we have this stuck in here because when you try to pass or fail it, it won't allow for decimal places.I asked my Finance manager and she had no problems with me trying to manually update that transaction, but I can't quite figure out how.


I looked through the DMT, there isn't anything for Inspection.  Then I thought maybe I would try and updatable BAQ, but I can't find where this would be stored. When I get the technical details of the field (Passed Quantity), it doesn't give me a table that's found in the phrase Build Search of the BAQ. Is there a table that I might be able to find using MySQL or an External Query?


I could filter out the search and the Inspection pending report to not include that transaction, but 


Any other ideas?