Search results for query: *

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

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

Thanks....it was the method, life and depreciation on the tax tab that was missing. I was assuming what is entered on the book tab also goes into the tax tab....

Hi, sorry, forgot to mention - when I'm not using the template I fill in the values for method, life and depreciation manually of course. The message pops up even though the fields are not blank.

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