Stock Ledger Report
Generating worksheet (tab) names
Worksheet names are generated with the following format:
{sku} {product title}
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
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
A 年月日 (Date)
B -> F 受入れ (Incoming)
In Yellow
B 詰口 (Incoming Quantity)
C 未納税移入 (Non-excise Incoming)
D 戻入れ (Return)
E 戻入れの理由 (Return Reason)
F 移入 (TODO)
G -> M 払出し (Outgoing)
In Blue
G 課税移出 (Tax Transfer Quantity)
H (区分) (Customer Type)
eg.,
- 小売
- 卸
- 一般
I (店名) (Customer Name)
eg.,
- B2B
- B2C
- name
J オーダー番号 (Order name)
K 未納税移出 (Non-excise outgoing)
L 輸出 (Export)
M 詰替え (Repackaging)
N 腐敗・廃棄 (Discarded)
O 現在 (Remaining Total)
Incoming Items
Includes:
- Incoming
- Return
Incoming
A 年月日 (Date)
B 詰口 (Incoming Quantity)
O 現在 (Remaining Total)
Return
A 年月日 (Date)
D 戻入れ (Return quantity)
E 戻入れの理由 (Return Reason)
O 現在 (Remaining Total)
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 |