Discount amount applying

Clearance and Reporting
1

Dear @idaoud

i have item like

      "itemId": 2,
      "documentId": 101,
      "itemName": "Mouse",
      "taxExclusivePrice": 40.00,
      "quantity": 2.00,
      "vatPercent": 15.00,
      "unitCode": "EA",
      "discount": 5.00,
      "taxAmount": 6.00,
      "taxInclusivePrice": 46.00,
      "unitPrice": 20.00

here the discount is 5, the tax excluded price , unit price is after discount,
so is there any need to mention the discount.
What will do with that discount,

My xml comes like

  <cac:InvoiceLine>
        <cbc:ID>2</cbc:ID>
        <cbc:InvoicedQuantity unitCode="EA">2.00</cbc:InvoicedQuantity>
        <cbc:LineExtensionAmount currencyID="SAR">40.00</cbc:LineExtensionAmount>
        <cac:TaxTotal>
            <cbc:TaxAmount currencyID="SAR">6.00</cbc:TaxAmount>
            <cbc:RoundingAmount currencyID="SAR">46.00</cbc:RoundingAmount>
        </cac:TaxTotal>
        <cac:Item>
            <cbc:Name>Mouse</cbc:Name>
            <cac:ClassifiedTaxCategory>
                <cbc:ID schemeID="UN/ECE 5305" schemeAgencyID="6">S</cbc:ID>
                <cbc:Percent>15.00</cbc:Percent>
                <cac:TaxScheme>
                    <cbc:ID>VAT</cbc:ID>
                </cac:TaxScheme>
            </cac:ClassifiedTaxCategory>
        </cac:Item>
        <cac:Price>
            <cbc:PriceAmount currencyID="SAR">20.00</cbc:PriceAmount>
            <cac:AllowanceCharge>
                <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
                <cbc:AllowanceChargeReason>discount</cbc:AllowanceChargeReason>
                <cbc:Amount currencyID="SAR">5.00</cbc:Amount>
            </cac:AllowanceCharge>
        </cac:Price>
    </cac:InvoiceLine>

there is no effect for unit price, net price or document level values using this discount ?

Please help me

2 
<cac:InvoiceLine>
		<cbc:ID>426591</cbc:ID>		
		<cbc:InvoicedQuantity unitCode="HUR">260.00</cbc:InvoicedQuantity>
		<cbc:LineExtensionAmount currencyID="SAR">5500.00</cbc:LineExtensionAmount>

		//Item Level Discount
		<cac:AllowanceCharge>
			<cbc:ChargeIndicator>false</cbc:ChargeIndicator>
			<cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
			<cbc:AllowanceChargeReason>Discount</cbc:AllowanceChargeReason>
			<cbc:Amount currencyID="SAR">0.04</cbc:Amount>
		</cac:AllowanceCharge>
		
		//Item Level Charge
		<cac:AllowanceCharge>
			<cbc:ChargeIndicator>true</cbc:ChargeIndicator>
			<cbc:AllowanceChargeReasonCode>DL</cbc:AllowanceChargeReasonCode>
			<cbc:AllowanceChargeReason>Charge</cbc:AllowanceChargeReason>
			<cbc:Amount currencyID="SAR">0.00</cbc:Amount>
		</cac:AllowanceCharge>
		
		
		
		<cac:TaxTotal>
			<cbc:TaxAmount currencyID="SAR">825.00</cbc:TaxAmount>
			<cbc:RoundingAmount currencyID="SAR">6325.00</cbc:RoundingAmount>
		</cac:TaxTotal>
		
		<cac:Item>
			<cbc:Name> XYZ Item</cbc:Name>
			<cac:SellersItemIdentification>
				<cbc:ID>A0119</cbc:ID>
			</cac:SellersItemIdentification>
			<cac:ClassifiedTaxCategory>
				<cbc:ID schemeID="UN/ECE 5305" schemeAgencyID="6">S</cbc:ID>
				<cbc:Percent>15.00</cbc:Percent>
				<cac:TaxScheme>
					<cbc:ID schemeID="UN/ECE 5153" schemeAgencyID="6">VAT</cbc:ID>
				</cac:TaxScheme>
			</cac:ClassifiedTaxCategory>
		</cac:Item>
		
		<cac:Price>
			<cbc:PriceAmount currencyID="SAR">211.54</cbc:PriceAmount>
			<cbc:BaseQuantity unitCode="HUR">10</cbc:BaseQuantity>
			
			//Unit Price Level Discount, if Unit Price is already Discounted, you don't need to 
			//Put discount here

			<cac:AllowanceCharge>
				<cbc:ChargeIndicator>false</cbc:ChargeIndicator>
				<cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
				<cbc:AllowanceChargeReason>Discount</cbc:AllowanceChargeReason>
				<cbc:MultiplierFactorNumeric>0.00</cbc:MultiplierFactorNumeric>
				<cbc:Amount currencyID="SAR">0.00</cbc:Amount>
				<cbc:BaseAmount currencyID="SAR">211.54</cbc:BaseAmount>
			</cac:AllowanceCharge>
			
		</cac:Price>
	</cac:InvoiceLine>
3

@Ather
Thanks for helping,

I didn’t get you , give me a simplified example please

4

if UNIT PRICE is already discounted, which is SAR 20.
You don’t need to Provide Discount which you already made and showing Unit Price after discount.

this is what i understand from your Question, if I am making any mistake kindly explain your question.

5

“itemId”: 2,
“documentId”: 101,
“itemName”: “Mouse”,
“taxExclusivePrice”: 40.00,
“quantity”: 2.00,
“vatPercent”: 15.00,
“unitCode”: “EA”,
“discount”: 0.00,
“taxAmount”: 6.00,
“taxInclusivePrice”: 46.00,
“unitPrice”: 20.00

1 Like
6

Thanks @Ather

What is the difference between

//Item Level Discount

and

//Unit Price Level Discount,

Is any of this discount is summarized and showing in document level?

7

Item Level Discount

It’s generally applied after calculating the total amount for the specific item before and than Tax Calculation.

Unit Price Level Discount
This discount is applied specifically to the unit price of an item, meaning it affects the price per individual unit before calculating the total price for the item

Example
Like my Unit Price is SAR 211.54 and i didn’t give any discount on Unit Price
but when i calculate total 211.54 * 260 = 55,000.4 and now i decided to give 0.4 as discount, and then i calculated the Tax on 55,000.

1 Like
8

Thanks @Ather

Understanding, Is this amount listing in document level, means adding all of this discounts (Allowance) then show it in invoice level?

I think no need of it. Is it correct?

9

You are correct. You don’t need it. that is Document Level Discount

10

image
image654Ă—135 9.12 KB

1 Like
11

Thanks for your coordination

12

don’t forget to add

<cbc:AllowanceChargeReasonCode>CODE</cbc:AllowanceChargeReasonCode>

you might get warnings without it.

1 Like
13 
    <cac:LegalMonetaryTotal>
        <cbc:LineExtensionAmount currencyID="SAR">1240.00</cbc:LineExtensionAmount>
        <cbc:TaxExclusiveAmount currencyID="SAR">1240.00</cbc:TaxExclusiveAmount>
        <cbc:TaxInclusiveAmount currencyID="SAR">1426.00</cbc:TaxInclusiveAmount>
        <cbc:AllowanceTotalAmount currencyID="SAR">0.00</cbc:AllowanceTotalAmount>
        <cbc:PrepaidAmount currencyID="SAR">0.00</cbc:PrepaidAmount>
        <cbc:PayableAmount currencyID="SAR">1426.00</cbc:PayableAmount>
    </cac:LegalMonetaryTotal>

if we added any unit price , item, document level discount . Did the

AllowanceTotalAmount

will change?

14

if you add document level discount/charge, than you will have to update the
AllowanceTotalAmount

1 Like
15

Ather i want your help can you contact me

16

@Ather farhanbashir06@gmail.com in bahrain

17

You can contact with me on +97336566162

1 Like