You need to weigh the cost versus recovery to determine which method will work best for you. But the detailed method makes it is easier to track expenses and ensure full recovery. The more detailed approach takes more time and therefore costs more in wages. How Expense Recovery entries are made in PCLaw is mostly a matter of style, and how you want the expenses displayed on your income statement. Next week – I am off for the holidays – next posting: January 8th, 2012. If I recognize the problem you are having, I will reply to your email with a possible solution.Īs always, I invite your comments and suggestions for future post topics. Maybe others are having the same issue, so I would be happy to assist. If you know of another type of error that you would like to see added to the discussion, please email me. There are others, but these are the most common errors. Accounts Receivable errors (method/multiple invoices/matters).Trust errors (multiple matters/trust accounts).Starting in January, I will discuss each of errors in more depth. I think the best way to start this next series of postings is to list the types of errors commonly found in PCLaw. I have some clients that do all of their own bookkeeping, and retain my services just to correct errors and monitor for LSUC compliance issues. I provide legal bookkeeping services to clients on a monthly basis, however, the vast majority of my income comes from error correction services. Just locate the error, and remove it, or do a reversing entry.Īs always, I invite your comments and suggestions for future post topics. using Expense Recovery to post hard cost instead of using a bank account (however, Expense Recovery can be used to recover for an old bank entry where the matter was omitted) using Receive Payment to receive more funds than the amount owing - creates a general retainer – instead, deposit into trust and then immediately pay the receivable using a G/L adjustment to post to a control account (General banks and HST can be posted to, as long as you check the “appear on journal” box) I have seen a general cheque where the explanation was something like postage, and the G/L account used was 1000 (I guess the thought was to deduct the postage from the bank) Using a firm receipt to post to Accounts Receivable (1200) ![]() The posting errors I am writing about are using the wrong method in PCLaw to post your entry. SET word=dbo.Simple posting errors are not accounting errors (posting to the wrong account), which would be incorrect no matter what program you are using. IF 0)- any error occur return the sEND = IF no error found return the new string make the letter = + = +1-incerase the index WHILE the letter = + = +1-increase the index string need to VARCHAR(200)-increase the variable size depending on your needs.ĭECLARE VARCHAR(200)-result string size should equal to the variable size If you just wanted to change it only for displaying and do not need the actual data in table to change: SELECT UPPER(LEFT(word,1))+LOWER(SUBSTRING(word,2,LEN(word))) FROM ĮDIT: I realised about the '-' so here is my attempt to solve this problem in a function. SET word=UPPER(LEFT(word,1))+LOWER(SUBSTRING(word,2,LEN(word))) Are you asking for renaming column itself or capitalise the data inside column? If its data you've to change, then use this: UPDATE
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |