Possible to find the table name for checkbox?

[former_member616714]

Hi everyone, hope you can help.

Running: SAP Business One 9.3 PL: 05

In Business partner master data (Vendor) > Payment Run > Payment Methods

Here I try to check the checkbox ”Include” for multiple lines, but by activating system informations I only get this information:

N [Form=134 Item=217 Pane=8 Column=5 Row=1 Variable=93]

So it seems there is no table for the checkbox "Include" and I have a list of 200 vendors, who need to be checked in four lines each.

Is it possible to use form, item, pane, column, row or variable to find the location of N/Y?

[kothandaraman_nagarajan · Accepted solution]

Hi,

The include field is payment method to run payment wizard. There is no direct table to get value.

Using this query you can find selected payment methods for vendor,

SELECT T0.[CardCode], T1.[PayMethCod], T1.[Descript] FROM OCRD T0 LEFT JOIN OPYM T1 ON T0.[PymCode] = T1.[PayMethCod] WHERE T0.[CardType] = 'S'

Regards,

Nagarajan

[former_member616714]

Found out that the CRD2 table with the field PymCode can be set to the payment method code and then it worked.

Then my next problem is to set which one to be default for each vendor.

[Abdul]

Check the table CRD2 and OCRD you will find the relevant field you have to select the table in query generator and check from field name