Recent content by ramam1

Each has their own install - maintenance nightmare no? In any case if it's just one WS I would try having that user login from a different WS to see if it's her account or her machine.

I use MS SQL Server for tons of reports. You can intelligently tune the SQL rather than trying to coerce Crystal into doing things efficiently. I can't tell you how many multi hour reports we rewrote into sub one-second reports.

Database update?

I don't have the vendor number - DIC doesn't list it but I see now that it does list the batch type (PY) number and entry number so that's the easiest way to do it. Odd that there is no way to look it up via Doc # - we have 200k AP docs and if we don't have the other info handy there is no good...

I can't seem to find a good way to look up an AP document. We have an AP Invoice that shows up in the DIC but I don't know a good way to look it up via Accpac. I see two options: 1 AP Transactions -> GL Transactions -> Print *all* AP documents and then search through for the document number...

You could check the customer's credit limit and open balance.

How many Accpac users do you have and how many Accpac access licenses do you have?

Your IT guy can do some basic tests like ping/telnet from/to the various hosts involved; given that log*out* is slow I don't believe this will be fruitful; this type of issue usually shows up at initial connection time (to the TS, to the DB, etc).

Time it. If it is consistently just a smidge over 30s then it's likely a TCP timeout and that's often a DNS issue.

How many concurrent users. What's the actual bandwidth of the link between the remote and server sites?

I've been using it for six years without issue. It sucks up a tiny bit of CPU and a good amount of storage. As we do a lot of customization and macro development in house it is nice to be able to do analyses of previous behavior as well as do point in time recovery if something goes badly (ie...

While not without operational consequences, you can use the MSSQL Full Backup model to enable point in time recovery; a secondary benefit of this is that you can view the values of the Accpac Audit columns before / after any change you like. At my company we keep a few months worth of...

Super. thanks again.

Thanks Tuba. So I don't have to worry about it recalculating from scratch?

I'm looking to track the high-water-mark [in AR] for individual customers; this is already done natively by accpac with the AMBTBALHIT field. There are certain occasions when it would be convenient to force this number lower [possibly to zero] so that the previous high water mark is cleared and...