G/L entry and G/L Register

hhhhhhhqat

URGENT

i want to export G/L entry records for specific period , i create the data port and add all items i need from G/L fields , How can i add also the Register ( "No." ) from G/L Register table against each entry No.

phondaj

If you need to export only this time,will be easy if you use SQL query direct from DB.

hhhhhhhqat

Yes phondaj ,

i need only for this time ,, if you please can help me for script can get these information by SQL query

Thanks

eyolftho

Create a global field RegisterNo (Type Integer)
Add this to the Dataport field list

create a global record variable Register for the G/L Register table

Code something like this is in OnBeforeExportRecord trigger for the G/L Entry table:

Register.setfilter("To Entry No.",'%1..',"Entry No."); // This will return the associated Register record
Register.find('-');
RegisterNo := Register."No.";

hhhhhhhqat

thanks eyolftho

its give me what i expect ... thanks again ....

hhhhhhhqat

can we add some keys to speed the export , because it take more time specially if i apply filter on posting date for long period.