jde57
Member
Hi ,
I am writing a report using the Sales History Business View (v42119a). In this report I have columns named Total 2002 January2002 , February 2002, ... Dec 2002.
Under each column is the sales value for each month. To get the figures in each column, I wrote an event rule:
If BC Date - Invoice (F42119) is equal to "01/01/2002-31/01/2002"
RV January = [BC Amount - Extended Price (F42119)]
End If
RV TTL January = [RV TTL January]+[RV January]
This works well. The only problem that I have is that I have the dates hardcoded in the Event Rule for EACH month.
I have come across a business function B3000250 - GetMonthDescription - how do I use this in the Event Rule Editor?
Thanks,
AJITH
Ajith Singh
D H Brothers Industries (Pty) Ltd t/a Willowton Oil & Cake Mills
P O Box 384, Pietermaritzburg, 3200
266 Ohrtmann Road, Willowton, Pietermaritzburg, 3200
Republic of South Africa
Tel: +27.33.3557800
Fax: +27.33.3557868
URL: www.wocm.com
E-Mail Disclaimer:
This e-mail message and all attachments thereto ("this message") contain
confidential information intended for a specific addressee and purpose.
If you are not the addressee (a) you may not disclose, copy, distribute
or take any action based on the contents hereof; (b) kindly inform
the sender immediately and destroy all copies thereof. Any copying,
publication or disclosure of this message, or part thereof, in any form
whatsoever, without the sender's express written consent, is prohibited.
No opinion expressed or implied by the sender necessarily constitutes the
opinion of D H Brothers Industries (Pty) Ltd.
This message does not constitute a guarantee or proof of the facts
mentioned therein. D H Brothers Industries (Pty) Ltd accept no
responsibility or liability in respect of (a) any opinion or guarantee
of fact, whether express or implied; or (b) any action or failure to
act as a result of any information contained in this message, unless
such information or opinion has been confirmed in writing by an
authorised D H Brothers Industries (Pty) Ltd partner or employee.
I am writing a report using the Sales History Business View (v42119a). In this report I have columns named Total 2002 January2002 , February 2002, ... Dec 2002.
Under each column is the sales value for each month. To get the figures in each column, I wrote an event rule:
If BC Date - Invoice (F42119) is equal to "01/01/2002-31/01/2002"
RV January = [BC Amount - Extended Price (F42119)]
End If
RV TTL January = [RV TTL January]+[RV January]
This works well. The only problem that I have is that I have the dates hardcoded in the Event Rule for EACH month.
I have come across a business function B3000250 - GetMonthDescription - how do I use this in the Event Rule Editor?
Thanks,
AJITH
Ajith Singh
D H Brothers Industries (Pty) Ltd t/a Willowton Oil & Cake Mills
P O Box 384, Pietermaritzburg, 3200
266 Ohrtmann Road, Willowton, Pietermaritzburg, 3200
Republic of South Africa
Tel: +27.33.3557800
Fax: +27.33.3557868
URL: www.wocm.com
E-Mail Disclaimer:
This e-mail message and all attachments thereto ("this message") contain
confidential information intended for a specific addressee and purpose.
If you are not the addressee (a) you may not disclose, copy, distribute
or take any action based on the contents hereof; (b) kindly inform
the sender immediately and destroy all copies thereof. Any copying,
publication or disclosure of this message, or part thereof, in any form
whatsoever, without the sender's express written consent, is prohibited.
No opinion expressed or implied by the sender necessarily constitutes the
opinion of D H Brothers Industries (Pty) Ltd.
This message does not constitute a guarantee or proof of the facts
mentioned therein. D H Brothers Industries (Pty) Ltd accept no
responsibility or liability in respect of (a) any opinion or guarantee
of fact, whether express or implied; or (b) any action or failure to
act as a result of any information contained in this message, unless
such information or opinion has been confirmed in writing by an
authorised D H Brothers Industries (Pty) Ltd partner or employee.
