Skip to Content
author's profile photo Former Member
Former Member

Create UDF and populate with a formula

Using the OITM table I would like to create 4 UDF's to add to the "List of Items" screen in inventory.

The 3 fields to be used are A) LastPurPrc; B) OnHand; C) NumInSale

The 4 filelds I want to create are: 1) NumberOfCases = B/C; 2) ExtCost = A*B; 3) Last Case Cost = A*C & 4) LastCost = A

Can someone tell me how to do this or point me in the direction to find instructions.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 08, 2012 at 02:55 AM

    Hi Kathy Walker...

    You can use the FMS to calculate.. But where do you want these information if it is at the document level or report level.

    If report level then you can use directly in the report instead of saving in the DB...



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.