Debtor Statement and non standard Due dates

[SBarnes]

I have a client where we have over ridden invoice processing and with a custom number of days used in a custom field on the sales order and using Process_DebtorTransactionsStart to set the due date on the debtor transaction and this works.

They also want to modify the As At Statement so that based upon the due date the money falls into the correct period balances based upon the due date, if I modify usp_Jiwa_Debtors_StatementsAsAt or rather a new version called usp_Attkey_Debtors_StatementsAsAt to include the due date in the table and feed the due date rather than transaction date to ufn_JIWA_Debtors_TransactionPeriodNo will this achieve the desired result?

[Mike.Sheen]

if I modify usp_Jiwa_Debtors_StatementsAsAt or rather a new version called usp_Attkey_Debtors_StatementsAsAt to include the due date in the table and feed the due date rather than transaction date to ufn_JIWA_Debtors_TransactionPeriodNo will this achieve the desired result?

I can't be sure without doing it myself first, but I think so.

[SBarnes]

Thanks but late yesterday I convinced the customer that this is not a good idea as the period is more about when the spend happened because a due date could be in the future and just adding the due date to the statement is more important in presenting the picture they want.