Search results for query: *

When I insert the check state formula I now get duplicate records

OK but where do I put the second formula?

To be a little clearer I need to be picking up the address state but I'm not sure if I should do it in this formula or in selection?

Hi I have this IF {CUST.COUNTRY}='' then 'U.S.A.' else{COUNTRY.NAME} I am using that so that all us states come under one heading but I also need to compare the customers state with the address state and if the customer state does not equal the address state to make it the address state else...

Hi I have a report that shows the invoice id and the sale but it is duplicating both of these records. I am guessing it is a linking issue but not sure how to fix it, any ideas? i was thinking of surpressing the duplicate but that wouldn't work in the sale amount unless it could match the sale...

Hi I have a tax report that shows the counties with the orders for each county. I would like to give the option to show summery or detail, how would I do that? Thanks

I did a payment audit report and I would like to get it to print each payment account together, like all case for the specific date range then visa, mc and so forth. Right now it prints all of them together for each date. How can I get the report to do each account by itself? Hope this makes...

No there is nothing in the data it is just some credits are actually owed to the customer and others are a credit because of an error that it was billed to the wrong custmer so we have to do a credit to get it off that account and they want proof we did it. I was thinking there was a way to use...

Hi I have this formula: if {INVOICE.INV_TOTAL}<0 then "CREDIT ON FILE" Is there a way I can give my bookkeeper the option to have this print or not? I don't want it to print on all the credits since some are adjustments. If so how would I do that?

Thank you very much it works and looks perfect.

It's not surpressing the payments applied formula, how can I supress the whole formula?

OK I made a new formula that gave me the CREDIT ON FILE but I don't know how to supress the Paymentremit I have if {INVOICE.INV_TOTAL}<0 then "CREDIT ON FILE" but need to supress the paymentremit formula How?

I do not need to do any arithmetic later. I just need the payments applied to say CREDIT is the {INVOICE.INV_TOTAL}is <0 so how would I add that to this formula IF {INVOICE.TRANS_TYPE}='R' and {INVOICE.POSTADJ}>0 then {INVOICE.POSTADJ} else {INVOICE.REMITTED}

OK I may be going about this the wrong way I want the Payment applied to just say CREDIT ON FILE if the invoice total is negative So I have the formula for paymetapplied as this: IF {INVOICE.TRANS_TYPE}='R' and {INVOICE.POSTADJ}=0 then 'Payment Credited' else 'Payments Applied' and that gave...

{INVOICE.POSTADJ} is also a number but negative When I try the totext formula I get a number is required (it highlights IF)in front of INVOICE.POSTADJ.

The {invoice.remitted} is a number

when I try that it says a string is required here {INVOICE.REMITTED}

What am I leaving out of this formula IF {INVOICE.TRANS_TYPE}='R' and {INVOICE.POSTADJ}>0 then {INVOICE.POSTADJ} else {INVOICE.REMITTED} IF {INVOICE.POSTADJ}<0 then "CREDIT ON FILE" It tells me the remaining text doesn't appear to be part of the formula (its pointing to this line IF...

I have a credit memo and the invoice total shows a negative number, I want to get rid of the payment applied which is a positive number and invoice balance which is 0 (because the positive number and negative number made the balance 0) I would really like for it to say CREDIT ON FILE if the...

I need a formula to do this: If invoice total is negative don't show payment applied or invoice balance. How would I do this?