Get Max BFN

[jdeow1]

Hello Forum,
Want to know whether there is a BFN to retrieve the max PYID from F03B13/F03B14.How can the max PYID be retrieved without a BFN??

Thankx in advance

OW XE

 

[David Tremain]

May I (hopefully kindly) suggest you read the first posting about asking good questions.

If you are simply looking for the last PYID, there are several methods you can use, including (but not limited to):
* A SQL statement via ODBC - e.g. SELECT MAX(PYID) from F03B13
* Using the Universal Table Browser (UTB), and guessing (e.g., enter >1000 in the PYID column and click find - increase or decrease your guess until you find the largest value)
* Opening an application that has info from F03B13 (including PYID) in a grid, and clicking the Sequence button - move the PYID column to the top of the sorted list, and change its A/D to D (Descending), click OK, then do a find (no QBE entries or limiting header entries). The first record in the grid should be the largest.
* A report could be written that would give you the largest PYID value.
* You could code an Event Rule that would give you the value.
* You could create a new Named Event Rule business function that would give you the value. (Note that there are very specific instructions available on how to create a new library (DLL), and deploying it up through the path codes requires following the instructions carefully. The process is not obvious without the instructions...)

A quick search of business functions does not reveal an existing BF in OW/XE 7333. Hope one of those suggestions helps.

 

[jolly]

The most efficient way would be to add a descending index on F03B13.PYID, then do a select and fetch using that index.

 

[peterbruce]

JDEOW1,

In our system PYID in F03B13 seems to be connected to next numbers 03B/10. But the PYID in F0413 does not seem to be connected to a Next Number.

Hope this helps.

 

[jdeow1]

When an entry is made using P0413M A/P Manual Payments how is the PYID generated??Is there any other way to retrieve Max PYID of F0413/F0414.
Thankx

 

[Massimo P]

You can use BSFN X04131