Editing Fields and their corresponding columns
Editing Fields and their corresponding columns
(OP)
I'm having trouble finding information on how to use the designer in Macola 9.6.900. On the order entry screen my old boss put in 2 fields for Cash Receipts but he used user_def_fld_3\4 for those cash values. This is making it very difficult for us to report\calculate on those because those fields are char(30), not decimal or numeric. I wanted to change those fields (or replace them) with fields that tie in to extra_10 and extra_11, both decimal(16,2), in the oehdrhst_sql table. Can anyone point me in the right direction on how to accomplish this?
RE: Editing Fields and their corresponding columns
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Editing Fields and their corresponding columns
RE: Editing Fields and their corresponding columns
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Editing Fields and their corresponding columns
CODE --> SQL
You can leave the CASE statement out if you are always populating the field with values that convert cleanly.
This would need to be adjusted depending on how the fields are defined on the screen e.g. currency, decimal etc.
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Editing Fields and their corresponding columns
@crystalrporting, I've tried casting as and converting but I always get "Error converting data type varchar to numeric." Using exactly your code all the numeric values converted to decimal come out as 0.000000.
RE: Editing Fields and their corresponding columns
Macola stores these fields differently depending on how they are defined on the screen - you will likely need to adjust the position in the SQL SUBSTRING to ensure you get the correct values.
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Editing Fields and their corresponding columns
RE: Editing Fields and their corresponding columns
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Editing Fields and their corresponding columns
RE: Editing Fields and their corresponding columns
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Editing Fields and their corresponding columns
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com