@carl-brooks @royce-lithgo Update: per Acumatica's response, I was able to change the Base Weight UOM by making all the weights in the system = 0 and...

@carl-brooks @royce-lithgo Yes! That explains it. And as Royce suggested, I will probably have to go directly to Acumatica to get it changed.

@timrodman FYI - I am able but haven't received permission. (and yes I know the old adage)

@wyatt-erp Thank you! I actually tried an ID field but probably wasn't an integer field. Need to figure out how to look that up. Line number (in the S...

@shawn-slavin I'm trying to format a column with a qty field so that it has nothing after the decimal (5 or 5. but not 5.00) and I can't find a field ...

Is there a chance it was a bug that was corrected in one of the upgrades we haven’t done? And if so is there a way to find out which upgrade?

@timrodman Thanks Tim for posting this in Ideas for Acumatica.

@shawn-slavin Functions seem to be available in Conditions but not in Parameters. So I am able to use =(DateAdd( [Date], ‘D’, -1)) in my conditions b...

@royce-lithgo Thanks for the help! I got it working. I did need another join with IN.InventoryItem as I had INKitSpecStkDHdr as well as INKitSpecStkDe...

@royce-lithgo I have both of those tables linked but I will check them again. However when I use InventoryCD (which I had done initially) I get the e...

@timrodman 1. Do you know of a Field that has no decimal places that can be used? 2. Can you provide a link to more info on format codes? Thanks!

True! I'm guessing its the Caption for CRCase.CreatedDateTIme but I don't see why they would want the Caption to match the Schema rather than the Fie...

@royce-lithgo Thanks! I think I was too focused on doing calculations in the Results Grid.

This was great except for a result that I didn't expect and don't understand. I am displaying FSAppointment.ScheduledDateTimeBegin and it uses the de...

Thanks for all the info! I have found something that works with the field ActualTimeDuration. =CDec( [FSAppointment.ActualTimeDuration] )

I have an answer now. This works for Sales Orders created from Appointments. I linked them as follows. SOOrder Left SOLine using orderNb...

FSAppointmentFromSOLine is an alias for FSAppointment and it isn't relevant - sorry! So I've since found the formula editor which is really helpful an...

Thank you! Is there any documentation anywhere that explains the syntax? I understand the concept but can't get it to work. In the results grid I hav...

Thanks

Unfortunately, @StartWeek day doesn't match the First Day of the week in the Time and Expense Preferences (EP101000). Thanks