Saving custom data from a Macola ES form

[stevenbc]

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

 

[dgillz]

What you are describing is native to macola and you do not need any flexibility to save that value. You may have used Flex to calculate what it should be and to populate the field on the screen, but no flex is needed to save it.

Test this and let us know.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[stevenbc]

Thanks for your reply, but I am trying to save the freight from the sales order entry screen (OE0101) but there is no freight field on the screen. When I do this from the billing screen then you are right it works and I can populate the field on the screen and it is pushed back to the database.

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

 

[dgillz]

The freight does not appear on the OE0101 screen, so you are either working with a user defined field, or a VBA only field. The freight is on the OE0112CG screen, a screen shot is here:

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:

http://www.gainfocus.biz/exceladdin.html

 

[stevenbc]

Again Thank you for your reply. Order entry does not update billing info. This is done at shipping time and for various reasons I cannot update the freight at this time. I wanted to update the freight when the ship via code was changed. I will try and do this at the database level with a trigger.

Thanks for your input

Steven

 

[dgillz]

OK please clarify - you don't update billing info at order entry, but you want to update billing info at order entry based on the ship via code?

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:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Um, you'll need a WHERE clause in there for order type and order number. Details, details.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[stevenbc]

Thanks for all your help. I have implemented an update trigger for this. The reason that I don't want to implement my own custom sql is because I do not want another connection to the database however short it may be. The users already have some 20 forms open and it does not matter that I tell them to keep one form for each function ope if they have to. I would like to have tapped into Macola functionality for the save.

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