Recording Line numbers in Header /Detail BO

sabbirehal

Hi Group,
Please ignore my ignorance as I am new to aware IM. I wanted to record auto increment line number number in the PO Detail BO and wanted to know the best way of doing it in Aware IM. Please see attached picture for more detail .

Thanks
Sabbi

PO Detail Lines.jpg

Jaymer

sorry sabbi
what you wrote doesn't make any sense.
i think you need to delete you question and re-type it.

sabbirehal

Sorry Jaymer but I have basically two BO's PO Header and PO Detail in One to many relationship.
The PO Header will have PO Number as Unique and PO Detail will be PO Number and Line Number as unique. I know awareim can manage one to many relationship automatically but don't know how it will store the Line Number in sequential order of its creation?

Thanks

idpSteve

You can add a number attribute to your object, and in the attribute properties menu under the 'Number-specific' options there is 'Auto-increment'.

I think this might work for your purpose?

customaware

In the BO Rules for PODetail

PODetail IS NEW
PODetail.LineNumber = COUNT PODetail WHERE PODetail IN POHeader.om_PODetail + 1

idpSteve

Hi Mark.

Would that not have a bigger overhead than just using the built in increment function?

EDIT:

This would also cause an issue if a record is deleted, you might end up with duplicate line numbers in that case as the COUNT wouldn't return the number of the last record. You could also do this with a counter in system settings or something, BUT, why not just use the built in function?

Jaymer

eagles9999 wrote
In the BO Rules for PODetail

PODetail IS NEW
PODetail.LineNumber = COUNT PODetail WHERE PODetail IN POHeader.om_PODetail + 1

No count, use max PODetail.LineNumber + 1

sabbirehal

The auto increment is simple but I think max PODetail.LineNumber + 1 what I need as I want to keep the number increment within single PO Number.

Thanks to all for your input.

Regards,
Sabbi

Jaymer

sabbirehal wrote
as I want to keep the number increment within single PO Number

The auto inc facility HAS A WAY to do numbering within groups, like you desire. I’ve never used it. Performance-wise, I’m not sure which method is better.

sabbirehal

Jaymer,

Ok, please see the attached picture of the actual BO lines. I need the LineNumber increment within the ob_Employee_RID. When I try to add the auto increment property, it does not show this field ob_Employee_RID. How can I use the Max LineNumber+1 Rules for every record within ob_Employee_RID?

Thanks
Sabbi

Line Number Increment.jpg

sabbirehal

Thanks to mark. He helped me on the Zoom.