Skip to main content
Answer

Customer setup as "CU" in BAccount, but there is a record in Vendor table too?

  • February 22, 2023
  • 2 replies
  • 133 views

Joe Schmucker
Captain II
Forum|alt.badge.img+3

EDITED for clarity.  

I’m not having a problem.  Everything is OK!  😀  But perhaps my knowledge of Acumatica is deficient!

I was wondering if anyone could shed light on this.  The sample data shows AACUSTOMER as a customer.  You can see this in the BAccount table as the type is “CU”.  Prior to 2021R2, there was no record in the Vendor table for this account.  Starting in 2021R2, this account is also showing in the Vendor table.

There is a record in the Customer table (obviously)

There is ALSO a record in the Vendor table:

 

Is this an “anomaly” in the sample database, or is there some way in Acumatica that a customer can be added to the Vendor table even though the BAccount Type is “CU” and not “VC”?

You cannot bring up AACUSTOMER in the Vendor screen even though there is a record in the Vendor table.  I’m sure it is because the Type in BAccount is “CU”.

 

Best answer by Vignesh Ponnusamy

@Joe Schmucker 

From my testing, I think it could be bad data. When I create a new BAccount and create a customer for the BAccount the data is not added to the Vendor table. I don't see any reason or logic that might add Customer data to the vendor table. I compared the existing record with the one I created but I don't find a reason why these records where added to the Vendor table.


Please let me know if you have any questions. Thanks.!

2 replies

Vignesh Ponnusamy
Acumatica Moderator
Forum|alt.badge.img+5

@Joe Schmucker 

From my testing, I think it could be bad data. When I create a new BAccount and create a customer for the BAccount the data is not added to the Vendor table. I don't see any reason or logic that might add Customer data to the vendor table. I compared the existing record with the one I created but I don't find a reason why these records where added to the Vendor table.


Please let me know if you have any questions. Thanks.!


Joe Schmucker
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • February 24, 2023

@vigneshponnusamy89  Thank you for your work to help me on this!