Danny Tang
01/31/2019, 9:42 PMDashona
01/31/2019, 10:14 PMDanny Tang
01/31/2019, 10:58 PMDanny Tang
02/01/2019, 12:57 AMC_Billings
02/01/2019, 4:34 AMAmanda Flynn
02/01/2019, 2:44 PMGregory Jones
02/01/2019, 4:09 PMEric B
02/01/2019, 4:18 PMdrixxodev
02/04/2019, 9:58 PMKevinJ of Kansas
02/04/2019, 10:44 PMKevinJ of Kansas
02/04/2019, 10:44 PMjonny
02/04/2019, 10:52 PMaccount
field.michoel
02/04/2019, 10:57 PMShipping Line
, COGS Line
, Tax Line
. I usually just use Account Type
.michoel
02/04/2019, 10:58 PMItem
is none of - None -
jonny
02/04/2019, 11:07 PMItem
column actually is filled out on the GL lines and the regular item lines. Why don’t they have like a Is GL Line
field or something?jonny
02/04/2019, 11:14 PMmemo
field, seems like it puts in Cost of Sales
or something similar if it’s a GL line.michoel
02/04/2019, 11:15 PMCOGS Line
= 'No' doesn't work?Gregory Jones
02/05/2019, 7:28 PMGregory Jones
02/05/2019, 8:13 PMCr223309
02/05/2019, 8:35 PMkarlenigma
02/05/2019, 8:48 PMkarlenigma
02/05/2019, 8:48 PM{opportunity.entitystatus.id}
first as i don’t believe you will be able to go 3 deep.mattb
02/06/2019, 3:40 AMREPLACE({customer.altname}, 'Blah : ', '')
, what if “blah” is “blah’s” ?michoel
02/06/2019, 5:02 AM{customer.altname}
. If you want to cover both possibilities you can do something like REPLACE(REPLACE({customer.altname}, 'Blah : ', ''), 'Blah\'s :' , '')
or use a regular expression REGEXP_REPLACE
mattb
02/06/2019, 5:15 AMmattb
02/06/2019, 5:15 AMmichoel
02/06/2019, 5:17 AMmattb
02/06/2019, 5:24 AMNElliott
02/06/2019, 1:46 PMJTape Dan
02/06/2019, 2:31 PM