A5_Error_Show method not found ???

[MoGrace]

In a script that has been working w/o incident - the following error occurs:

addin.variables().a5_error_show( Script:JE Post line:247
a_pr[qi].ln = inc_lno
Variable type mismatch: Cannot assign data of type 'C' to variable of type 'A'.
a_pr[] not found. ) : Property not found
*INTERMEDIATE_00000084.a5_error_show method not found.

The script has already been processing an array a_pr[] when this occurs and the output to the Trace window shows the values of its subelements
this is the section where the error is triggered - and the format is the same as in the prior sections except for the LABEL:

'CHECK FOR EE_401K percent
tpay.fetch_first()
WHILE .not. tpay.fetch_eof()  
 if tpay.EE_401K > 0 
  x=Z+3   
  tn=tpay.ee_401k_pt
  memostr = tpay.fileno+tpay.filecode+" "+alltrim(a_je[x].memo)
 else
  goto SKIP401
 end if
 qi=qi+1
 inc_lno = increment_value(inc_lno) 
 a_pr[qi].ln = inc_lno
 getfileno = alltrim(tpay.fileno)
 a_pr[qi].nme = ALLTRIM(lookupc("F",getfileno,"QB_NAME","EMPLOYEE","FILENO"))   
 a_pr[qi].coa = a_je[x].coa 
 a_pr[qi].memo = memostr  
 a_pr[qi].type = a_je[x].type
 a_pr[qi].amt = tn
 TRACE.WriteLn("a_je"+x+" a_pr"+qi+" "+memostr+" "+tn) 
 SKIP401:
 tpay.fetch_next()
END WHILE

The SKIP401 label is a new addition but the script has been working fine in the several weeks since I added it. There is only one record that needs this part so the lookupc() is not hindering the script's speed. If there is a typo or format error I am not seeing it. I am also getting a field rule error on the default value in one of the tables which I deleted & compacted (no other field rules) but the error is still showing in the trace when this script is run.

I have incr_lno dimmed as C but when using in increment_value() the error says it I cannot assign a Type 'C' to Type 'A' - even though the rest of the script has done it about 5 times before!

I added Error_Reporting() to the top of the script but it didn't show any other errors. I have my own error handler in the script but this error is not in the format my error script uses - so I am thinking its a system problem?

[Stan Mathews]

Re: A5_Error_Show method not found ???

I have incr_lno dimmed as C

Seed value?

Inrementing a character value can be problematic.
It works as
1,2,3,4,5,6,7,8,9,0,1,..............
01,02..........,99,00............

[MoGrace]

Re: A5_Error_Show method not found ???

The addin.variables() error is gone (maybe...) my problem seems to be using a property array and setting the subelements to the right type when I assign values to them.

Ex:
dim tn as n
dim t1 as p
...
tn = t1.dept_pay 'a numeric amount

'now assign the variable to the property array
a_je[qi].amt = tn 'generates the error that I can't assign a value of N to an A type

From what I gather in the help assigning the value IS what sets the subelement type - is this wrong? Must I dim all the elements first? Because this has been working fine til today.

The incr_lno variable is given a default char value before it is incremented Ex: "B00", "C00", etc. (alpha-numeric) which tested ok in the IW.

I am using some of the same variables over in this script and am checking that I have not accidently assigned the wrong type value to the var, but that does not seem to be the problem - rather it is these property array subelements.

I am making some progess however since now it is not erring until line 254 in my 479 line script!

btw - I thought the purpose of an A type variable was that it COULD take any value assigned to it. Though I realize that must be consistently applied when using the subelement again. Ie, if the first value given it is N then any other assignments must also be N - makes sense to me.

[MoGrace]

Re: A5_Error_Show method not found ???

Here are some screenshots of what this script is doing. JE_LINE is the template table for structuring the a_je[] array with data from the tables in a set which form is open to the current pay period. JE_IMPOUND is the resulting data that the GJ_REP is based on - this is what gets imported into QB as a general journal entry.

[Tim Kiebert]

Re: A5_Error_Show method not found ???

This may not be relevant but ...

a_pr[qi].ln = inc_lno

inc_lno or incr_lno

[MoGrace]

Re: A5_Error_Show method not found ???

That is what I'm still working on - checking for typos. The original script still works in the companion database. There are minor differences in the data, so I figured I'd tweak the one that has less data. Keeping two payrolls in synch for two QB files (different versions) for two companies, is a project I wish I had never started!

[Al Buchholz]

Re: A5_Error_Show method not found ???

Robin

How are you extracting the data from QuickBooks?

[MoGrace]

Re: A5_Error_Show method not found ???

Hi Al,
I am not extracting the data FROM QB, I am importing data from my timeclock to A5, exporting it to my payroll service then back in A5 I summarize the data to create a general journal entry as a csv file that I import INTO Quickbooks. I am using 01Transaction Importer Pro v5 for this from Baystate Consulting.

This way all the payroll detail is in Alpha which is where I can search the data for reporting that otherwise only the payroll service would have.

[MoGrace]

Re: A5_Error_Show method not found ???

Well it took me forever to figure out why this JE_Post script worked in one adb and not the other. It seems that in this file, it is possible for one employee to have deductions for Aflac, Co pay, Loan and 401k in the same week. Therefore the size of my array is not just for 7 employees, but for 7 X 4! The error was consistently occurring when the increment value passed 7. Whereas the other file has more employees and never reached the same limit, else it would have erred too.

I suppose I should try dynamic sizing...