Debtors Statements

[tonysmith]

Can you advise on what the system is passing down to the reports when you run a statement i.e what is required in the JiwaRanges formula.



I want to run a statement based on DB_Main and DB_Trans (not the stored proc used in std format)

[Mike.Sheen]

Can you advise on what the system is passing down to the reports when you run a statement i.e what is required in the JiwaRanges formula.

I want to run a statement based on DB_Main and DB_Trans (not the stored proc used in std format)

Hi Tony,

We set the contents of the following formulas if they exist in the report - there is some overlap because we wanted to support legacy custom statement reports, and have the same report be used for both the debtor maintenance form and the debtor statements menu report:

AAPrintDate
Pass_DebtorAccountNo
Pass_DebtorID
Pass_SP_AsAtDate
Pass_SP_StartingDebtorAccountNo
Pass_SP_DebtorAccountNo
Pass_SP_EndingDebtorAccountNo

If you're not using a stored proc, you can ignore the Pass_SP_* formulas and simply use AAPrintDate and also Pass_DebtorID OR Pass_DebtorAccountNo.

Mike