Before using the Purchase Request module it is important to understand some of the more obscure fields and how the totals are calculated. So the purpose of this post is to do just that:
Sub Total
The Sub Total is surprisingly enough quite straightforward. The code for it is:
(select ISNULL(SUM(CHILD.”PRICE”*CHILD.”QUANTITY”),0) from “_SMDBA_”.”_PI_” as CHILD where CHILD.”SEQ_PR” = [...]

continue reading.....

Version 2.0 of the Forward Schedule of Change application is nearing completion and should be available before the end of the month. Some of the changes that have been incorporated include:

Full screen change calendar with change details on separate page.
Change details now include Change History, Change Assessments and Change Approvals (visibility of which can be [...]

continue reading.....

A lot of people ask about sending email notifications from SDE in HTML format.  This is a great way to make your notifications consistent and easy to read for your users.  It also works very well for including links in the email for your users to click.  There aren’t too many email clients that won’t [...]

continue reading.....

In part 1 of this series (http://www.joatit.com/wordpress/?p=539) I described the relationships and use of the modules associated with the CI Assemblies/Configurations module. I also described how I would implement a real-world example using these modules and eluded to the need to automate some functionality through business rules and be aware of certain issues when it [...]

continue reading.....