Share:
Notifications
Clear all

Import Customers into ACS Cloud

5 Posts
2 Users
1 Reactions
73 Views
Maneesh Chauhan
TNC Team Partner
Joined: 6 months ago
Posts: 20
Topic starter  

Hi, I have tried to import the customers and once I click on import data its processed and get failed.

please refer to attach screenshot for process which I am following.

And I also need to import balance for these customers.


   
Quote
Anna Diveeva
AccountingSuite Team Moderator
Joined: 1 year ago
Posts: 6
 

Dear Maneesh,

for the successful import, the required attributes have to be filled. For the Companies list, Payment terms (Terms column) should not be empty.
Please refer to the knowledge base AccountingSuite – Data Import Tool

Opening balance can be imported via Data import tool for a Journal entry. Please use the link above to see a video tutorial for it.
Should you have further questions, we are at your disposal


   
ReplyQuote
Maneesh Chauhan
TNC Team Partner
Joined: 6 months ago
Posts: 20
Topic starter  

Dear Anna,

I have a query, If I Import customer balance through journal then how can I map customer to that particular line amount.

Because there is no column for customer.


   
ReplyQuote
Anna Diveeva
AccountingSuite Team Moderator
Joined: 1 year ago
Posts: 6
 
Dear Maneesh,
 
in the pre-set CoA Companies are an extra dimensions in the Accounts payable / Accounts receivalbe G/L accounts.
e.g. to import the opening balance for account 12000 Accounts receivable we would fill the Extra dimension 1 as a Company.
 
Some companies prefer to create a separate GL Account for each Vendor/Customer (e.g. 12001 Accounts receivable Best Bags LLC). For this option, no extra dimension is needed.
 
Please refer to our video tutorial to learn more https://www.youtube.com/watch?v=Haea_bafKXw
 
Should you have further questions, we are at your disposal
 
 

   
ReplyQuote
Maneesh Chauhan
TNC Team Partner
Joined: 6 months ago
Posts: 20
Topic starter  

Hi, I have filled all the details but unfortunately getting error when I click on Next.

For the error please refer to attached image.


   
ReplyQuote