[Duncan]

We have a custom field that shows the sum of applied credit memos for that invoice. Now, to show this custom field on the printed invoices, we created a custom element in the PDF layout. When we put the element text {custbody5} the amount shows fine. When we enable Show Label it does show it. The issue is we don't even want to mention this if there is no credit memo applied for that invoice. So instead of checking Show Label box, I want to add something like:

{If custbody5 > 0 then} Applied Credit Memo Total: {custbody5} {end}

Can we not put statements like this in Element Text?

Also, we are having problem putting this field right below the Totals. Is there a way to anchor this to other elements?

Thank you.
This is a cached copy. Click here to see the original post.

[ERPExperts]

Hi Duncan / Deniz

I would suggest moving to Advanced PDF Layouts to do this. Have you looked in to them?

Thanks

Pete.

[Duncan]

Thank you Pete, I haven't heard of it before. I will sure check this.

[cdelacruz]

Originally posted by Duncan

View Post

We have a custom field that shows the sum of applied credit memos for that invoice. Now, to show this custom field on the printed invoices, we created a custom element in the PDF layout. When we put the element text {custbody5} the amount shows fine. When we enable Show Label it does show it. The issue is we don't even want to mention this if there is no credit memo applied for that invoice. So instead of checking Show Label box, I want to add something like:

{If custbody5 > 0 then} Applied Credit Memo Total: {custbody5} {end}

Can we not put statements like this in Element Text?

Also, we are having problem putting this field right below the Totals. Is there a way to anchor this to other elements?

Thank you.

Try: <%=Case When {custbody5} > 0 then 'Applied Credit Memo Total:'||{custbody5} else ' ' end %>

[Duncan]

Advanced PDF Layouts helped us with this issue, and we are planning on moving to Advanced PDF Layouts as a new year resolution.

[kbarua]

Originally posted by Duncan

View Post

We have a custom field that shows the sum of applied credit memos for that invoice. Now, to show this custom field on the printed invoices, we created a custom element in the PDF layout. When we put the element text {custbody5} the amount shows fine. When we enable Show Label it does show it. The issue is we don't even want to mention this if there is no credit memo applied for that invoice. So instead of checking Show Label box, I want to add something like:

{If custbody5 > 0 then} Applied Credit Memo Total: {custbody5} {end}

Can we not put statements like this in Element Text?

Also, we are having problem putting this field right below the Totals. Is there a way to anchor this to other elements?

Thank you.

Can someone please shed some light on how to do this:

We have a custom field that shows the sum of applied credit memos for that invoice.

[kbarua]

Please disregard as I found the help article.

[ERPExperts]

Hi kbarua.

So that others whom may be looking at this same issue, it would be good to share the answer.

Was it that you have to put "gt" instead of the ">" symbol when doing Greater Than comparisons?

Thanks

Pete.

[kbarua]

Sorry, just now seeing your request. I don't remember which help article it was.

[Author]

Posts