Skip to main content
Question

Custom field - Line number

  • May 16, 2024
  • 5 replies
  • 93 views

Forum|alt.badge.img+9

Hi All,

I want to create a custom field (persistent) that for each line, has a line number.

So what I mean and as an example and for Customer Order Lines

 

CF ‘Line_No’

1

2

3

4

5

etc..

For each custom order line created.

I do not want to rely on the existing standard ‘LINE_NO’ on the customer order line view.

Has anybody do this before?

 

5 replies

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 218 replies
  • May 16, 2024

Hi @JamesW72 you can create the persistent field to handle this. Are you looking for this to be manually or automatically populated?


Forum|alt.badge.img+8
  • Hero (Employee)
  • 59 replies
  • May 16, 2024

Hi James.

 

You can just create a Custom Attribute on the entity CustomerOrderLine and then have a workflow that can automatically populate that field based on the max(Cf$_Line_No) + 1 value.

 

Best regards.
Gonzalo.

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 40 replies
  • May 16, 2024

Hi @JamesW72 you can create the persistent field to handle this. Are you looking for this to be manually or automatically populated?

Hi, Automatically created numbering..

I was thinking of something like a custom event but I do remember (a long time ago) setting / calling something in a persistent ‘PL/SQL Expression’ to generate a line number - but that was a long time ago :) 


COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 218 replies
  • May 16, 2024

Hi @JamesW72 you can create the persistent field to handle this. Are you looking for this to be manually or automatically populated?

Hi, Automatically created numbering..

I was thinking of something like a custom event but I do remember (a long time ago) setting / calling something in a persistent ‘PL/SQL Expression’ to generate a line number - but that was a long time ago :) 

Depending on the version you are using you could either execute what @Gonzalo states or a standard event should work.


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 40 replies
  • May 16, 2024

Hi @JamesW72 you can create the persistent field to handle this. Are you looking for this to be manually or automatically populated?

Hi, Automatically created numbering..

I was thinking of something like a custom event but I do remember (a long time ago) setting / calling something in a persistent ‘PL/SQL Expression’ to generate a line number - but that was a long time ago :) 

Depending on the version you are using you could either execute what @Gonzalo states or a standard event should work.

Apps 10 UPD19