Page Comparison

...

To include these transactions in the statements, changes have to be made to the stored procedure dbo.usp_Jiwa_Debtors_Statement.  Anytime you upgrade to another Jiwa 7 version, you will need to edit and run this stored procedure again because the upgrade process will override your changes.

1. change Change the line --AND AgedOut = 0 by removing the two dashes before that statement i.e. AND AgedOut = 0

Image Modified

There are two such lines!

2. Remove the WHERE clause from the end of the stored procedure - to do this change:

SELECT
Debtors.*,
DebtorTransactions.TransID,
DebtorTransactions.InvRemitNo,
DebtorTransactions.TransactionDate,
DebtorTransactions.Reference,
DebtorTransactions.Remark,
DebtorTransactions.TransactionType,
DebtorTransactions.Amount,
DebtorTransactions.DebitAmount,
DebtorTransactions.CreditAmount,
DebtorTransactions.AllocatedAmount,
DebtorTransactions.DebitCredit,
DebtorTransactions.TransactionBalance,
DebtorTransactions.PeriodNo,
@OurCompanyName AS OurCompanyName, @OurCompanyABN AS OurCompanyABN, @OurCompanyAddress1 AS OurCompanyAddress1,
@OurCompanyAddress2 AS OurCompanyAddress2, @OurCompanyAddress3 AS OurCompanyAddress3,
@OurCompanyAddress4 AS OurCompanyAddress4, @OurCompanyPhone AS OurCompanyPhone, @OurCompanyEmail AS OurCompanyEmail,
@OurCompanyWebSite AS OurCompanyWebSite, @OurCompanyFax AS OurCompanyFax,
@MoneyDecimalPlaces AS MoneyDecimalPlaces, @OurCompanyACN as OurCompanyACN
FROM
@DebtorTempTable Debtors
INNER JOIN @DebtorTransactionsTempTable DebtorTransactions ON Debtors.DebtorID = DebtorTransactions.DebtorID
WHERE
(DebtorTransactions.TransactionBalance <> 0 OR DebtorTransactions.TransID = 'DUMMY')
ORDER BY
TransactionDate, InvRemitNo

to:

SELECT
Debtors.*,
DebtorTransactions.TransID,
DebtorTransactions.InvRemitNo,
DebtorTransactions.TransactionDate,
DebtorTransactions.Reference,
DebtorTransactions.Remark,
DebtorTransactions.TransactionType,
DebtorTransactions.Amount,
DebtorTransactions.DebitAmount,
DebtorTransactions.CreditAmount,
DebtorTransactions.AllocatedAmount,
DebtorTransactions.DebitCredit,
DebtorTransactions.TransactionBalance,
DebtorTransactions.PeriodNo,
@OurCompanyName AS OurCompanyName, @OurCompanyABN AS OurCompanyABN, @OurCompanyAddress1 AS OurCompanyAddress1,
@OurCompanyAddress2 AS OurCompanyAddress2, @OurCompanyAddress3 AS OurCompanyAddress3,
@OurCompanyAddress4 AS OurCompanyAddress4, @OurCompanyPhone AS OurCompanyPhone, @OurCompanyEmail AS OurCompanyEmail,
@OurCompanyWebSite AS OurCompanyWebSite, @OurCompanyFax AS OurCompanyFax,
@MoneyDecimalPlaces AS MoneyDecimalPlaces, @OurCompanyACN as OurCompanyACN
FROM
@DebtorTempTable Debtors
INNER JOIN @DebtorTransactionsTempTable DebtorTransactions ON Debtors.DebtorID = DebtorTransactions.DebtorID
--WHERE
--(DebtorTransactions.TransactionBalance <> 0 OR DebtorTransactions.TransID = 'DUMMY')
ORDER BY
TransactionDate, InvRemitNo

To make this change permanent you will need to

...