Skip to main content
Solved

Numbering Sequence - Extending Business Account to Customer

  • Mar 27, 2023 3:18 PM UTC
  • 4 replies
  • 602 views
  • Translate All

Hi all,

 

Here’s the setup - both “business account ID” and “customer ID” have their own numbering sequences.

 

When I extend business account into a customer, it adopts the numbering sequence of business account, instead of the next customer ID in sequence. 

 

Is there a way to address this? Open to try all suggestions.

 

Thanks

Best answer by aaghaei

Under the hood, the only table keeps the AcctCD is BAccount and it’s derivatives (vendor, customer, …) only keep reference to BAccountID. This means all driven entities have the same account code. For example when you “Extend” a Customer to Vendor or vice versa, they both will have the same Account Code.

View original

4 replies

aaghaei
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Mar 27, 2023 3:25 PM UTC

Business Accounts including (Vendor, Customer, Employee, Company and Branch) all follow the same Segmentation and Numbering. Unless you have implemented a customization, can you please clarify what do you mean by customer numbering is different? Customer is in fact BA.

Translate

  • Author
  • Jr Varsity II
  • Mar 27, 2023 3:32 PM UTC

Business Accounts including (Vendor, Customer, Employee, Company and Branch) all follow the same Segmentation and Numbering. Unless you have implemented a customization, can you please clarify what do you mean by customer numbering is different? Customer is in fact BA.

Thank you for your response. Please see my screenshots here.

 

What exactly happened was. I wanted to extend business account 6xxx to a customer. I wanted it to have 1xxx as its customer ID, but it had 6xxx instead. I could manually change the customer ID, but having it automatically follow the customer ID numbering sequence is more ideal. Just to confirm - a customization is required to achieve this?

 

Translate

aaghaei
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Answer
  • Mar 27, 2023 3:36 PM UTC

Under the hood, the only table keeps the AcctCD is BAccount and it’s derivatives (vendor, customer, …) only keep reference to BAccountID. This means all driven entities have the same account code. For example when you “Extend” a Customer to Vendor or vice versa, they both will have the same Account Code.

Translate

fosterjeff01
Freshman II
Forum|alt.badge.img+1
  • Freshman II
  • Apr 3, 2023 11:28 PM UTC

We also have this issue.  It doesn’t make sense to have a numbering sequence in use in Customers that is ignored when a Business Account is extended as a customer.  When we extend as a customer, we would want it to change the ID to use the Customer numbering sequence.

Translate