A/R Aged Trial Balance Reporting Wrong Amounts

Yahoo Archive
1

Back when we were on 803 we had the same issue.  Partially applied credit memos showing as full value on the aging.  Never got Epicor to admit it's a bug, but they had a "fix".  Unfortunately, the fix, from what I can reference was not tied to an SCR of some sort (or at least not in our notes).

Searching back through our calls I see the messages that they provided a file which we loaded.  (Sorry I'm just an accountant, not a techy)  It was called cvarhdr.r  (Have no idea what the heck this is)  That's the only reference point I have for you.

As a note, the "fix" they provided runs only for a specific document so you have to know or find the specific document that is wrong.

As another note, we are currently on version 9 and we have not had this problem on 9.....yet!

Hope that helps.  Sorry not much else I could provide.

Sincerely,

Chris Berger

2
Good day everyone:
Â
Has anyone had experience with the Aged Trial Balance reporting incorrect totals?
Â
I will give you a scenario:
Â
We received a payment from a customer for $2,000.00. At the time of payment we were unable to apply it to an invoice, so we left it on account. If I run an aged trial balance today, I will see the credit of $2,000.00, plus all the outstanding invoices.
Â
The next day, we are able to partially apply it ($1,500) to an invoice, leaving the credit at $500.00.
Â
However, when we run an aged trial balance now, the invoice is no longer on the report (correct), but the credit note is still showing up as $2,000, not $500 as it's supposed to.
Â
Does anyone know if there is a fix for this?
Â
BTW, we are on Vantage 8.03.408B
Â
Thanks to all for any assistance.
Â
Kerry Travis, CGA
Controller
International Name Plate Supplies Ltd.

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

Yes, there is a fix for this situation. T/S provided a revised ApplyCreditMemo.r file to properly handle the application. Unfortunately, it only solves the issue going forward, so if you have partially applied credits, they will continue to show up incorrectly until they are fully consumed. I had to create a query and pivot table to determine what the "real" balance was for a while.

We are on the same version as you and I ran into it again when I built a new server about 6 months ago.

If you run into any troubles with T/S knowing about this, I can try to locate the original e-mail I received back in 2010.

Best regards,

Bill

William Hannah
Director of Finance & IT
William Frick & Company
Direct: 847.918.7338
www.fricknet.com<http://www.fricknet.com/>

From: Kerry Travis [mailto:kerrytravis@...]
Sent: Thursday, December 13, 2012 10:46 AM
To: Vantage Group
Subject: [Vantage] A/R Aged Trial Balance Reporting Wrong Amounts



Good day everyone:

Has anyone had experience with the Aged Trial Balance reporting incorrect totals?

I will give you a scenario:

We received a payment from a customer for $2,000.00. At the time of payment we were unable to apply it to an invoice, so we left it on account. If I run an aged trial balance today, I will see the credit of $2,000.00, plus all the outstanding invoices.

The next day, we are able to partially apply it ($1,500) to an invoice, leaving the credit at $500.00.

However, when we run an aged trial balance now, the invoice is no longer on the report (correct), but the credit note is still showing up as $2,000, not $500 as it's supposed to.

Does anyone know if there is a fix for this?

BTW, we are on Vantage 8.03.408B

Thanks to all for any assistance.

Kerry Travis, CGA
Controller
International Name Plate Supplies Ltd.

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



[Non-text portions of this message have been removed]
4
ARe you on SQL? If so I have an AR Receivables that I wrote by hand that
I'd be willing to give oyu.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Thu, Dec 13, 2012 at 12:36 PM, William Hannah <
william.hannah@...> wrote:

> **
>
>
> Kerry,
>
> Yes, there is a fix for this situation. T/S provided a revised
> ApplyCreditMemo.r file to properly handle the application. Unfortunately,
> it only solves the issue going forward, so if you have partially applied
> credits, they will continue to show up incorrectly until they are fully
> consumed. I had to create a query and pivot table to determine what the
> "real" balance was for a while.
>
> We are on the same version as you and I ran into it again when I built a
> new server about 6 months ago.
>
> If you run into any troubles with T/S knowing about this, I can try to
> locate the original e-mail I received back in 2010.
>
> Best regards,
>
> Bill
>
> William Hannah
> Director of Finance & IT
> William Frick & Company
> Direct: 847.918.7338
> www.fricknet.com<http://www.fricknet.com/>
>
> From: Kerry Travis [mailto:kerrytravis@...]
> Sent: Thursday, December 13, 2012 10:46 AM
> To: Vantage Group
> Subject: [Vantage] A/R Aged Trial Balance Reporting Wrong Amounts
>
>
> Good day everyone:
>
> Has anyone had experience with the Aged Trial Balance reporting incorrect
> totals?
>
> I will give you a scenario:
>
> We received a payment from a customer for $2,000.00. At the time of
> payment we were unable to apply it to an invoice, so we left it on account.
> If I run an aged trial balance today, I will see the credit of $2,000.00,
> plus all the outstanding invoices.
>
> The next day, we are able to partially apply it ($1,500) to an invoice,
> leaving the credit at $500.00.
>
> However, when we run an aged trial balance now, the invoice is no longer
> on the report (correct), but the credit note is still showing up as $2,000,
> not $500 as it's supposed to.
>
> Does anyone know if there is a fix for this?
>
> BTW, we are on Vantage 8.03.408B
>
> Thanks to all for any assistance.
>
> Kerry Travis, CGA
> Controller
> International Name Plate Supplies Ltd.
>
> [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]
5
I posted this earlier in the EUG site so, sorry for those of you seeing this a second time.


I am trying to improve on the Assign Service Tech functionality in the Service Call Center. I'm at the last step and have run into a block. I'm trying to call the AssignTechnician method of the ServiceCallCenterAdapter and can't figure out how to access the ServiceCallCenterDataSet or otherwise provide an argument that the method will accept.

The trace log isn't much help - it shows this to me:
<tracePacket>
<businessObject>Epicor.Mfg.BO.ServiceCallCenter</businessObject>
<methodName>AssignTechnician</methodName>
<returnType>void</returnType>
<localTime>12/13/2012 15:42:40:1562818 PM</localTime>
<executionTime>47</executionTime>
<parameters>
<parameter name='cc' type='Epicor.Mfg.Core.CallContext.CallContextDataSet' ><CallContextDataSet xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet">
<BpmData>
<RowIdent />
</BpmData>
</CallContextDataSet></parameter>
<parameter name='ipCallNum' type='System.Int32' ><![CDATA[3026]]></parameter>
<parameter name='ipEmpID' type='System.String' ><![CDATA[11111]]></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.ServiceCallCenterDataSet' ><ServiceCallCenterDataSet xmlns="http://www.epicor.com/Mfg/100/BO.ServiceCallCenter/ServiceCallCenter">

First I tried passing null to the method which bombed with an unhandled exception.

Then, I tried creating my own ServiceCallCenterDataSet but, it failed because it is empty and foreign key constraints exist.

Next, I tried pushing the FsTech_Column DataTable into my new DataSet but, that gave me a run-time error that the table already is in use by another dataset.

Any ideas? Thanks!

Epicor.Mfg.BO.ServiceCallCenterDataSet dsFSCallTech = new Epicor.Mfg.BO.ServiceCallCenterDataSet();
dsFSCallTech.Tables.Add(FsTech_Column); adapterServiceCallCenter.AssignTechnician(Convert.ToInt32(edvheadView.dataView[edvheadView.Row]["CallNum"].ToString()), cmbFSTechs.Value.ToString(), dsFSCallTech);

[cid:image001.png@01CDD9E9.469FAF50]





[Non-text portions of this message have been removed]
6
ServiceCallCenterDataSet ds = yourAdapter.ServiceCallCenterData

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Dec 14, 2012 at 11:31 AM, Joe Englert <englertj@...> wrote:

> ServiceCallCenterDataSet


[Non-text portions of this message have been removed]
7
In case anyone is interested, I used .Net reflector to look in the DLL and then did some casting to end up with this that seems to work

adapterServiceCallCenter.AssignTechnician(Convert.ToInt32(edvheadView.dataView[edvheadView.Row]["CallNum"].ToString()), cmbFSTechs.Value.ToString(), ((ServiceCallCenterAdapter)oTrans_adapter).ServiceCallCenterData);

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Englert
Sent: Friday, December 14, 2012 11:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How do I access the DataSet of the form?



I posted this earlier in the EUG site so, sorry for those of you seeing this a second time.

I am trying to improve on the Assign Service Tech functionality in the Service Call Center. I'm at the last step and have run into a block. I'm trying to call the AssignTechnician method of the ServiceCallCenterAdapter and can't figure out how to access the ServiceCallCenterDataSet or otherwise provide an argument that the method will accept.

The trace log isn't much help - it shows this to me:
<tracePacket>
<businessObject>Epicor.Mfg.BO.ServiceCallCenter</businessObject>
<methodName>AssignTechnician</methodName>
<returnType>void</returnType>
<localTime>12/13/2012 15:42:40:1562818 PM</localTime>
<executionTime>47</executionTime>
<parameters>
<parameter name='cc' type='Epicor.Mfg.Core.CallContext.CallContextDataSet' ><CallContextDataSet xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet">
<BpmData>
<RowIdent />
</BpmData>
</CallContextDataSet></parameter>
<parameter name='ipCallNum' type='System.Int32' ><![CDATA[3026]]></parameter>
<parameter name='ipEmpID' type='System.String' ><![CDATA[11111]]></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.ServiceCallCenterDataSet' ><ServiceCallCenterDataSet xmlns="http://www.epicor.com/Mfg/100/BO.ServiceCallCenter/ServiceCallCenter">

First I tried passing null to the method which bombed with an unhandled exception.

Then, I tried creating my own ServiceCallCenterDataSet but, it failed because it is empty and foreign key constraints exist.

Next, I tried pushing the FsTech_Column DataTable into my new DataSet but, that gave me a run-time error that the table already is in use by another dataset.

Any ideas? Thanks!

Epicor.Mfg.BO.ServiceCallCenterDataSet dsFSCallTech = new Epicor.Mfg.BO.ServiceCallCenterDataSet();
dsFSCallTech.Tables.Add(FsTech_Column); adapterServiceCallCenter.AssignTechnician(Convert.ToInt32(edvheadView.dataView[edvheadView.Row]["CallNum"].ToString()), cmbFSTechs.Value.ToString(), dsFSCallTech);

[cid:image001.png@01CDD9E9.469FAF50<mailto:image001.png%4001CDD9E9.469FAF50>]

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



[Non-text portions of this message have been removed]
8
Thanks but, it's actually the native adapter I needed access to. I'm all set though.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Friday, December 14, 2012 11:39 AM
To: Vantage
Subject: Re: [Vantage] How do I access the DataSet of the form?



ServiceCallCenterDataSet ds = yourAdapter.ServiceCallCenterData

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Fri, Dec 14, 2012 at 11:31 AM, Joe Englert <englertj@...<mailto:englertj%40biotek.com>> wrote:

> ServiceCallCenterDataSet

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



[Non-text portions of this message have been removed]
9
You get the native adapter by pulling it out of oTrans.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Dec 14, 2012 at 11:46 AM, Joe Englert <englertj@...> wrote:

> **
>
>
> Thanks but, it's actually the native adapter I needed access to. I'm all
> set though.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, December 14, 2012 11:39 AM
> To: Vantage
> Subject: Re: [Vantage] How do I access the DataSet of the form?
>
> ServiceCallCenterDataSet ds = yourAdapter.ServiceCallCenterData
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...<mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, Dec 14, 2012 at 11:31 AM, Joe Englert <englertj@...<mailto:
> englertj%40biotek.com>> wrote:
>
> > ServiceCallCenterDataSet
>
>
> [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]
10
Right, I ended up with this - ((ServiceCallCenterAdapter)oTrans_adapter).ServiceCallCenterData. Thanks again. Sometimes just talking about the snag gets new thoughts going.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Friday, December 14, 2012 11:51 AM
To: Vantage
Subject: Re: [Vantage] How do I access the DataSet of the form?

You get the native adapter by pulling it out of oTrans.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Dec 14, 2012 at 11:46 AM, Joe Englert <englertj@...> wrote:

> **
>
>
> Thanks but, it's actually the native adapter I needed access to. I'm all
> set though.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, December 14, 2012 11:39 AM
> To: Vantage
> Subject: Re: [Vantage] How do I access the DataSet of the form?
>
> ServiceCallCenterDataSet ds = yourAdapter.ServiceCallCenterData
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...<mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, Dec 14, 2012 at 11:31 AM, Joe Englert <englertj@...<mailto:
> englertj%40biotek.com>> wrote:
>
> > ServiceCallCenterDataSet
>
>
> [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]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
11

Jose,

I would be interested in seeing your script if that is not too much bother.


Kind Regards

Simon Hall

12
Its been a long time.. not sure if I still have it but i'll look


Thanks


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Mon, Feb 10, 2014 at 9:33 PM, <s1mhall@...> wrote:

  
<div>
  
  
  <p></p><p>Jose,</p><p>I would be interested in seeing your script if that is not too much bother. <br></p><p><br></p><p style="font-style:normal;font-size:13px;background-color:transparent;font-family:arial, helvetica, clean, sans-serif;">

Kind Regards

Simon Hall

</div>
 


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

13

Did you run the Advanced Billings/Deposit Balance report?  Is the $500 there?