Hi Lorne I would use something like this =IIf( [ARTran.Type] = 'CRM',[ARTran.Amount]*-1,[ARTran.Amount]) Create a group by and sum of this field ...

Hello. Why is that Acumatica creates a GL transaction when receiving a non-stock item hitting the COGS and doesn't it create it when shipping it? ...

Michael If you want to find the primary contacts for vendors use the PX.Objects.AP.VendorR.primaryContactID = PX.Objects.CR.Contact.ContactID You wi...

it could be on a different name like the name of the formula. is it also marked as visible?

You can add any column with a value and instead of showing that value add a =IFF() condition. i.e. =IIf( [table.field]<>NULL, ' ', ' ' )

Hi @tra_user I am glad it worked the way you needed it. Hey, count me in for Lunch. We never know. LOL. The Substring function extracts a secti...

@tra_user I see. If you convert it to string, it will be sorted 01, 02, 03... 12. I used the following and it worked for me. =CStr(substring( CSt...

why don't you use PeriodID instead?

@krysmcginn Try this, it should work. =CInt([CROpportunity.AttributeWINCONF])*CInt([CROpportunity.AttributeEVENTCONF])

I'd suggest you create a new workspace and assign this GI to that new one. I'd also change the GI ID. Have you also taken a look at the site map? any ...

What is the error you are getting?

Hi @timrodman This is great! Thank you so much. Have a nice day

Hi @timrodman Would you know how to hide them, so users can't have access to them at all? Thank you