What is the system variables of document number in General Ledger PLD?

[Former Member]

Dear all,

Would anybody kindly tell me what is the system variables of document number in General Ledger Print Layout Designer?

The default print layout use transaction number (system variables 272), however, my client wants document number to be displayed in the transaction number column.

Regards,

Simon Chiu

[Former Member · Accepted solution]

Hi

The only list available for Supported variables is for the version 2007A and for some specific localizations like Brazil and India.

For the 2007A version the list is available in the following link:

http://service.sap.com/smb/sbo/pld

'How To Use the PLD Variables File in Release 2007 A '

But in general the variables are for documents not for reports.

In this case I believe there's no variable and you may need to fill a requirement in the Forum for that.

Paulo Calado

SAP Business One Forums Team

[Former Member]

If you turn on system information (View>System Information) then run the report and hold the cursor over the field, you will see the variable number (141 in 2007A PL45)

Note that these numbers can change between patches / releases, so will will need to check the print layout after each upgrade.

[Former Member]

Thanks for your kind help.

The client using 2005B PL44. The system variable also display 141. However, when I try this in PLD, the column display blank.

[Former Member]

Hi,

Try to add a database Field, from the Content Tab click combobox Source Type and ALT+Click Table and Look for table OACT, then from the Column combobox choose the Transaction No. Column.

Regards,

Clint

[Former Member]

Thanks for your kind help.

I have tried this method, but the column display blank.

[Former Member]

Hi,

What table did you choose and what column?

Regards,

Clint