SBX - Search With Button

SBX - Forum Post Title

Temporary Table

Microsoft Dynamics NAV Forum

jsshivalik asked a question on 10 Aug 2018 11:06 AM
My Badges

Question Status

Verified

Hi

  I have Transfer Shipment Header & Transfer Shipment Line table in a report . I want on after get record in Transfer Shipment header if that record exists in temp table then that data should not be considered. How we can store data in Temporary table and check whether No existing in Temp table or not

Thanks

Reply
Suresh Kulla responded on 10 Aug 2018 1:15 PM
Verified Answer

How you want to load the temporary data ? You need to create a temp record variable and insert the values then use the filters or get statement to check in the temporary table. If exists using currreport.skip statement. Check the standard reports like 10074 where it inserts the invoice line records into a temp table.

Reply
Bodhi Chen responded on 10 Aug 2018 8:46 PM
My Badges
Verified Answer

Report 113 Customer/Item Sales

ValueEntryBuffer is a temp record variable

Reply
jsshivalik responded on 11 Aug 2018 12:42 AM
My Badges

Hi

I don't have 10074 report . Is there any other report

Thanks

Reply
Suresh Kulla responded on 10 Aug 2018 1:15 PM
Verified Answer

How you want to load the temporary data ? You need to create a temp record variable and insert the values then use the filters or get statement to check in the temporary table. If exists using currreport.skip statement. Check the standard reports like 10074 where it inserts the invoice line records into a temp table.

Reply
Bodhi Chen responded on 10 Aug 2018 8:46 PM
My Badges
Verified Answer

Report 113 Customer/Item Sales

ValueEntryBuffer is a temp record variable

Reply

SBX - Two Col Forum

SBX - Migrated JS