dataitem("Sales Line"; "Sales Line")
{
DataItemLink = "Document Type" = field("Document Type"),
"Document No." = field("No.");
DataItemLinkReference = "Sales Header";
DataItemTableView = sorting("Document Type", "Document No.", "Line No.");
trigger OnPreDataItem()
begin
CurrReport.Break();
end;
}
dataitem(RoundLoop; Integer)
{
DataItemTableView = sorting(Number);
column(SalesLineAmt; TempSalesLine."Line Amount")
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(Desc_SalesLine; "Sales Line".Description)
{
}
column(NNCSalesLineLineAmt; NNC_SalesLineLineAmt)
{
}
column(NNCSalesLineInvDiscAmt; NNC_SalesLineInvDiscAmt)
{
}
column(NNCTotalLCY; NNC_TotalLCY)
{
}
column(NNCVATAmt; NNC_VATAmt)
{
}
column(NNCPmtDiscOnVAT; NNC_PmtDiscOnVAT)
{
}
column(NNCTotalInclVAT2; NNC_TotalInclVAT2)
{
}
column(NNCVatAmt2; NNC_VatAmt2)
{
}
column(NNCTotalExclVAT2; NNC_TotalExclVAT2)
{
}
column(VATBaseDisc_SalesHeader; "Sales Header"."VAT Base Discount %")
{
}
column(ShowInternalInfo; ShowInterInf)
{
}
column(No2_SalesLine; "Sales Line"."No.")
{
}
column(Qty_SalesLine; "Sales Line".Quantity)
{
}
column(UnitofMeasure_SalesLine; "Sales Line"."Unit of Measure")
{
IncludeCaption = false;
}
column(UnitPrice_SalesLine; "Sales Line"."Unit Price")
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 2;
}
column(LineDiscount_SalesLine; "Sales Line"."Line Discount %")
{
}
column(LineAmt_SalesLine; "Sales Line"."Line Amount")
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(AllowInvDisc_SalesLine; "Sales Line"."Allow Invoice Disc.")
{
IncludeCaption = false;
}
column(LineDiscount_SalesLineAmount; "Sales Line"."Line Discount Amount")
{
}
column(VATIdentifier_SalesLine; "Sales Line"."VAT Identifier")
{
}
column(Type_SalesLine; Format("Sales Line".Type))
{
}
column(No_SalesLine; "Sales Line"."Line No.")
{
}
column(AllowInvoiceDisYesNo; Format("Sales Line"."Allow Invoice Disc."))
{
}
column(SalesLineInvDiscAmount; TempSalesLine."Inv. Discount Amount")
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(TotalText; TotalText)
{
}
column(SalesLineLineAmtInvDiscAmt; TempSalesLine."Line Amount" - TempSalesLine."Inv. Discount Amount")
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(SalesLineTaxAmount; 0)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(ChargesAmount; ChargesAmount)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(OtherTaxesAmount; OtherTaxesAmount)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(TotalInclVATText; TotalInclVATText)
{
}
column(TotalAmount; TotalAmount)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(NNCSalesLineExciseAmt; NNC_SalesLineExciseAmt)
{
}
column(NNCSalesLineTaxAmt; NNC_SalesLineTaxAmt)
{
}
column(NNCSalesLineSvcTaxAmt; NNC_SalesLineSvcTaxAmt)
{
}
column(NNCSalesLineSvcTaxeCessAmt; NNC_SalesLineSvcTaxeCessAmt)
{
}
column(NNCSalesLineSvcSHECessAmt; NNC_SalesLineSvcSHECessAmt)
{
}
column(NNCSalesLineTDSTCSSHECESS; NNC_SalesLineTDSTCSSHECESS)
{
}
column(VATDiscountAmount; -VATDiscountAmount)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(TotalExclVATText; TotalExclVATText)
{
}
column(VATBaseAmount; VATBaseAmount)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(VATAmtLineVATAmtText; TempVATAmountLine.VATAmountText())
{
}
column(VATAmount1; VATAmount)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(TotalAmountInclVAT; TotalAmountInclVAT)
{
AutoFormatExpression = "Sales Header"."Currency Code";
AutoFormatType = 1;
}
column(No_SalesLineCaption; "Sales Line".FieldCaption("No."))
{
}
column(Description_SalesLineCaption; "Sales Line".FieldCaption(Description))
{
}
column(Quantity_SalesLineCaption; "Sales Line".FieldCaption(Quantity))
{
}
column(UnitofMeasure_SalesLineCaption; "Sales Line".FieldCaption("Unit of Measure"))
{
}
column(AllowInvDisc_SalesLineCaption; "Sales Line".FieldCaption("Allow Invoice Disc."))
{
}
column(UnitPriceCaption; UnitPriceCaptionLbl)
{
}
column(DiscPercentCaption; DiscPercentCaptionLbl)
{
}
column(LineDiscCaption; LineDiscCaptionLbl)
{
}
column(SubtotalCaption; SubtotalCaptionLbl)
{
}
column(ExciseAmtCaption; ExciseAmtCaptionLbl)
{
}
column(TaxAmtCaption; TaxAmtCaptionLbl)
{
}
column(ServTaxAmtCaption; ServTaxAmtCaptionLbl)
{
}
column(ChargesAmtCaption; ChargesAmtCaptionLbl)
{
}
column(OtherTaxesAmtCaption; OtherTaxesAmtCaptionLbl)
{
}
column(ServTaxeCessAmtCaption; ServTaxeCessAmtCaptionLbl)
{
}
column(TCSAmtCaption; TCSAmtCaptionLbl)
{
}
column(ServTaxSHECessAmtCaption; ServTaxSHECessAmtCaptionLbl)
{
}
column(VATDisctAmtCaption; VATDisctAmtCaptionLbl)
{
}
column(NNCSalesLineSvcTaxSBCAmt; NNC_SalesLineSvcTaxSBCAmt)
{
}
column(ServTaxSBCAmtCaption; ServTaxSBCAmtCaptionLbl)
{
}
column(NNCSalesLineKKCessAmt; NNC_SalesLineKKCessAmt)
{
}
column(KKCessAmtCaption; KKCessAmtCaptionLbl)
{
}
/* -------------------02/08/2023 starts ------------------------- */
// column(SGSTPercentageVal; SGSTPerc)
// {
// }
// column(CGSTPercentageVal; CGSTPerc)
// {
// }
// column(IGSTPercentageVal; IGSTPerc)
// {
// }
/* -------------------02/08/2023 ends ------------------------- */
/* -------------------04/08/2023 starts ------------------------- */
column(SGSTPercentageVal; SGSTPerc)
{
}
column(CGSTPercentageVal; CGSTPerc)
{
}
column(IGSTPercentageVal; IGSTPerc)
{
}
column(TestVariable; Testvar)
{
}
/* -------------------04/08/2023 ends ------------------------- */
dataitem(DimensionLoop2; Integer)
{
DataItemTableView = sorting(Number)
where(Number = filter(1 ..));
column(DimText1; DimText)
{
}
column(LineDimsCaption; LineDimsCaptionLbl)
{
}
trigger OnAfterGetRecord()
var
GSTSetup: Record "GST Setup";
begin
DimText := GetDimensionText(DimSetEntry2, Number, Continue);
if not Continue then
CurrReport.Break();
if not GSTSetup.Get() then
exit;
if ShowInterInf then begin
GetGSTCaptions(TaxTrnasactionValue, TempSalesLine, GSTSetup);
GetGSTAmounts(TaxTrnasactionValue, TempSalesLine, GSTSetup);
TestVar := CheckGSTDoc("Sales Line");
TotalAmount := NNC_SalesLineLineAmt - NNC_SalesLineInvDiscAmt + NNC_SalesLineExciseAmt + NNC_SalesLineTaxAmt +
NNC_SalesLineSvcTaxAmt + NNC_SalesLineSvcTaxeCessAmt + ChargesAmount +
OtherTaxesAmount +
NNC_SalesLineTDSTCSSHECESS + NNC_SalesLineSvcSHECessAmt +
NNC_SalesLineSvcTaxSBCAmt + NNC_SalesLineKKCessAmt;
end;
end;
Share
Report
187
All responses (
Answers (
