MoparManiac78
IS-IT--Management
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
)
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
)