Grid with BOLinkedObject will NOT open Invoices from 2nd Doc Sequence

[Former Member]

I have a simple form with a grid. It displays either invoices/deliveries/orders which are open.

One of the columns is a LinkedObject to open the document.

The system has multiple document number sequences assign to different users based on the store location. That is Store A is range 10000000 to 1999999 and store 2 is 2000000 to 2999999 etc.

On the form the queries run correctly and the data is all bound etc

If on the list there are 2 documents

e.g. doc number 2 (which was created on the SAP original primary sequence)

and doc number 1000001 (created on Store A range)

The link will open the document 2 but provide an error message when doc number 1000001 is opened

"You are not permitted to preform this action [200-30]"

The addon is UI only not DI components.

This occurs running the addon through both visual studio and when installed.

userObj_SalesForFitting_Grid.Columns.Item("DocNum").Type = SAPbouiCOM.BoGridColumnType.gct_EditText

oEditCol = userObj_SalesForFitting_Grid.Columns.Item("DocNum")

oEditCol.LinkedObjectType = SAPbouiCOM.BoLinkedObject.lf_Invoice

oEditCol.Editable = False

oEditCol.TitleObject.Caption = "Invoice"

What do I need to ammed/change to enable the opening of documents with a non-primary number range.

The other number ranges are in the same group and are functioning on the production system for a year now.

Thanks in advance

[Former Member]

The SQL Statement was quering DocNum with DocEntry it works now