Yup.
I have been recording the stuff occuring from the 'print/post' button.
At that point, there is a field 'Next Check Num' and it does assign check numbers to the payments.. but none of that magic seems to show up in the recorded macro's at all.
But yup, the plan is for the program to try...
The error batch is to the effect of 'duplicate check number 000000000' for each check in the batch.
The payments in these batches have SWPRNTRMIT set to TRUE. When I record the macro's, it seems like they are merely calling the crystal report. I'm not sure how things tie together with respect...
actually, I should note, the status of the batch does end up being 'Posted', but the error batch is still generated and things don't seem to show up in the GL.
Thanks,
I had been trying that for posting as well. That technique doesn't work for some reason either.
An 'Error Batch' is created (identical to the batch I attempt to post).
the only errors in the session view are;
hSession.Errors: Posting Complete. Error Batch Created.
hSession.Errors...
I'm trying to 'print/post' payment batches in AP from an external program. I'm at my wits end.. using the macro recorder, it seems fairly clear, but I've had no luck mimicing the macro.
Here's a snippet of my code;
-------
Dim BKPROC As xapiView
Set BKPROC =...
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, ,acMenuVer70
SendKeys "%ha%n", False
That's what I do. Literally sending keystrokes to change it. Use it in all of my apps.. you might think it would be unreliable, but it isn't - works great!
For a detailed explanation, search MS...
have a look at an ascii table. If it is only upper case and lower case characters you want to keep, you could try the following treatment on your string;
For i = 1 to 31
strString = Replace(strString, Chr(i), "")
Next i
For i = 33 to 64
strString = Replace(strString, Chr(i)...
Shell "explorer /e,/root, c:\map"
I think that's what you're looking for. I think the switches determine if a treeview is shown or not and something else.. I can't remember, but I pulled this from an app. I once wrote. Should give you a place to start from.
Just wanted to chime in and agree with BSitko. We're also using the Merant ODBC driver.
We have no complaints about the performance of our crystal reports.
Dim myInteger as Integer
msgbox Nz(MyInteger)
msgbox Nz(MyInteger,0)
Nz takes 2 arguments, the second being optional. The first is your variable/expression.
Nz returns the input var/expression if it is not null, and retuns 0 otherwise (or the value specified in the second argument)...
woa. I thre a "hheader.update" in front of the insert and it seems to be working now.
proof-of-concept done. now on to the real work - I'm sure I'll be back with more questions (or even answers).
By browsing these forums and playing with the Macro recording in Accpac, I think I've come pretty close, but I get the following error;
"View: AP0021. View call failed"
The error is thrown on the line "hHeader.Insert". My current code is as follows (tried a lot of different...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.