home:knowledge_base:webstation:software:autocount_accounting:autocount-import-by-excel-template
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| home:knowledge_base:webstation:software:autocount_accounting:autocount-import-by-excel-template [2022/08/18 02:43] – 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/ | ||
| Line 11: | Line 13: | ||
| Example: Import from Stock Item | Example: Import from Stock Item | ||
| - | {{: | + | {{: |
| + | |||
| + | <WRAP clear/> | ||
| Example: \\ | Example: \\ | ||
| Line 20: | 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 29: | 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 39: | 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 49: | 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 60: | 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 74: | Line 80: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ Debtor | + | ^ Debtor |
| - | ^ Creditor | + | ^ Creditor |
| - | ^ Member | + | ^ Member |
| </ | </ | ||
| Line 82: | Line 88: | ||
| |< 100% 50% >| | |< 100% 50% >| | ||
| | | | | ||
| - | ^ Branch | + | ^ Branch |
| </ | </ | ||
home/knowledge_base/webstation/software/autocount_accounting/autocount-import-by-excel-template.1660790614.txt.gz · Last modified: 2022/08/18 02:43 by webstation