Recent content by wysiwygGER01

Man you are really good! Yes, my shared data folder is a mapped drive. It works for a local drive. I spent hours today trying to find out whats wrong. Is there a way to make it work for the mapped drive as well as I need to have the shared data folder on a mapped drive?

Hi, Sorry to open this thread up again. I've created an executable from the getrates.avb macro and it works well. However it only works if I run it as Administrator and start it manually. When I try to run it as a scheduled task as Adminstrator nothing happens. I tried starting the .exe and...

Thank you! Option 2 worked

Hi, I've done a Misc AP payment in Accpac 5.5. I can see the check number in my bank but it did not create a GL batch. No error batch created either. Where could my payment be?

Awesome! Thank you very much!

Hi, We're using Accpac 5.5 and I'm looking for someone to write me a macro which imports exchange rates into Accpac. The macro would get its rates from XE.com for approx 10 currencies and will run daily. Anyone here can help me with this? Please provide contact details.

Awesome! Thank you so much for pointing me to SQL Expressions! I did not know what they can be used for. I now have the following selections. {?Year} has to be a string value unfortunately. (if {?AllCountries}<>"1" then {%Country} ={?SpecificCountry} else {%Country} <>"") AND {%Year}...

Hi, I'm using CR 10. My report takes very long to run so I set up the below selection statements to speed up the time it takes to produce my report. (if {?AllCountries}<>"1" then {@Country} ={?SpecificCountry} else {@Country} <>"") AND year(pwformatdate({GLPOST.JRNLDATE})) = ToNumber({?Year})...

Thanks again.

Thanks tuba. Wasn't insight discontinued from version 5.6?

Hi, In Accpac 5.5, is it possible to choose a specific date in FR instead of reporting for a whole period?

Thanks ettienne.

Customization directories? I'm looking to to write my own trial balance report. How do customization directories help me with that? Which table(s) should I use for my my trial balance since I can't access the DLL?

Hello, I'm trying to write my first datapipe report by modifying the datapipe report GLTRLR1.RPT. It links to GLTRLA.dll. I modified the report file and copied the datapipe file from the original report into the directory of my report file. I deleted all reference to other DLLs from that file...

Great, thx