Search results for query: *

Hi, I've got the following SQL statement and it is working almost fine. select distinct cscontact.name, relkeyword.swcode from cscontact,relkeyword where cscontact.pubindex = relkeyword.relpubindex(+) AND (relkeyword.swcode <> 173 OR relkeyword.swcode IS NULL) order by cscontact.name The...

hi, could anybody please help me out with creating a new depreciation method? The method I need should depreciate an asset 18.75% in the first year and 37.7 percent for the rest until it reaches it's end of life. So far I got this but am not sure thats correct: IF BAG=0 THEN (BNV/BEY/12)...

Hi, Can anyone recommend a good project based time and billing third party program that will integrate with Accpac ERP. I'm not looking for PJC. I need something that can manage a project in all aspects, time, billing, scheduling, access for remote users... I've heard of Tenrox but haven't...

Hi, We are using PJC 5.4 SP2. I'm trying to create a recognition worksheet for a contract which fails with the following error: AMTSR is -0.005 but should be rounded to -0.010. AMTSR appears to be a field in table PMRWDD - RR Worksheet Accounts, but I can't see why this rounding issue is...

Hi, I'm running Norming Asset Management 5.4 SP4 with Accpac 5.4. I've been trying to create an existing asset according to the help file but it wouldn't let me do it. The point is that I'd like to have the depreciation history for the asset as well. According to the help file this should be...

Hi, I'm running Norming Asset Management 5.4 SP4 with Accpac 5.4. Assuming I have 1 table and 2 chairs which belong together but each one of them got a separate barcode with the serial number. What is the best way to capture this information in Asset Manager? I can either create 3 different...

Hi, I'm running Norming Asset Management 5.4 SP4. I've recently upgraded from SP1 to SP4. Apparently since SP2 there is field PO Number on the Acquisition Entry screen with any acquisition type. Does anybody know where this PO number shows up again in the system? I've selected GL acquisition...

Hi, I'm currently evaluating Norming Asset Management 5.4 with Accpac 5.4. The setup checklist for Norming mentions Templates are optional. However when trying to actually enter an asset into the system a dialog window pops up: Method cannot be blank, depreciation period cannot be blank, life...

Hi, I'm running a Windows Server 2003 Standard in an active directory domain. If I ping computer1 I receive 192.168.1.10. Nslookup for computer1 shows me: 192.168.1.10. Now I do a nslookup for 192.168.1.10 and receive computer2 with 192.168.1.10. DNS Forward Lookup zone shows computer1 -...

Hi, I'm trying to get a number formated like xxx.xx with only 2 digits as cents. I tried ToNumber but still got the same result: xxx.xxxxx if {OEORDD.LINETYPE}=1 THEN ToText({OEORDD.UNITPRICE},{OEORDD.UNITPRCDEC}) else "" Any help appreciated.

Hi, I'm running SQL Server 2005 on Windows Server 2003. Accpac is running on version 5.4 with the latest service packs. PJC is running on 5.4 SP1. I set up Timecard users with Windows authentication. When they logon to Timecards the field employee number is already pre-filled with the Employee...

Hi, I'm running SQL Server 2005 on Windows Server 2003. Accpac is running on version 5.4 with the latest service packs. I don't usually run Accpac on the server, I just connect to it from the workstation. However today I tried to run it on the server and received the following error when...

Hi, anyone done this yet and now wish he hadn't? While the upgrade itself went fine, Accpac changed the way Revenue Recognition is done. Apparently they didn't even think it's necessary to write some notes about this in their documentation so you would be able to pick up on this before the...

Hi, I have recently upgraded to Accpac 5.4 which is running on a Win2003 Server and SQL 2005. I have had problems with connecting to the database in 5.3 as well but now it really annoys me. I can log on to Accpac just fine. Then I open the GL batch list and it opens fine. I close it..wait few...

Hi, I just did an upgrade from Accpac 5.3B to 5.4 and noticed it kept all or almost all files and folders from the previous version 5.3. Even the entries under Add and remove Programs are still there? Is it save to uninstall the 5.3 modules? I thought the Accpac installer runs an uninstaller...

Hi, I've come across a strange problem. When I run a dayend from an Accpac workstation machine (workstation setup) nothing gets processed and no error are shown. If I run the same dayend from a workstation that has a full Accpac installation (same as the server) everything runs through just...

Hi, I'm having some trouble with my SQL statement. What I'm doing is: Retrieving the invoice details from my SQL Server 2005. In the example below it's looking for the job number "P-05-012-01" and some exchange rates out of a range of dates. With the case statement I calculate my average...

Hi, I'm trying to get a date value increased by 1 day. The difficult part is the date is stored as a decimal datatype, e.g. 20070228. If I increase it by 1 using: SELECT MyDate + 1 would only give me 20070229 and not 20070301. I have no influence on chaging the datatype. Also if I try to...

Hi, is there a way I can get more then just 1 Billing Rate under PJC setup -> employees. How can I tell PJC to use another Billing Rate for e.g. public holidays... Cheers

Hi, I'm running Exchange 2003. One user, running OL2003 is having a weired problem. Whenever I or anyone else sends him a meeting request and he accepts it its entered as an recurring event in his calendar. If he opens the meeting request everything seems to be fine but if he clicks accept and...