Passing Debtor Account No
Posted: Tue Feb 27, 2018 1:21 pm
Hi, I have created a crystal report that Prints the Debtor Dr/Inv Pricing Groups per product Price List for a specific Debtor.
The report asks for the Debtor Account no and runs fine from the Menu using //Pass_DebtorAccountNo.
I have set the Report up in the reports Configuration as 'Report type' Either but it won't use the Debtor I am currently displaying in the Dr Maint form.
I have tried using the DebtorID in the JiwaRanges formula and in Report, Selection formula, Record as the 1st line = //{DB_Main.DebtorID} = '0000000061000000001V' but still no good.
I am using the same principle as Drs Statements or Invoices but can't seem to get it to work. Any ideas?
Thanks.
The report asks for the Debtor Account no and runs fine from the Menu using //Pass_DebtorAccountNo.
I have set the Report up in the reports Configuration as 'Report type' Either but it won't use the Debtor I am currently displaying in the Dr Maint form.
I have tried using the DebtorID in the JiwaRanges formula and in Report, Selection formula, Record as the 1st line = //{DB_Main.DebtorID} = '0000000061000000001V' but still no good.
I am using the same principle as Drs Statements or Invoices but can't seem to get it to work. Any ideas?
Thanks.