I have a simple sales order solution that uses a line items table which contains

Fields for part number, description, price and so on. So far so good.

Some line items that are added to the sales order do not contain part numbers.

So I want to create an item number calculation field that will only sequentially

Number line items that contain parts. I have accomplished this using a script

But a calculation field would be a cleaner way of doing it, I just can’t get the

Calculation quite right. Any help would be greatly appreciated.

Thank You

Anthony

I am not sure why you would need such a thing, but perhaps this might help:

http://fmforums.com/forum/showpost.php?post/335388/

Did not work for me but thanks anyway

Anthony

Hi Anthony, and Welcome to the Forum.

I think I see what you are asking, but why not upload a copy of your file, or a screen shot of the report, and a copy of your Script.

Lee

I did not mean to offend anyone with my lack of a detailed response.

I am new to this forum and was just looking for some help with a

frustrating issue that I was working on. I tried to be clear in my

original escription of my problem and what I was trying to accomplish.

The only response hat I received and appreciated was a link to another

area of the forum to a cenario that really did not apply to my situation.

I have a sale orders table that uses a line items table:

SalesOrders::SaleID = LineItems::SaleID

I have an Item # field in the line items table that I populate

via a script every time I add or remove an item from the sales

order. My customer requires only items that contain part numbers

receive an item number in sequential order so I cannot use a

Get (RecordNumber) as a solution. I was trying to come up with

a calculation so I would not have to rely on a script. I thought

this could be done through a calculation. I hope this makes things

clearer.

Again I apologize if I am posting in the wrong area as I am new

to this forum and do not know the protocall and thanks in

advance for any further help on the matter.

Anthony

The only response hat I received and appreciated was a link to another

area of the forum to a cenario that really did not apply to my situation.

The scenario may seem different, but it is the same problem - that is, if I understand correctly that the sequential numbering should start from 1 for each order.

OrdinalInCategory.fp7.zip

Yes each sales order starts numbering with 1. Thank you so much!!! Works perfectly!! I was just a little confused about the way it was being described.

Thank you again for clarifying and the sample file.

Anthony

On second thought, since you only have one "category", it could be much simpler.

---

Note that in version 9 or higher, you could use conditional formatting directly on the summary field, and eliminate the calculation field.

ConditionalOrdinal.fp7.zip

[And there is no rule which says you must provide more information (that was MY suggestion so you could be helped)

But remember - you (you = original poster) are asking for free help. If you are not clear, and make it into a difficult guessing game, you will not get effective help. Being clear and complete is an act of consideration.

On second thought, since you only have one "category", it could be much simpler.

This solution works even better for my needs. Exactly what I was trying to accomplish..

Thanks Again

Anthony