×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Saving custom data from a Macola ES form

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

  

RE: Saving custom data from a Macola ES form

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:
www.gainfocus.biz/exceladdin.html

RE: Saving custom data from a Macola ES form

(OP)
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

RE: Saving custom data from a Macola ES form

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:
www.gainfocus.biz/exceladdin.html

RE: Saving custom data from a Macola ES form

(OP)
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

RE: Saving custom data from a Macola ES form

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:
www.gainfocus.biz/exceladdin.html

RE: Saving custom data from a Macola ES form

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:
www.gainfocus.biz/exceladdin.html

RE: Saving custom data from a Macola ES form

(OP)
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
  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close