How to use template to import Fixed Assets into SAP B1

Original we used RedMoon Fixed Asserts to run our Fixed Assets. but on last year, RedMoon wasn't support SAP B1. so we need to use SAP B1 default Fixed Asset add-on.
經過多次實驗,在template excel file我得到以下結論
1. Item Code = Fixed Asset Class (須先在SBO設定).
2. Depr Start Date ($Q2) 須修改成每月的第一天.例如Capitalization Date ($E2) = 2003-01-25 則須改成 2003-02-01 (建議是16號以前為當月1號,15號以後是下個月1號 )
    公式如下:  =If(Day($E2) < 16, $E2 - Day($E2) + 1, Date(Year($E2), Month($E2) + 1, Day(1)))
3. remaining count 計算方式如下: $R2 - Datedif($Q2, "2012-1-1","m"), 2012-1-1的用意是若使用2012 period的話就使用2012-1-1.若是使用2011的話則改成2011-1-1 ($R2 為 useful life)
4. APCHist 是原先購入金額, APC 則是現今的價格.計算方式為 (Apchist/useful )* RemainingLife
5. save as to csv file then open by notepad, delete head and change "," to ";"
6.日期的格式為YYYY-MM-DD
7. import error = 1, 通常是格式錯誤
8. Number imported assets:0, Number of processed assets:2 則是remaining life or depr start date 錯誤