Stock Ledger Report
Generating worksheet (tab) names
Section titled “Generating worksheet (tab) names”Worksheet names are generated with the following format:
{sku} {product title}
Constrants
Section titled “Constrants”Any invalid characters will be substituted with -
The worksheet name will be truncated to 31 characters
If the worksheet name has been used, it will be appended with (n) suffix
Example
Section titled “Example”Example worksheet title that breaks all the rules
- sku:
IPAG?-C301 - product title:
Double Indian Pale Ale of the Gods?
Worksheet name:
- from:
IPAG?-C301 Double Indian Pale Ale of the Gods? - to:
IPAG--C301 Double Indian Pale A
If this worksheet name is already taken (which should not be possible): - to:
IPAG--C301 Double Indian Pal(1)
Columns
Section titled “Columns”A 年月日 (Date)
Section titled “A 年月日 (Date)”B -> F 受入れ (Incoming)
Section titled “B -> F 受入れ (Incoming)”In Yellow
B 詰口 (Incoming Quantity)
Section titled “B 詰口 (Incoming Quantity)”C 未納税移入 (Non-excise Incoming)
Section titled “C 未納税移入 (Non-excise Incoming)”D 戻入れ (Return)
Section titled “D 戻入れ (Return)”E 戻入れの理由 (Return Reason)
Section titled “E 戻入れの理由 (Return Reason)”F 移入 (TODO)
Section titled “F 移入 (TODO)”G -> M 払出し (Outgoing)
Section titled “G -> M 払出し (Outgoing)”In Blue
G 課税移出 (Tax Transfer Quantity)
Section titled “G 課税移出 (Tax Transfer Quantity)”H (区分) (Customer Type)
Section titled “H (区分) (Customer Type)”eg.,
- 小売
- 卸
- 一般
I (店名) (Customer Name)
Section titled “I (店名) (Customer Name)”eg.,
- B2B
- B2C
- name
J オーダー番号 (Order name)
Section titled “J オーダー番号 (Order name)”K 未納税移出 (Non-excise outgoing)
Section titled “K 未納税移出 (Non-excise outgoing)”L 輸出 (Export)
Section titled “L 輸出 (Export)”M 詰替え (Repackaging)
Section titled “M 詰替え (Repackaging)”N 腐敗・廃棄 (Discarded)
Section titled “N 腐敗・廃棄 (Discarded)”O 現在 (Remaining Total)
Section titled “O 現在 (Remaining Total)”Incoming Items
Section titled “Incoming Items”Includes:
- Incoming
- Return
Incoming
Section titled “Incoming”A 年月日 (Date)
Section titled “A 年月日 (Date)”B 詰口 (Incoming Quantity)
Section titled “B 詰口 (Incoming Quantity)”O 現在 (Remaining Total)
Section titled “O 現在 (Remaining Total)”Return
Section titled “Return”A 年月日 (Date)
Section titled “A 年月日 (Date)”D 戻入れ (Return quantity)
Section titled “D 戻入れ (Return quantity)”E 戻入れの理由 (Return Reason)
Section titled “E 戻入れの理由 (Return Reason)”O 現在 (Remaining Total)
Section titled “O 現在 (Remaining Total)”Outgoing Items
Section titled “Outgoing Items”Includes:
- Discarded Stock
- Fulfilled
- Report as sold
| G (Tax Transfer Qty) | H (Customer Type) | I (Customer Name) | J (Order Name) | N (Discarded) | R (Event Type) | |
|---|---|---|---|---|---|---|
| Discarded | ||||||
| Fulfilled | ||||||
| Report as sold |