Search results for query: *

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

Hi, I'm using the Create PO from OE tool in Accpac 5.6. It seems like I cannot create a second PO of the same Order. Which field in what table defines whether I can create a PO or not?

Thanks for your quick reply! I'm copying OE orders into PO so I gues it would be redundant to check whether the item number exists. So you're saying I have to write it in my code. Need to find the item number in IC0340, then need to find the vendor and then need to get the vendor item number...

Hello, I'm using Accpac 5.5. I've got the below code for entering a PO. When I enter a PO manually Accpac automatically fills in vendor details such as vendor item number if the item has been set up for the vendor. With my code this does not work. I would have thought by using the COMAPI it's...

Hi tuba, I don't think 2 price lists will work. The country raises a PO for the purchasing entity which includes the mark-up. So the country has a liability towards the purchasing entity. Then the purchasing entity raises a PO for the actual vendor excluding any mark-ups. The purchasing...

Thanks for your reply tuba. The PO only exists one times. How can the same PO have 2 different price lists? The country raises PO and sends it to the purchasing entity. From there it's send to the supplier, but without the mark-up. It should only be one PO for the whole transaction.