Saving custom data from a Macola ES form
Saving custom data from a Macola ES form
(OP)
Hi,
We are using Macola ES version 9.5.300. I have a requirement to save the freight amount from the order form (OE0101.) I do not want to open another connection to the database if I can help it. Is there any way from Flex Code that I can stuff the FreightAmount (frt_amt) into the database.
I have to mention that I am new at flexibility.
Any help will be most welcome
Thanks in advance
Steven
We are using Macola ES version 9.5.300. I have a requirement to save the freight amount from the order form (OE0101.) I do not want to open another connection to the database if I can help it. Is there any way from Flex Code that I can stuff the FreightAmount (frt_amt) into the database.
I have to mention that I am new at flexibility.
Any help will be most welcome
Thanks in advance
Steven
RE: Saving custom data from a Macola ES form
Test this and let us know.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Saving custom data from a Macola ES form
I would like to know if it is possible to get to the underlying dataset and populate the field so that when the record is saved the freight amount will be saved to the database.
Thanks again for your help
Steven
RE: Saving custom data from a Macola ES form
http://i.imgur.com/lWqQb.png
You don't need to do ANYTHING, except populate this field.
If you are not seeing this screen after you are done entering all the line items, it is because under OE package settings, the checkbox "Enter billing information during order entry" is not checked.
You do not need to write any code to get this info to save.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Saving custom data from a Macola ES form
Thanks for your input
Steven
RE: Saving custom data from a Macola ES form
You can still do this with flexibility. Do you need a field for them to key in the $ amount or can you pick this amount from a table? Or calculate it?
In any 3 of the above cases, once you have the amount, store it in a variable and run the following SQL statement on the post-save event:
UPDATE oeordhdr_sql
SET frt_amt = <yourvariable>
A trigger seems to indicate you would not need the user to tell you the amount. If this is the case you do not need an entry field either.
If you need help let me know.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Saving custom data from a Macola ES form
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Saving custom data from a Macola ES form
There is a separate department that does order entry and billing. I can't do anything on the billing screen because this would necessitate the shipping person knowing that freight had already been charged in a back order situation and blanking out the field.
The trigger works well because freight is calculated according to the ship via field and back orders have an invoice number in the record.
Again thanks for your input.
Steven