home:knowledge_base:webstation:software:autocount_accounting:autocount-import-by-excel-template
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| home:knowledge_base:webstation:software:autocount_accounting:autocount-import-by-excel-template [2022/08/18 02:38] – created webstation | home:knowledge_base:webstation:software:autocount_accounting:autocount-import-by-excel-template [2022/08/18 04:04] (current) – webstation | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | **<WRAP centeralign>< | + | **<WRAP centeralign>< |
| - | \\ | + | |
| + | ---- | ||
| This to import data from excel template into AutoCount. Those data that can be import through excel are: Stock Item, Stock Item Price Book, Cash Book Entry, Journal Entry, AR/AP invoice, AR/AP Debit Note, AR/AP Credit Note, AR/AP Payment, Debtor/ | This to import data from excel template into AutoCount. Those data that can be import through excel are: Stock Item, Stock Item Price Book, Cash Book Entry, Journal Entry, AR/AP invoice, AR/AP Debit Note, AR/AP Credit Note, AR/AP Payment, Debtor/ | ||
| **<WRAP centeralign>< | **<WRAP centeralign>< | ||
| - | {{: | + | {{: |
| - | Example: Import from Stock Item \\ | + | <WRAP clear/> |
| - | {{: | + | Example: Import from Stock Item |
| + | |||
| + | {{: | ||
| + | |||
| + | <WRAP clear/> | ||
| Example: \\ | Example: \\ | ||
| Line 18: | Line 24: | ||
| The yellow colour part shows the details that need to be copy (including the header part) to paste from the clipboard. | The yellow colour part shows the details that need to be copy (including the header part) to paste from the clipboard. | ||
| - | | + | |
| + | <WRAP clear/> | ||
| ---- | ---- | ||
| Line 27: | Line 35: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | @# | | @# | ||
| - | ^ A/P Credit Note | **[[{{: | + | ^ A/P Credit Note | **[[{{: |
| - | ^ A/P Debit Note | **[[{{: | + | ^ A/P Debit Note | **[[{{: |
| - | ^ A/P Invoice | + | ^ A/P Invoice |
| - | ^ A/P Payment | + | ^ A/P Payment |
| </ | </ | ||
| Line 37: | Line 45: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ A/R Credit Note | **[[{{: | + | ^ A/R Credit Note | **[[{{: |
| - | ^ A/R Debit Note | **[[{{: | + | ^ A/R Debit Note | **[[{{: |
| - | ^ A/R Invoice | + | ^ A/R Invoice |
| - | ^ A/R Payment | + | ^ A/R Payment |
| </ | </ | ||
| Line 47: | Line 55: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ Stock Item | **[[{{: | + | ^ Stock Item | **[[{{: |
| - | ^ Price Book | **[[{{: | + | ^ Price Book | **[[{{: |
| - | ^ Price Book Rule | **[[{{: | + | ^ Price Book Rule | **[[{{: |
| - | ^ Item Price by Location | + | ^ Item Price by Location |
| - | ^ Stock Open Balance | + | ^ Stock Open Balance |
| </ | </ | ||
| Line 58: | Line 66: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ CashBook | + | ^ CashBook |
| - | ^ Journal Entry | **[[{{: | + | ^ Journal Entry | **[[{{: |
| - | ^ Budget | + | ^ Budget |
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ Last Year Price History | + | ^ Last Year Price History |
| </ | </ | ||
| Line 72: | Line 80: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ Debtor | + | ^ Debtor |
| - | ^ Creditor | + | ^ Creditor |
| - | ^ Member | + | ^ Member |
| </ | </ | ||
| Line 80: | Line 88: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ Branch | + | ^ Branch |
| </ | </ | ||
home/knowledge_base/webstation/software/autocount_accounting/autocount-import-by-excel-template.1660790297.txt.gz · Last modified: 2022/08/18 02:38 by webstation