Remove blank lines in dataport

Aravindh_Navision · 2011-08-26

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 · 2011-08-26

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

Aravindh_Navision · 2011-08-26

Mohana,

I gave conditions also like..

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

It is not working

mohana_cse06 · 2011-08-26

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

Aravindh_Navision · 2011-08-26

Yeah.. I did that too..

mohana_cse06 · 2011-08-26

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

Aravindh_Navision · 2011-08-26

Yeah.. it contains correct values...

vaprog · 2011-08-26

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 · 2011-08-26

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 · 2011-08-26

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

Thanks,
Aravindh

Aravindh_Navision · 2011-08-30

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

Remove blank lines in dataport

Answers

Categories