AR: How to import debtor/creditor via Excel with 2 different control account numbers: Difference between revisions
Content added Content deleted
(Created page with "'''Question :''' Let’s say I have 2 debtor control accounts 300-0000 and 301-0000. How to import debtors via Excel with 2 different control account numbers? '''Version :'''...") |
No edit summary |
||
Line 17: | Line 17: | ||
[[File:Debtor control3.png]] |
[[File:Debtor control3.png|900px]] |
||
Latest revision as of 12:23, 21 June 2020
Question : Let’s say I have 2 debtor control accounts 300-0000 and 301-0000. How to import debtors via Excel with 2 different control account numbers?
Version : 1.8 / 1.9 / 2.0
Answer :
1) Go to the Import Debtor Excel Template and manually add the column of DebtorControlAcc.
2) Copy the highlighted data in Excel (including the header), go to File > Import from Excel > Import Debtor, click on Paste from Clipboard, then click on Import.
Remark : The system will capture the value of Debtor Control Account from Excel. If there is no such column or value in Excel template, you need to add it in as per step (1).
By : Soh Wee 200615, Lay Swan 200618, P200619
AutoCount Accounting 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|