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?
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.