Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Invoice

Status
Not open for further replies.

MoparManiac78

IS-IT--Management
Aug 20, 2013
1
US
Hello,

I'm completely new to Crystal so please forgive my ignorance. I'm attempting to modify a DirectInvoice so that any time a particular item needs replacement, they will be notified of the charge on the invoice. Currently it lists the item with a charge and a product description. My goal is that directly under the product description it would say something like "Lost item replacement charge". Not even really sure where to begin here, just started at a new company and have had no exposure to this, got thrown my way on the second day :). They had already started working on the problem and gave me this code. INVOICELINE 36 is the item that should trigger the message. Let me know if I'm not showing you the right information, thank you.

{V_INVOICELINE.LANGUAGECODE} = {?PARAM_LANGUAGECODE} and
{REPORTPARAM.REPORTPARAM_ID} = {?PARAM_REPORT_RUN_ID} and
{V_INVOICELINE.INVOICELINETYPE} <> 18 and
( ({V_INVOICELINE.PRICE} <> 0.0) or
({V_INVOICEHEADER_WMU.INVOICELAYOUTCODE} = '1')
// [ROP added 04-05-2011]
or {V_INVOICELINE.INVOICELINETYPE} >= 5
or {V_INVOICELINE.INVOICELINETYPE} = 36
)
 
One approach. Create a detail line under the product description with text present with the desired message. Use a formula to keep the line suppressed until the INVOICELINE has a particular value then change the value of the formula from TRUE to FALSE for suppression the line.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top