Remove blank lines in dataport

Aravindh_Navision

Hi Friends,

Please find the below dataitem structure in dataport.

DataItem	                 Name
-----------------------------------------------
Sales Invoice Header	<Sales Invoice Header>
Sales Invoice Line	         SIL_Tax_1
Sales Invoice Line	         SIL_Tax_2
Sales Invoice Line	         SIL_Tax_3
Sales Invoice Line	         SIL_Tax_4
Sales Invoice Line	         SIL_Other

I am using SIL_Tax_1, SIL_Tax_2, SIL_Tax_3, SIL_Tax_4 for calculating the VAT Amount Totals of 4 different VAT percentages say 0%, 10.50%, 21%, 27% respectively. I need to show only the totals of the available percentages in Sales Invoice Line in the text file.

For example,

In Sales Invoice Line, I am having..

1st record: 0%
2nd record: 21%
3rd record: 0%
4th record: 21%
5th record: 0%
6th record: 0%

I need to add the VAT Amount of 0% and 21 % and show only those 2 lines in the text file and not for 10.5% and 27%. Currently I am getting a blank line for 10.5 % and 27% and those blank lines should be removed in the text file.

Can anyone help in doing this?

Thanks,
Aravindh

mohana_cse06

I am not sure but you can try OnBeforeExportRecord() trigger by checking any condition..

Aravindh_Navision

Mohana,

I gave conditions also like..

if SIL_Tax_1."vat %" <> 21 then
currdataport.break;

It is not working

mohana_cse06

Did you try by moving the above code to OnPreDataItem() trigger?

Aravindh_Navision

Yeah.. I did that too..

mohana_cse06

Make sure that you have right value in SIL_Tax_1."vat %"

Aravindh_Navision

Yeah.. it contains correct values...

vaprog

Aravindh_Navision wrote:

Remove blank lines in dataport

Is it posible these blank lines come form the DataItemSeparator property?
If yes, either modify the property and possibly write seperators to the file yourself as you need, or else modify the dataitem structure to match seperators and calculate VAT sums in your own C/AL loops.

Savatage

did you try

if "your condition" then begin
..do stuff..
end else begin
CurrDataport.SKIP; //instead of BREAK
end;

are you exporting or importing?

Aravindh_Navision

Hi Savatage, I am exporting to text file. Also I tried with your suggestion... Its not working

Thanks,
Aravindh

Aravindh_Navision

Hi Guys,

I found the solution for this issue and just wanted to share with you all that what I did. It is working fine in my case.

I wrote the following code in OnPreDataItem() of SIL_Tax_1, SIL_Tax_2, SIL_Tax_3 and SIL_Tax_4. Since the VAT % always remain sme in my case, I just hardcoded.

SIL_Tax_1 - OnPreDataItem()
SIL_Tax_1.SETRANGE("VAT %",0);
IF SIL_Tax_1.COUNT = 0 THEN
 CurrDataport.BREAK;

SIL_Tax_2 - OnPreDataItem()
SIL_Tax_2.SETRANGE("VAT %",10);
IF SIL_Tax_2.COUNT = 0 THEN
  CurrDataport.BREAK;

SIL_Tax_3 - OnPreDataItem()
SIL_Tax_2.SETRANGE("VAT %",15);
IF SIL_Tax_2.COUNT = 0 THEN
  CurrDataport.BREAK;

SIL_Tax_4 - OnPreDataItem()
SIL_Tax_4.SETRANGE("VAT %",21);
IF SIL_Tax_4.COUNT = 0 THEN
  CurrDataport.BREAK;

Thanks you all..
Aravindh