I've printed the macro in Accpac, but the code isn't 100% compatible with the Xapi format. Is it possible to load accpac's financial reporter outside of accpac?
Also I've noticed that if I include the reference "Financial Reporter COM Addin" I eliminate some of the errors in the script. But...
I'm writing a program that will create journal entries from a spreadsheet embedded in a VB6 application. Here is the code I've pretty much copied as verbatum as possible from a macro I recorded in Accpac. But it get's hung up when calling up GLbatchDetailFields("ACCTID") = xxxxx. I get a...
We had an issue where someone tried to convert an old DB into an established one. Well it didn't convert of course, but it did reset the fiscal year to 2005. If I run "create new fiscal year" it will give me an error and jump up to 2006. however if I run it again it's a no go. Is there...
I have compiled a program with an embedded spreadsheet in it. However when I try to run the program on anyone elses computer in the office I get the "component msowc.dll or one of its dependencies not correctly registered" error. I ran the command line regsvr32 "C:\Program Files\Microsoft...
This might be an easy one, but I have an embedded excel spreadsheet that I dump data in from a database. I'm wondering how to print that worksheet out without having to export it to the actual excel application. Can anyone help me with this?
Thanks
I am looking into writing some VB programs that will do some routine functions in order to save us some lanpak licenses. We have 5 IAP licenses that are just sitting dormant.
I have no clue how to use XAPI. Can anyone supply me with some sample script of a program that opens a session...
I am wondering how you get parameters for an accpac report (e.g. from acct x to acct y). If I take a form and copy it, change it, and then save it and try to run it from the report section under a different name I get a long list of variables and a window asking for the paramter value. How do...
I have customized a form to print out checks. The problem is that it only works (prints out an actual check) in one database under the admin login other wise I get no information printed into the field boxes. Can anyone help? I'm not sure if it's a crystal reports problem or an accpac issue.
I hope I don't come off as stupid as my last one. I've got a field {BKFROM.CK}, if it equals 32, in crystal reports it prints out as 32. But I need it to be formated that if it equals 32 it prints out as 000032, or if it equals 1006 then it prints out as 001006.
Any help would be very much...
I am not having much luck with figuring out the syntax of crystal reports. I have {BKREG.SISSUED} from accpac ERP, I want to make a forumla that will basically do this. Say {BKREG.SISSUED} = 100.00 well I want to take the decimal out, so it says 10000. I'm used to VB so I'm not sure how to...
I am trying to figure out the VBA script needed to switch from one database to another in Accpac ERP. Right now I am just looking at a basic switch where I will start in company 1 run the macro and end up in company 2.
I have the basic code from the document:
Set Session =...
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.