E10.1 AP Invoice Issue

Have you tried transferrinf the invoices of that group to another new group?

You can transfer them by selecting an invoice, then Actions + Transfer invoice to another group and select the desired group.


 
Dora Chavarria   Sr. Consultant Analysis Services, ERP   Mayan Technologies USA, Inc. dchavarria@... www.mayantechs.com 


On Wednesday, August 10, 2016 8:58 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-206757434yiv9273385274ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-206757434yiv9273385274gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Have you tried calling support? Do they have any input?</div><div class="ygrps-yiv-206757434yiv9273385274gmail_default" style="font-family:verdana, sans-serif;font-size:small;">If you run GetByID using the BL Tester do you get the same error?</div><div class="ygrps-yiv-206757434yiv9273385274gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Can you run the GetByID stored Proc for PO with that number in SQL and see if you see that value?</div></div><div class="ygrps-yiv-206757434yiv9273385274gmail_extra"><br clear="all"><div><div class="ygrps-yiv-206757434yiv9273385274gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?


On Tue, Aug 9, 2016 at 6:07 PM, bryan.mischler@... [vantage] <vantage@yahoogroups.com> wrote:
 
<div>
  
  
  <div>I copied the database to a test system so this wouldn&#39;t impact&nbsp;production. It took about an hour to run.&nbsp; I ran it for the whole string.&nbsp; I am trying it again now with just the digits after the dash.</div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-206757434yiv9273385274yqt1057993054" id="ygrps-yiv-206757434yiv9273385274yqt11154"><div style="color:#fff;min-height:0;"></div></div>
#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274 -- #ygrps-yiv-206757434yiv9273385274ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mkp #ygrps-yiv-206757434yiv9273385274hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mkp #ygrps-yiv-206757434yiv9273385274ads {
margin-bottom:10px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mkp .ygrps-yiv-206757434yiv9273385274ad {
padding:0 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mkp .ygrps-yiv-206757434yiv9273385274ad p {
margin:0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mkp .ygrps-yiv-206757434yiv9273385274ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-sponsor #ygrps-yiv-206757434yiv9273385274ygrp-lc {
font-family:Arial;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-sponsor #ygrps-yiv-206757434yiv9273385274ygrp-lc #ygrps-yiv-206757434yiv9273385274hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-sponsor #ygrps-yiv-206757434yiv9273385274ygrp-lc .ygrps-yiv-206757434yiv9273385274ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274activity span {
font-weight:700;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274activity span span {
color:#ff7900;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274activity span .ygrps-yiv-206757434yiv9273385274underline {
text-decoration:underline;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274attach div a {
text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274attach img {
border:none;padding-right:5px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274attach label a {
text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274bold a {
text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 dd.ygrps-yiv-206757434yiv9273385274last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 dd.ygrps-yiv-206757434yiv9273385274last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 dd.ygrps-yiv-206757434yiv9273385274last p span.ygrps-yiv-206757434yiv9273385274yshortcuts {
margin-right:0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274attach-table div div a {
text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274attach-table {
width:400px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274file-title a, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274file-title a:active, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274file-title a:hover, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274file-title a:visited {
text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274photo-title a, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274photo-title a:active, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274photo-title a:hover, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div.ygrps-yiv-206757434yiv9273385274photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 div#ygrps-yiv-206757434yiv9273385274ygrp-mlmsg #ygrps-yiv-206757434yiv9273385274ygrp-msg p a span.ygrps-yiv-206757434yiv9273385274yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274green {
color:#628c2a;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 o {
font-size:0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274photos div {
float:left;width:72px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274photos div div {
border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274reco-category {
font-size:77%;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274reco-desc {
font-size:77%;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 .ygrps-yiv-206757434yiv9273385274replbq {
margin:4px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mlmsg select, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 input, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mlmsg pre, #ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 code {
font:115% monospace;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-mlmsg #ygrps-yiv-206757434yiv9273385274logo {
padding-bottom:10px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-msg p#ygrps-yiv-206757434yiv9273385274attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-reco #ygrps-yiv-206757434yiv9273385274reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-sponsor #ygrps-yiv-206757434yiv9273385274ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-sponsor #ygrps-yiv-206757434yiv9273385274ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-sponsor #ygrps-yiv-206757434yiv9273385274ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-text {
font-family:Georgia;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-text tt {
font-size:120%;}

#ygrps-yiv-206757434 #ygrps-yiv-206757434yiv9273385274 #ygrps-yiv-206757434yiv9273385274ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-206757434



We are on 10.1.400.9 and have an AP invoice batch that is locked up.  We can't even delete an invoice from the batch without getting the following error:  Error accessing the database: Conversion failed when converting the nvarchar value '02-693703' to data type int.  I've looked through the invoices and POs associated with this batch and can't find that value anywhere. We migrated from 9.05.702A a little over two months ago and haven't seen this issue before.  We have been unable to post any AP invoices for going on four days now and Epicor hasn't found a solution yet. Has anyone run across this that could point me towards the root cause?

Here is a sql stored procedure routine that was posted to the group by Vic that I use for finding a value in any table. Maybe if you found the value then it would give you a clue as to how to fix the issue.

 

HTH

 

 

 

USE [EpicorTest905]

GO

 

/****** Object:  StoredProcedure [dbo].[SearchAllTables]    Script Date: 08/08/2016 11:35:45 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE PROC [dbo].[SearchAllTables]

 

(

 

@SearchStr nvarchar(100)

 

)

 

AS

 

BEGIN

 

-- Copyright C 2002 Narayana Vyas Kondreddi. All rights reserved.

 

-- Purpose: To search all columns of all tables for a given search string

 

-- Written by: Narayana Vyas Kondreddi

 

-- Site: http://vyaskn.tripod.com

 

-- Tested on: SQL Server 7.0 and SQL Server 2000

 

-- Date modified: 28th July 2002 22:50 GMT

 

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue

nvarchar(3630))

 

SET NOCOUNT ON

 

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128),

@SearchStr2 nvarchar(110)

 

SET @TableName = ''

 

SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

 

WHILE @TableName IS NOT NULL

 

BEGIN

 

SET @ColumnName = ''

 

SET @TableName =

 

(

 

SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.'

+ QUOTENAME(TABLE_NAME))

 

FROM INFORMATION_SCHEMA.TABLES

 

WHERE TABLE_TYPE

= 'BASE TABLE'

 

AND

QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)

> @TableName

 

AND OBJECTPROPERTY(

 

OBJECT_ID(

 

QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)

 

), 'IsMSShipped'

 

) = 0

 

)

 

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS

NOT NULL)

 

BEGIN

 

SET @ColumnName =

 

(

 

SELECT

MIN(QUOTENAME(COLUMN_NAME))

 

FROM

INFORMATION_SCHEMA.COLUMNS

 

WHERE

TABLE_SCHEMA = PARSENAME(@TableName, 2)

 

AND

TABLE_NAME = PARSENAME(@TableName, 1)

 

AND

DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')

 

AND

QUOTENAME(COLUMN_NAME)

> @ColumnName

 

)

 

IF @ColumnName IS NOT NULL

 

BEGIN

 

INSERT INTO #Results

 

EXEC

 

(

 

'SELECT ''' +

@TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)

 

FROM ' +

@TableName + ' (NOLOCK) ' +

 

' WHERE ' +

@ColumnName + ' LIKE ' + @SearchStr2

 

)

 

END

 

END

 

END

 

SELECT ColumnName, ColumnValue FROM #Results

 

END

GO

 

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 08, 2016 9:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10.1 AP Invoice Issue

 

 

We are on 10.1.400.9 and have an AP invoice batch that is locked up.  We can't even delete an invoice from the batch without getting the following error:  Error accessing the database: Conversion failed when converting the nvarchar value '02-693703' to data type int.  I've looked through the invoices and POs associated with this batch and can't find that value anywhere. We migrated from 9.05.702A a little over two months ago and haven't seen this issue before.  We have been unable to post any AP invoices for going on four days now and Epicor hasn't found a solution yet. Has anyone run across this that could point me towards the root cause?




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-6240 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."

Thanks Greg.  I ran the script and it did not find that value.  Going on a week now without being able to create an invoice tied to a PO.  I ran a trace and this is the last write to the log before the error pops up:


<tracePacket>
  <businessObject>Erp.Proxy.BO.APInvoiceImpl</businessObject>
  <methodName>GetByID</methodName>
  <appServerUri>net.tcp://XXXYYY/ERP101400/</appServerUri>
  <returnType>APInvoiceTableset</returnType>
  <localTime>8/9/2016 12:30:02:0393436 PM</localTime>
  <executionTime>2595</executionTime>
  <parameters>
    <parameter name="vendorNum" type="System.Int32"><![CDATA[96]]></parameter>
    <parameter name="invoiceNum" type="System.String"><![CDATA[10510789]]></parameter>
    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
      <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
        <BpmData>
          <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
        </BpmData>
      </ContextDataSet>
    </parameter>
  </parameters>
</tracePacket>


It appears it is trying to get invoice detail information for invoice 10510789.

A couple of questions just to be clear. You changed the database to your live database, created the stored procedure and then executed it? Did you try it with just the digits after the dash? It usually takes 30 minutes to run on my system, but I have never not gotten any results on data I could see in the app.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, August 09, 2016 5:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10.1 AP Invoice Issue

 

 

Thanks Greg.  I ran the script and it did not find that value.  Going on a week now without being able to create an invoice tied to a PO.  I ran a trace and this is the last write to the log before the error pops up:

 

<tracePacket>
  <businessObject>Erp.Proxy.BO.APInvoiceImpl</businessObject>
  <methodName>GetByID</methodName>
  <appServerUri>net.tcp://XXXYYY/ERP101400/</appServerUri>
  <returnType>APInvoiceTableset</returnType>
  <localTime>8/9/2016 12:30:02:0393436 PM</localTime>
  <executionTime>2595</executionTime>
  <parameters>
    <parameter name="vendorNum" type="System.Int32"><![CDATA[96]]></parameter>
    <parameter name="invoiceNum" type="System.String"><![CDATA[10510789]]></par ameter>
    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
      <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
        <BpmData>
          <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
        </BpmData>
      </ContextDataSet>
    </parameter>
  </parameters>
</tracePacket>

 

It appears it is trying to get invoice detail information for invoice 10510789.




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-6240 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."
I copied the database to a test system so this wouldn't impact production. It took about an hour to run.  I ran it for the whole string.  I am trying it again now with just the digits after the dash.
Have you tried calling support? Do they have any input?
If you run GetByID using the BL Tester do you get the same error?
Can you run the GetByID stored Proc for PO with that number in SQL and see if you see that value?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Aug 9, 2016 at 6:07 PM, bryan.mischler@... [vantage] <vantage@yahoogroups.com> wrote:
Â
<div>
  
  
  <p>I copied the database to a test system so this wouldn&#39;t impact production. It took about an hour to run.  I ran it for the whole string.  I am trying it again now with just the digits after the dash.</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>