× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I am just frustrated and venting to you.
How to convince someone it is better to avoid custom modification of
code if possible when the database can apply all the business rules
needed?

The business analyst wants me to put business rules into RPG legacy
program instead of following my recommendation of configuring up our
database tables according to existing business rules, so that our data
can apply the business rules.

Specifically, our customers (whether taxable or tax exempt) are located
everywhere (both Nexus and non-nexus states) Likewise, a customer can
ship to any state he wants to (nexus or non-nexus).

Our JDE World application already has the business rules in the database
and software so that orders are charged sales tax correctly if one sets
up the Sold-To customer and Ship-to according to real-world rules as to
Exempt/Taxable status and according to Nexus and Non-nexus locations.

Because not all of our potential customers are currently set up in the
database for sales tax rules (because we do not use Vertex software),
the business analyst directed me to custom mod our sales order entry to
override what does not exist in the database.

Aarrgh! This means that JDE sales order entry program is
custom-modified to put the necessary sales tax codes in the sales order
simply because users have not invested time to configure the customer
master database records as recommended by JDE.

I advocate strongly that data in database tables be scrubbed/edited so
that the data adheres to the business rules. It is not good to allow
data in tables to remain non-compliant just because users do not want to
invest time to scrub and edit the data.

I found a few resources today with
these Google search terms: extract business rules from code AS400
For example:
http://www.databorough.com/guide-to-business-rules-recovery.html

This document from Databorough regarding X-Analysis has helpful info
that I will propose.

There are two broad categories of Business Rules: Structural and
Functional.

Structural Business Rules define how the database is modeled - what are
the tables, their attributes, the relationships between different
tables.

Structural Business Rules also define much of the user interface - how
it is designed into individual use cases or activities, and the flows
between them.

Functional Business Rules define how data is processed in the
application. A typical Functional Business Rule is in the form of "if
this condition is met, then take these actions."


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.