In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020
I am trying to format a date for positive pay in 0 padded month and date value without slashes and striking out....any help?
@bob-beardsley Not pretty, but what about something like this?
I have a similar need, also in a GI, except for the AMOUNT field.
The amount field must show NO commas, but always include 2 decimal places. When I un-format the field, it displays with 4 decimal places - Probably because of Company Config that shows pricing/amounts as 4 decimals.
But I can't seem to find the right combination to show 2 decimal places, without showing the commas. Despite this being in a GI, I can't include a schema for the field. here is the formula.
= IIf( [BT.DrCr] = 'C', -1*[BT.TranAmt], [BT.TranAmt] )
BT = PX.Objects.CA.CATran
the resulting AMOUNT field looks like this...
While the commas are gone, the amounts are showing 4 decimal. Any assistance would be helpful.