Search results for query: *

I have the following two selection record formulas if {?Salesperson}= "Salesperson 1" then {CLNTCUS.~Custom3} = {?Employee} and {@DatesRemaining} < 13.00 and {AR.InvoiceDate} = {?Invoice Date} and {AR.Type} = "I" else if {?Salesperson}="Salesperson 2" then {CLNTCUS.~Custom21} = {?Employee} and...

if {?Salesperson} = "Salesperson 1" then {CLNTCUS.~Custom20}else if {?Salesperson} = "Salesperson 2" then {CLNTCUS.~Custom22} What does the error "The formula result must be a string" mean in reference to the above formula that I am trying to enter in the display spring for a field

Is there a way to use a record selection prameters to select a detail section. For example, I am working on a commission report, that shows the following details: Invoice Date Client Name Invoice # Invoice Amt Commission Rate {CLNTCUS.~Custom20} Commission Amount (this is a...

I'm working on a salesperson commission report. I have details about invoices, commission amount by salesperson and commission amount earned by salesperson. There are two groups - {CLNTCUS.~Custom3} is group 1 (represent Salesperson1) and {CLNTCUS.~Custom21}is group 2 (represent Salesperson2)...

I have a report that gives me the commisions on a salesperson. I use the following Selection formula: {CLNTCUS.~Custom3} = {?Employee} and {@DatesRemaining} < 13.00 and {AR.InvoiceDate} = {?Invoice Date} and {AR.Type} = "I" I want to add a second salesperson field {CLNTCUS.~Custom21) and...

This one may be a bit hard to explain. I created a commission report that shows the Salesperson 1 and the following information: Invoice Date/Aged Months/Client Name/Invoice #/Invoice Amount/Commission Rate/ Commission Amount This report works fine. Now I have added a Salesperson 2 and want...

This one may be a bit hard to explain. I created a commission report that shows the Salesperson 1 and the following information: Invoice Date/Aged Months/Client Name/Invoice #/Invoice Amount/Commission Rate/ Commission Amount This report works fine. Now I have added a Salesperson 2 and want...

Is there a way I can convert a field that is a text field (notes) and make it a number field so I can total the numbers in the field?

I am using version 9.2. I have attached a copy of my report Problem….The items highlighted in yellow are invoices that show the Actual Amount billed for the client. The number in blue is the Final bill amount that I want to show. However on accounts that have additional invoices (SM CENTER...

I have a report that pulls tax returns...by statutory due date. The report works fine but then I created a formula that will add the preparers name so I can know who is assigned to that return. When I add the following formula to my report I get repeating projects. I have checked my links and...

How can I write a formula that will do the following: Show me all the invoices in a date range selected by a paramenter (?invoice date) however, some of the invoices have adjustments within the same date range....for those invoices I want to show the DATE RECEIVED DATE instead of the INVOICE...

Can I take a Total from a Subreport and subtract it from a total on the main report? For Example: I have a main report that calculates Invoice amounts based on the invoice date ..i.e.5/1/2010 - 5/30/2010 and those invoices total $55,823.73. My subreport calculates the adjustments applied to...

What is wrong with this variable formula? I need to pull out all adjustment amount from one table and have them show as well as all Final Bill Amounts. If it is an adjustment amount I need it to show as a negative. WhilePrintingRecords; currencyVar adjustment; currencyVar InvoiceAmt...

I am using this formula to get a dollar amount if the Cash type equal "A" (for Adjustment) and if it does equal adjustment I need it to Subtract the Cash.Amount from the Final Bill amount BUT if it equals "P" (for payment) I want it to just show the final bill amount My Formula: if {CASH.Type}...

I am trying to write a report that will calculate a deadline date based on the actual start date of a project and end date of a project. This is what I currently have datevar x := {PROJECT.StartDate}; datevar y := {PROJECT.FinishDate}; datevar lastday := dateserial(year(y),month(y)+1,+20)...