Recent content by wysiwygger

Thanks Dagon!!! After changing the second select, your statement runs fine. Excellent! select distinct name, swcode from (select name, swcode, count(case when relkeyword.swcode = 173 then 1 end) over (partition by cscontact.name) as cnt173 from cscontact,relkeyword where cscontact.pubindex =...

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)...

We were using service manager but then changed to PJC. Both do not have project scheduling included, which is a must-have feature for us now. So I'm looking for a different package again....

Thank you!

Hi, Service manager doesn't include any scheduling. I'm actually looking for something that's primarily a project management tool but also does job costing....

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, thanks for your reply! No rounding is set up in IC price lists. It's only this one contract causing problems. All others are fine. There are only 2 stock items used in this contract. I checked both of them and rounding is disabled. If I enable rounding to 0.01 it is still coming up with...

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...

thanks for the clarification!

Hi ettienne, thanks for your reply. Have you got depreciation history for your assets? Are you able to enter an asset with a transaction date from 2008 which, for example, has been purchased in 2006 (acquisition date) and a life of 3 years? I hope you didn't mean I have to run depreciation...

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...

thanks!

Hi, is there a way I can disable the tax tab under asset details or have the figures from the book tab copied automatically? It will always be the same as in the book tab? Cheers!

Hi, thanks for your reply. I sent an email to norming and they said I create 1 asset with 3 separate units. In the end it probably doesn't matter as I still can't see the difference between master - component and units....