We are coming off an ECISolutions software and migrating to Acumatica. In the mapping of Customers there is a field called Account Ref which I believe links that customer to a GL Account. My question is what actually goes into that field? In ECISolutions there is a field called debnr that is listing the customer number back to the gbkmut table (main GL table). Would it be better to link the Customer Class back to the GL Account(s) or continue using the cusotmer number? The final say of course would be for the Accounting Manager to make that decision.
Answer
GL Accounts linked to Customers
Best answer by Laura03
Hello
You can find the Customer’s GL numbers on the GL Accounts tab of customer profile. The Account Ref. is a place to store another customer’s account number, perhaps the customer ID from your prior system.
billmarmc
+17HI
Are you referring to this field?
I think so. In the mapping of Customers as a spreadsheet (Customers-Data-Provider) after the Fax and before the Address Line 1 columns there is a column that has Account Ref. I know that each mapping would be specific for our Company. The basic mapping that I have a question about is added in this reply:
| Phone 2 | Fax | Account Ref | Address Line 1 | Address Line 2 | City | Country | State | Postal Code |
As far as I can tell, since we don’t use the Customer Class in the traditional way, the Account Ref would be the customer number linking back to the main GL table in ECISolutions.
billmarmc
+19Hello
You can find the Customer’s GL numbers on the GL Accounts tab of customer profile. The Account Ref. is a place to store another customer’s account number, perhaps the customer ID from your prior system.
+17I think so. In the mapping of Customers as a spreadsheet (Customers-Data-Provider) after the Fax and before the Address Line 1 columns there is a column that has Account Ref. I know that each mapping would be specific for our Company. The basic mapping that I have a question about is added in this reply:
| Phone 2 | Fax | Account Ref | Address Line 1 | Address Line 2 | City | Country | State | Postal Code |
As far as I can tell, since we don’t use the Customer Class in the traditional way, the Account Ref would be the customer number linking back to the main GL table in ECISolutions.
That would be the import scenario. As
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.