- 註冊時間
- 2002-4-10
- 線上時間
- 55 小時
- 閱讀權限
- 100
- 積分
- 364
- 主題
- 28
- 精華
- 0
- 文章
- 427
該用戶從未簽到 - 文章
- 427
|
Re: [交流] Palm史上最強的記帳軟件 Adarian Money
GAAP
^^^^^^不會吧,他有這個功能呀,作者自己不知道???呵....
說真的,我玩這套軟體,一張說明書也看...就給它一直按按,也許小弟用過上百種會計軟體,所以大概知道他能搞出什麼名堂
只有少數幾個功能試不出來,就是警示及超支的alert,不過有看它的Palm的線上說明,大概有點知道了(Palm線上說明真的做的很讚)
最近讓我玩到一個超神奇的功能,有時間我再研究它的一百六十頁的說明書,如果有說的話....呵..那就是技了!!
我把我問的過程貼出來吧！其實程式者是有瞭解到，後來又被我另一個問題搞混了。不過有件蠻有趣的，他們都沒有用過PMT。
01我的問題：
「I am testing to use this software and feel it is a very good application.
Someone asked AM can do purge function in PalmIsLife web? How can i answer him?
Because I'm not sure what the purge function for. 」（英文不好不要笑啊！）
02第一次回答：
「What is purge function? I don't know what it means either.」
03所以我再問了：
「You understand what is equity?
So many Palm user used PMT x1 for their Finance Manager. When you first open PMT, you needed to divide your account to Asset, Liability, Income and Expense. At the time of clearing, PMT will create a equity.
I think they will compare PMT with AM, hoped to choose a best. So many user in Taiwan like PMT, but they wanted to change when AM apperance.
Some user in mainland China said that "How great is Palm because PMT.".
But PMT haven't any inprove in these two years. So many of them wanted to find a new one. I don't know how good AM is. I try my best to answer some question. AM have any document for some user that they haven't any accounting or personal accounting idea? Maybe they needed some example.」
04他居然這樣回答了：
「Oh, that's what you meant. I was thinking maybe you're talking about "delete" or something like that.
I just downloaded PMT and gave it a look. No, AM has no direct support for the "Purge Transactions" function as in PMT. And because its trial version doesn't let me use this function, so I can't get to see what it really works like. But according to the information I find in the user's manual, I'm under the impression that AM users can get the same results, but will have to go through several steps. (Grafield, if you saw this, I remember you were a PMT user, right? Do you have any comments?)
Sorry, can't be of much help here.」
06最後他說的Garfield就回答：
「I'm afraid I wasn't a PMT user. However, I've taken a quick look at PMT and I believe what the purge function does is, like, end the year at a specified date.
In other words, as my database gets bigger, I may want to delete all transactions prior to, say, January 1st 2004. What I would expect this purge command to do (and I had this function on my previous accounts package) is calculate all balances at the specific date, update every account's opening balance with the actual balance at that date, and then delete all transactions prior to that date so that the deletion would have no impact on current balances, etc.
AM already includes a 'Delete...' function which goes some way towards this. However, it doesn't take certain things into account.
If I carried out what I believe to be a Purge command manually, these are the steps I believe would be needed:
1. For each account, note down the balance at the specified date and update the opening balance with that figure.
2. Delete all RECONCILED ONLY transactions prior to that date. You can't delete transactions that are not reconciled as otherwise you'll have problems when your next statement arrives. You also can't delete any unrealised transactions as they may still become realised at some point in the future. I'm also assuming that any Cleared transactions are being reconciled but still haven't been finalised so they can't be deleted either.
3. For each account, calculate the total of the posted and cleared transactions remaining prior to the specified date that you couldn't delete in step 2 above and adjust the opening balance again accordingly.
4. [Optional] Delete all Payees who no longer have any transactions allocated to them (zero balances).
I wouldn't have thought it would be too difficult to automate this, and thinking about it, it will become necessary to reduce the size of databases once they get too big.
Right now what I would have to do is:
1. Choose a date where all previous transactions are either Reconciled or Unrealised (I'd use a filter in the Transaction Log view to do this).
2. Change the date of all those Unrealised transactions to any date after the specified date.
3. Use the 'Delete...' function to delete all transactions prior to the date with the 'Adjust Opening Balances' option ticked.
4. Go through the Payees List and delete any with zero balances that I don't believe I'll ever use again.
And that's it really. The only restriction now (which I don't believe is really a restriction) is that the date can't be too recent. It would be a nightmare if you choose a date where there are still Unreconciled transactions unless it was automated.
I hope I have interpreted 'Purge' correctly and, if so, I hope this has helped.
One more thing to add which my previous accounts package allowed to happen, and this was for each category to have an opening balance.
Two reasons for this. The first is in case the user wants to keep the absolute total per category up to date, even though the previous transactions have been deleted. In this case each category's balance at the specified date would have to be calculated and stored as an opening balance of sorts.
The second reason is because, if you choose a date where there are still unreconciled amounts that can't be deleted, those transactions will affect the category total when you may actually want to start afresh from zero from the specified date. This being the case the opening balance must hold a negative value to cancel out these transactions' totals. Alternatively, these unreconciled transactions could have their category changed to 'Unassigned' which would prevent them affecting the category balances.
Hope this makes sense.」
看起來，他的部驟還是蠻複雜的。或許GAAP兄做的更簡單也說不定。 |
|
狗仔卡
發表於 2005-11-11 10:41
顯身卡
, 會很心疼)
