买到中华书局1985年版《庄子》新书

今天出去本想去国家博物馆逛一逛,哪知那里仍然关闭,要等2010年8月份才能开放,去年十月国庆期间只是临时部分开放。那就顺便去看看毛主席他老人家吧,没想到毛主席纪念堂只在上午开放。唉,回家!

在回来的路上进了想念已久的中华书局,非常难得,非常之没想到的是架子上竟然有一本1985年版,1985年印刷的新书《庄子》,毅然以0.16元的“巨款”买下了这本心仪的计算机排版印刷时代来临之前一本小册子。

Recovery Rate on PO Distribution line

The recovery rate usually works together with tax code in shipment line. The recovery rate is the percentage of the tax amount which can be charge to customer, e.g. VAT. Generally this part of tax amount will not go into cost account. For exmple, if you select tax code as 17% but don’t fill in the recovery rate, the PO line price is 100, the item cost will be 117; while if you select tax code as 17% but fill in the recovery rate as 100, the item cost will be 100.

Apply Multiple Deposit to an AR Invoice

Sometimes, we have received an deposit and get the payment from customer for this deposit. Then we received another deposit from the same customer for the same transaction(contract). When we finished business, we create an AR invoice to customer. We have two deposits for this invoice. How to apply these two deposit for this one invoice?

From Oracle standard functionality we can only apply one deposit to one invoice. We can’t apply multiple deposit to the AR invoice. The workaround to handle this case is unapply the payments from the original deposits, credit the original deposits, and then make a new deposit, apply the multiple payments to the new deposit, and then apply the new deposit to the AR invoice.

Is there any other better solutions? Waiting for Oracle……

Search All of The Profile Option Setup on Different Level

Sometimes you need to know who (users or reponsibilities) have the overided profile option for having speicific authority. We can’t get it from front-end but can get it from below SQL script.

SELECT a.profile_option_id,
b.profile_option_name,
b.user_profile_option_name,
DECODE(c.level_id,10001,’Site’,10003,’Responsibility’,10004,’User’,10002, ‘Application’,’Other’) AS “PROFILE_LEVEL”,
DECODE(c.level_id,10001,’Site’,10003,(SELECT r.responsibility_name FROM fnd_responsibility_tl r WHERE r.responsibility_id=c.level_value AND r.language=’US’),10004,(SELECT u.user_name FROM fnd_user u WHERE u.user_id=c.level_value),1002,(SELECT d.application_name FROM fnd_application_tl d WHERE d.application_id=c.level_value),’Others’) as “LEVEL_VALUE”, c.profile_option_value
FROM fnd_profile_options a,
fnd_profile_options_tl b,
fnd_profile_option_values c
WHERE a.profile_option_id=c.profile_option_id
AND a.profile_option_name=b.profile_option_name
AND b.language =’US’
AND b.user_profile_option_name LIKE ‘&Profile’;

Refund to Customer

1. Create RMA in orde management and attach it with original SO

2. Auto create Credit Memo in AR

3. Create Debit Memo in AR to settle the credit memo

4. Create AP invoice in AP with the distribution account as the same as the ones in AR debit memo

5. Pay the AP invoice (Refund money to customer).

Note:
Before 2, you may need to unapply the original receipt with original SO firstly so that the credit memo can be auto created. Then you can resume the original circumustance.
Before 4, you may need to create the supplier and supplier site for your customer.

记2010年春节

腊月二十九办公室已经没什么人了,我和小凤在捷成坚持到五点多乘火车回津,到家的时候已是晚上八点左右,楼道里家家户户已经都贴上了窗花,吊钱,对联,福字,肥猪拱门等等。

三十早起后,理发沐浴更衣,下午出去闲逛,回来后一家团坐包饺子。年夜饭大约六点多开始,开始前放了一卦鞭炮。晚上一起看春节联欢晚会。十二点放鞭炮,放烟花,很是热闹。大约在十二点半结束,回家开始电话拜年。大约一点有余,睡觉。

初一早,吃素饺子,放炮,给小凤爸打电话拜年。早上,到大爷家拜年,谈及婚事。下午到大舅家拜年,在大舅家吃晚饭。

初二早,小枣及小刚来拜年,然后一同去老姨家拜年,后又去二舅家拜年。后逛伊势丹,因头疼,早回。

初三早,小月及大唯来拜年,下午大舅家全家来拜年,晚饭在我家一起吃。另大姐来家拜年,并赠送小凤心仪已久的LV提包。

初四,高中同学聚会,然后给小凤买了些衣服。二舅一家来拜年。

初五早,看新房,设计讨论装修事宜,下午到大姐家拜年。

初六早,乘回车回京。