Forum Discussion
Valsmir
Jul 30, 2023Copper Contributor
Automated Inventory Manager & Charge Sheet
Hi everyone, so I'm looking at working out something where I can use Excel to keep track of inventory, but also charge customers from a simple data entry on a single page. Here is my thinking: Na...
peiyezhu
Jul 30, 2023Bronze Contributor
If your data structure of data entry like below,it will be easier to calculate 。
journal
RefNodateAccountSubAccountdebitcreditMemo
1 | 2022-11-01 | BankDeposit | BankA | 100 |
| sale |
1 | 2022-11-02 | sales | Johe |
| 100 | sale |
2 | 2022-11-03 | SalesFee | Hellen |
| 30 | buy |
2 | 2022-11-04 | BankDeposit | BankA | 30 |
| buy |