Dynamics Community Forum Thread Details

Lines are coming double

I have below code but there are 2 line for Import. It is importing 4 . Blank for each record

Gen. Journal Line - OnAfterImportRecord()

"Journal Template Name" := 'GENERAL';
"Journal Batch Name" := 'TEST';
"Line No." := GetLineNo;

GetLineNo() : Integer
GenJnlLine.SETRANGE("Journal Template Name",'GENERAL');
GenJnlLine.SETRANGE("Journal Batch Name",'TEST');

IF GenJnlLine.FINDLAST THEN
EXIT(GenJnlLine."Line No." + 10000)
ELSE
EXIT(10000);

Posting Date	Document Type	Document No.	Party Type	Party Code	Account Type	Account No.	Description	External Document No.	Vendor Invoice Date	Service Tax Amount	Debit Amount	Credit Amount	Basic Amount For GST	HSN/SAC/Service Tax Group Code	HSN/SAC/Service Tax Entry	HSN/SAC/Service Tax Registration No.	HSN/SAC/Service Tax Base Amount	Type of Inward Supply	RCM Document No.	Ethos Location	Location of Recipient	Vendor Location	CGST Amount	UTGST Amount	IGST Amount	SGST Amount	TDS Nature of Deduction	TDS/TCS Base Amount	Total TDS/TCS Incl. SHE CESS	Mannual TDS	Bal. Account Type	Bal. Account No.	Currency Code	Store Code	Brand Code	HSN/SAC/Service Tax	Mannual Service tax	HSN/SAC/Service Tax Amount	Consignment Note No.	TDS/TCS %	TDS/TCS Amount	Vendor Invoice Date	Amount
31/01/2018	Credit Memo	15	Vendor	V01	Vendor	V01	Abc	HR	09/01/2018	600.00	5,400.00		0	6208	Yes	N\A	5400.00	Inputs		MAH	PUN	DLH	0	0	270.00	0	CO 2%	0	0	No	G/L Account	5004		HR		0	No	270.00		0	0	09/01/2018	5400.00
31/01/2018	Credit Memo	15	Vendor	V01	Vendor	V01	ABC	HR	09/01/2018	400.00	6,000.00		0	6201	Yes	N\A	6000.00	Inputs		MAH	PUN	DLH	0	0	300.00	0	CO 2%	0	0	No	G/L Account	5004		HR		0	No	300.00		0	0	09/01/2018	6000.00

Thanks

Quick Links