昨天我回來的路上很不舒服。 不是身體上的， 是心理上的。 我心理上一直想著 E。 但我知道我一定只是用這種想法來做藉口。 我鬱悶到要叫出來。 我跟自己說我得找點是讓自己高興起來。 於是回到家媽媽在網上開會，我就邊晚飯邊看起電影來。 不是很有用， 電影勉強可以。 但是我感覺心理的壓力好大好大， 我還是不得不叫出來。
我很希望可以藉由看甚麼東西把我心裡煩躁的東西掩蓋掉，轉換掉。 稍微有一點效果，但是現在連吃飯都沒有那麼強的安定感了。 I gotta I gotta I gotta find a way to comfort myself. But I am already doing it!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 我已經不間斷的做這事做多久了， 恐怕是持續幾個月了吧。 而且連幫助睡覺的白日夢也不想了。 而且很早就醒，卻是起不來。
我把工作上事情都做完了。 我現在開始看工作。
I am trying to consolidate Receiving Report(Product Sort).
I am using Daily Pick list everyday.
I am using Request list everyday.
I am using Full cat for label sheets everyday.
For Daily Pick list, I need Product-Lot data, and Product-name(Description).
For Request list, I need SKU, Product type, Product OEM status, OEM Supplier info, and Sizes.
For Full Cat label sheet, I need SKU, Host, Clonality, Size.
What need to be keep updated? Product name, Product-Lot data, OEM Status OEM Supplier, and NEW Items, which happened quite often.
公司的基本資料分兩種， 一種是貨物的資料， 另一種是貨物流向的資料。
我所說的資料主要是流向的資料。 從收貨到出貨。 這種資料最好的資料庫是 QB. 當然， 現在還有 Shpfy。 但是公司的 QB 設計是很粗糙的。 所謂粗糙就是， 裡面既沒有 U/M, 甚至沒有 批號。 這個公司總共三個單位， 一個業務， 一個會計， 一個倉庫。 卻有三個貨物流向的資料庫。 我這個資料庫是很鬆散的定義， 因為倉庫所有的其實只是 明細表格而已。 雖說是電子的， 但畢竟不是資料庫。 我現在這樣說是因為容易一點吧。
我始終覺得公司的貨物流向資料是從收貨開始。 因為我們會從工廠得到一個 貨物明細。 上面有 U/M 和批號。 雖說這些不會進入 QB 或者 Shpfy, 但是倉庫是會留下來的。 他們收貨的紀錄是一個 十年以上不間斷的紀錄。
如果公司以後還要把系統升級， 勢必要把這十年由下來的資料作整理。 我最近在做的就是簡單的 把這十年的資料合併在一起。 這裡面有兩個資料我想要用 一個是批號， 另一個是 郵寄追蹤號碼。
我曾經試著追蹤過 批號的路線。 發現收貨的當下， 批號就不見了， 因為不會放在 QB 裡。 只會在倉庫的明細表裡。 批號第二次出現在任何地方， 是在發貨的時候， 撿貨的時候要記錄下貨物的批號時，才再次出現。
我修改了 Request list 和 撿貨明細。 我很希望我可以把這兩個明細表和 合併後的收貨資料連在一起。 撿貨明細需要批號， Request list 需要知道收貨明細進貨了沒， 如果進貨了， Request list 需要可以自動記錄。
我把這寫下來是為了理清自己的想法。
寒蟬淒切。對長亭晚，驟雨初歇。都門帳飲無緒，方留戀處、蘭舟催發。執手相看淚眼，竟無語凝噎。念去去、千里煙波，暮靄沉沉楚天闊。
多情自古傷離別。更那堪、冷落清秋節。今宵酒醒何處，楊柳岸、曉風殘月。此去經年，應是良辰、好景虛設。便縱有、千種風情，更與何人說。
She did most of the work before left for vocation. I thought it's going to be easy. So I told the new lady, we could do some orders first, then she could fill the pick list. Then I can start picking. But when most of the necessary orders are done, it was already 930. I started to pick and finished around 1040. But I dawdled. There were 2 items I cannot find. One of them was because of receiving error, should've been 16, but instead, the record showed 61. The other one just plainly gone. I think it's still receiving error, but this time it's worse kind of culprit, put in the wrong tray and lost forever... I was so mad that I even told the new lady to dive in the trays with me, to search for the lost item. She looked at me with a crazy stare... Looking at a mad man.
I am a bit mad, I feel this time, she's not coming back. not coming back. I keep telling myself. doesn't it happen quite often enough now that it should be numb! Le sigh...
By that time, the labels are already put up. We just need to change the invoices. it's about 1230. The lady asked me if she could go to lunch first. I said sure, I can change the invoices. After lunch break, we could do the packing. I think the real problem is starting time is too late. But why was it this late? I think I have trouble distinguishing the priority of orders or customer questions.
Ideally, the pick should start at 830. Then the lady could start invoicing. If she finished invoicing before I finished picking, then she could start some orders, and then do an add on list, then invoicing the add on list. By the time I picked the add on list, the lady would ideally finishing invoicing, and start to do the box, and or print datasheets. The time should be around 10, which she could start aliquotting, and me printing labels. the ideal finishing time is before 1130. Then 30 minutes around packing.
I think tomorrow, I will start with the most important ones, hoping to finishing them before 845.
I will also tell the lady to start the list, then, invoicing, then some orders if before 915. then another round of invoicing. The other emails will have to wait after the shipping.