25
R

Table Relation. Customer Invoice discount code

Ramon Diaz Blanco on 5/10/2019 9:05:31 AM
For years the table relation from field 33 (Invoice disc. code) in table 18 customer is stablished to table 18 customer.
For years we had changed this, stablishing the table relation to table 19 Cust. Invoice Disc.
I think this is the correct table relation from this field.
Category: Development
STATUS DETAILS
Declined
Ideas Administrator

Business Central Team (administrator)

Thank you for your feedback. We are not considering the suggestion at this time due to current design being flexible enough to handle specific customer discount and customer discount groups. Changing a table relation and strengthening validation would limit that flexibility. Feel free to utilize product's customization capabilities to extend this. 

Sincerely,
Business Central Team

Comments

R

R

RE: Table Relation. Customer Invoice discount code

Ramon Diaz Blanco on 5/17/2019 10:21:58 AM

Hi Hans,
Effectively, creating a new table would be more correct.
What I do not think is correct is the current assigment when inserting a record and stablish a table relation to table 18 where  not test and validate this relation
 

Category: Development

R

R

RE: Table Relation. Customer Invoice discount code

Hans H. Fiddelke on 5/17/2019 5:55:58 AM

No Table 19 isn't the correct table relation, because you may see the Invoice Discount  Code multiple times on lookup.
There should be an own table like "Customer Discount Group" and similar.
But you are right, using table 18 here is a little bit annoying.
 

Category: Development