Problem in BaanERP:
If I am in Session whinh3522m000 (Approvals) I see a list of pruchase orders. The Key of the main table of this session consists amongst others out of:
whinh211.orno, whinh211.pono and whin211.seqn.

How can I find the related purchase order line?

The problem is, that whinh211.seqn is not the same as tdpur401.sqnb. The content of whinh211.seqn is (lets say) "1000" but in tdpur401.sqnb it is "0"?!

How is the relationship? Is there any DLL to resolve this?


Thanx

whinh211.orno = PURCHASE ORDER NUMBER
whinh211.pono = POSITION (LINE) NUMBER

tdpur401.sqnb does not seem to be in whinh211 at all.

Hi jcorwine!

there is a relation. The question is, how tdpur401.sqnb and whinh210.seqn are related!

If you use split lines for purchase orders tdpur401.seqb counts the details of the line
tdpur401.seqb = 0 is the total of the following split lines
tdpur401.seqb = 1, 2 etc are the split lines
If you do not use split lines there is only one record with seqb = 0

After maintaining receipts and if inspection is set to yes than in whinh211 a record is created.
whinh211.pono = tdpur401.pono
whinh211.seqn = composed value

In session whinh3522m000 "Approvals" the sequence may look like as follows. In table whinh211.seqn is shown without dots

x.yy.zzz or y.zzz

x = tdpur401.seqb
y = receipt (first, second etc.)
zzz = always 000 in my system

Yours

Jan

(jan.ruppert@web.de)

I forgot to write

whinh211.seqn contains the format x.yy.zzz if there are purchase order split lines
whinh211.seqn contains the format y.zzz if there are no purchase order split lines

Hi Jan,

thanks for support.

This is exactly what I meant.

:p