{"id":6398,"date":"2022-06-04T13:19:28","date_gmt":"2022-06-04T04:19:28","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=6398"},"modified":"2022-06-06T08:55:43","modified_gmt":"2022-06-05T23:55:43","slug":"jp-pint-0-9-2%e3%81%a7%e6%8f%90%e4%be%9b%e3%81%95%e3%82%8c%e3%82%8b%e6%a4%9c%e7%ae%97%e3%83%ab%e3%83%bc%e3%83%ab","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=6398&lang=en","title":{"rendered":"Can schematron validation rules from JP PINT 0.9.2 make your validation Compliant?"},"content":{"rendered":"

Views: 65<\/p>

Peppol authority of Japan <\/i><\/a> announced new releaseJP PINT 0.9.2 <\/i><\/a>.<\/p>\n

PINT Complience <\/i><\/a> states;<\/p>\n

\n

Senders compliance to PINT based BIS<\/h3>\n

A sending party may claim compliance to the Peppol International model if they send invoices that comply with the rules of the Peppol International Invoice when applied without any specialized rules even if that document may at the same time comply with any set of specialized rules.<\/p>\n

Processing of rules<\/h4>\n

A sender SHALL NOT send messages that are not compliant to the BIS specification identified by the customization.
\nA sender shall validate<\/b> an outgoing message that are in line with the customsation identifier.\n<\/p><\/blockquote>\n

I would like to compare this version with BIS Billing 3.0 to see which range of the validation defined in clause 5.
\nClause 5 Rules defines the validation rules for monetary amounts caliculation. These caliculation rules were fully supported by BIS Billing 3.0.
\nThe BIS Billing 3.0 rules defined in the following two pages.<\/p>\n

EN16931 model bound to UBL<\/a>
\nRules for Peppol BIS 3.0 Billing<\/a><\/p>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ID<\/th>\nBT<\/th>\n5.1 Calculations<\/th>\nJP PINT 0.9.2<\/th>\n<\/tr>\n
ibt-092<\/td>\nDocument level allowance amount
\u8acb\u6c42\u66f8\u30ec\u30d9\u30eb\u306e\u8fd4\u91d1\u91d1\u984d<\/td>\n		ibt-092 = ibt-093 * (ibt-094 \/ 100)<\/td>\nnone<\/td>\n<\/tr>\n
ibt-099<\/td>\nDocument level charge amount
\u8acb\u6c42\u66f8\u30ec\u30d9\u30eb\u306e\u8ffd\u52a0\u8acb\u6c42\u91d1\u984d<\/td>\n		ibt-099 = ibt-100 * (ibt-101 \/ 100)<\/td>\nnone<\/td>\n<\/tr>\n
ibt-106<\/td>\nSum of Invoice line net amount
\u5024\u5f15\u5f8c\u8acb\u6c42\u66f8\u660e\u7d30\u884c\u91d1\u984d\u306e\u5408\u8a08<\/td>\n		ibt-106 = \u03a3 ibt-131<\/td>\nShared<\/td>\n<\/tr>\n
ibt-107<\/td>\nSum of allowances on document level
\u8acb\u6c42\u66f8\u30ec\u30d9\u30eb\u306e\u8fd4\u91d1\u306e\u5408\u8a08<\/td>\n		ibt-107 = \u03a3 ibt-092<\/td>\nShared<\/td>\n<\/tr>\n
ibt-108<\/td>\nSum of charges on document level
\u8acb\u6c42\u66f8\u30ec\u30d9\u30eb\u306e\u8ffd\u52a0\u8acb\u6c42\u306e\u5408\u8a08<\/td>\n		ibt-108 = \u03a3 ibt-099<\/td>\nShared<\/td>\n<\/tr>\n
ibt-109<\/td>\nInvoice total amount without TAX
\u8acb\u6c42\u66f8\u5408\u8a08\u91d1\u984d(\u7a0e\u629c\u304d)<\/td>\n		ibt-109 = ibt-106 – ibt-107 + ibt-108<\/td>\nShared<\/td>\n<\/tr>\n
ibt-110<\/td>\nInvoice total TAX amount
\u8acb\u6c42\u66f8\u6d88\u8cbb\u7a0e\u5408\u8a08\u91d1\u984d<\/td>\n		ibt-110 = \u03a3 ibt-117<\/td>\nShared<\/td>\n<\/tr>\n
ibt-112<\/td>\nInvoice total amount with TAX
\u8acb\u6c42\u66f8\u5408\u8a08\u91d1\u984d(\u7a0e\u8fbc\u307f)<\/td>\n		ibt-112 = ibt-109 + ibt-110<\/td>\nShared<\/td>\n<\/tr>\n
ibt-115<\/td>\nAmount due for payment
\u5dee\u5f15\u8acb\u6c42\u91d1\u984d<\/td>\n		ibt-115 = ibt-112 – ibt-113 + ibt-114<\/td>\nShared<\/td>\n<\/tr>\n
ibt-116<\/td>\nTAX category taxable amount
\u8ab2\u7a0e\u5206\u985e\u6bce\u306e\u8ab2\u7a0e\u57fa\u6e96\u984d<\/td>\n		ibt-116 = \u03a3 ibt-131 – ibt-092 + ibt-099<\/td>\nnone<\/td>\n<\/tr>\n
ibt-117<\/td>\nTAX category tax amount
\u8ab2\u7a0e\u5206\u985e\u6bce\u306e\u6d88\u8cbb\u7a0e\u984d<\/td>\n		ibt-117 = ibt-116 * (ibt-119 \/ 100)
rounded result amount shall be between the floor and the ceiling<\/td>\n		Specific<\/td>\n<\/tr>\n
ibt-131<\/td>\nInvoice line net amount
\u5024\u5f15\u5f8c\u8acb\u6c42\u66f8\u660e\u7d30\u884c\u91d1\u984d(\u7a0e\u629c\u304d)<\/td>\n		ibt-131 = (ibt-146 \/ ibt-149) * ibt-129 – ibt-136 + ibt-141<\/td>\nnone<\/td>\n<\/tr>\n
ibt-136<\/td>\nInvoice line allowance amount
\u8acb\u6c42\u66f8\u660e\u7d30\u884c\u306e\u8fd4\u91d1\u91d1\u984d(\u7a0e\u629c\u304d)<\/td>\n		ibt-136 = ibt-137 * (ibt-138 \/ 100)<\/td>\nnone<\/td>\n<\/tr>\n
ibt-141<\/td>\nInvoice line charge amount,br>\u8acb\u6c42\u66f8\u660e\u7d30\u884c\u306e\u8ffd\u52a0\u8acb\u6c42\u91d1\u984d(\u7a0e\u629c\u304d)<\/td>\nibt-141 = ibt-142 * (ibt-143 \/ 100)<\/td>\nnone<\/td>\n<\/tr>\n
ibt-146<\/td>\nItem net price
\u54c1\u76ee\u5358\u4fa1(\u5024\u5f15\u5f8c)(\u7a0e\u629c\u304d)<\/td>\n		ibt-146 = ibt-148 – ibt-147<\/td>\nnone<\/td>\n<\/tr>\n<\/table>\n

The following table shows the message for each rule.<\/p>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n
ID<\/td>\nBT<\/td>\nrule<\/td>\n<\/tr>\n
ibt-106<\/td>\nSum of Invoice line net amount
\u5024\u5f15\u5f8c\u8acb\u6c42\u66f8\u660e\u7d30\u884c\u91d1\u984d\u306e\u5408\u8a08<\/td>\n		[ibr-co-10]<\/a>
Sum of Invoice line net amount (ibt-106) = \u03a3 Invoice line net amount (ibt-131).<\/td>\n<\/tr>\n
ibt-107<\/td>\nSum of allowances on document level
\u8acb\u6c42\u66f8\u30ec\u30d9\u30eb\u306e\u8fd4\u91d1\u306e\u5408\u8a08<\/td>\n		[ibr-co-11]<\/a>
Sum of allowances on document level (ibt-107) = \u03a3 Document level allowance amount (ibt-092).<\/td>\n<\/tr>\n
ibt-108<\/td>\nSum of charges on document level
\u8acb\u6c42\u66f8\u30ec\u30d9\u30eb\u306e\u8ffd\u52a0\u8acb\u6c42\u306e\u5408\u8a08<\/td>\n		[ibr-co-12]<\/a>
Sum of charges on document level (ibt-108) = \u03a3 Document level charge amount (ibt-099).<\/td>\n<\/tr>\n
ibt-109<\/td>\nInvoice total amount without TAX
\u8acb\u6c42\u66f8\u5408\u8a08\u91d1\u984d(\u7a0e\u629c\u304d)<\/td>\n		[ibr-co-13]<\/a>
Invoice total amount without Tax (ibt-109) = \u03a3 Invoice line net amount (ibt-131) – Sum of allowances on document level (ibt-107) + Sum of charges on document level (ibt-108).<\/td>\n<\/tr>\n
ibt-110<\/td>\nInvoice total TAX amount
\u8acb\u6c42\u66f8\u6d88\u8cbb\u7a0e\u5408\u8a08\u91d1\u984d<\/td>\n		[ibr-co-14]<\/a>
Invoice total Tax amount (ibt-110) = \u03a3 Tax category tax amount (ibt-117).<\/td>\n<\/tr>\n
ibt-112<\/td>\nInvoice total amount with TAX
\u8acb\u6c42\u66f8\u5408\u8a08\u91d1\u984d(\u7a0e\u8fbc\u307f)<\/td>\n		[ibr-co-15]<\/a>
Invoice total amount with Tax (ibt-112) = Invoice total amount without Tax (ibt-109) + Invoice total Tax amount (ibt-110).<\/td>\n<\/tr>\n
ibt-115<\/td>\nAmount due for payment
\u8acb\u6c42\u66f8\u5408\u8a08\u91d1\u984d(\u7a0e\u8fbc\u307f)<\/td>\n		[ibr-co-16]<\/a>
Amount due for payment (ibt-115) = Invoice total amount with Tax (ibt-112) – Paid amount (ibt-113) + Rounding amount (ibt-114).<\/td>\n<\/tr>\n
ibt-117<\/td>\nTAX category tax amount
\u8ab2\u7a0e\u5206\u985e\u6bce\u306e\u6d88\u8cbb\u7a0e\u984d<\/td>\n		[aligned-ibrp-051-jp]<\/a>
Tax category tax amount (ibt-117) = tax category taxable amount (ibt-116) x (tax category rate (ibt-119) \/ 100), rounded to integer. The rounded result amount shall be between the floor and the ceiling.
[aligned-ibrp-e-09]
The tax category tax amount (ibt-117) In a tax breakdown (ibg-23) where the tax category code (ibt-118) equals “”Exempt from tax”” MUST equal 0 (zero).
[aligned-ibrp-g-09]<\/a>
The tax category tax amount (ibt-117) in a tax breakdown (ibg-23) where the tax category code (ibt-118) is “Export” MUST be 0 (zero).
[aligned-ibrp-o-09]<\/a>
The tax category tax amount (ibt-117) in a tax breakdown (ibg-23) where the tax category code (ibt-118) is “Not subject to tax” MUST be 0 (zero).<\/td>\n<\/tr>\n<\/tr>\n<\/table>\n

Since the coding of the [aligned-ibrp-051-jp] listed on the page is difficult to read, you can check the following by indenting the lines separately (though I don’t think it is necessary to apply the round () function to the tax rate).<\/p>\n

In the last part, this rule added the rules when the tax rate is 0 (zero) and when the Tax category code is \u2018O\u2019, when there is no tax rate.<\/p>\n

In addition, cbc: TaxAmount\/@currencyID = \/ubl: Invoice\/cbc: DocumentCurrencyCode\/text () is coded in the select condition of cac:taxSubtotal to which the rule is applied, but this rule is only applicable when the currency is Japanese JPY. I think cbc:TaxAmount\/@currencyID=’JPY’ is better. Since Invoices denominated in foreign currencies are not always rounded down or rounded up.<\/p>\n

Context\r\n  cac:TaxSubtotal[cbc:TaxAmount\/@currencyID=\/ubl:Invoice\/cbc:DocumentCurrencyCode\/text()]\r\nTest\r\n  (\r\n    (cac:TaxCategory\/normalize-space(upper-case(cbc:ID)) != 'O') and \r\n    (\r\n      (\r\n        round(cac:TaxCategory\/xs:decimal(cbc:Percent)) != 0 and \r\n        (\r\n          xs:decimal(cbc:TaxAmount) >= \r\n          floor(\r\n            xs:decimal(cbc:TaxableAmount) * (cac:TaxCategory\/xs:decimal(cbc:Percent) div 100)\r\n          )\r\n        ) and \r\n        (\r\n          xs:decimal(cbc:TaxAmount) <= \r\n          ceiling(\r\n            xs:decimal(cbc:TaxableAmount) * (cac:TaxCategory\/xs:decimal(cbc:Percent) div 100)\r\n          )\r\n        )\r\n      ) or \r\n      (\r\n        round(cac:TaxCategory\/xs:decimal(cbc:Percent)) = 0 and \r\n        (xs:decimal(cbc:TaxAmount) = 0)\r\n      )\r\n    )\r\n  ) or \r\n  (\r\n    not(cac:TaxCategory\/cbc:Percent) and \r\n    (\r\n      cac:TaxCategory\/normalize-space(upper-case(cbc:ID)) = 'O'\r\n    ) and \r\n    (xs:decimal(cbc:TaxAmount) = 0)\r\n  )<\/pre>\n
Compared to JP JPINT 0.9.2, the following BIS Billing 3.0 table shows that all validation rules are provided for all monetary calculations.<\/p>\n
A rounding rule for the tax amount calculation for each tax category code is provided, but no following underlying amounts rule is provided.<\/p>\n
Validation rules for ibt-116 TAX category taxable amount, ibt-131 Invoice line net amount, and ibt-146 Item net price were provided with BIS Billing 3.0. Without these fundamental validation rule, even if a sender validate an outgoing message with provided schematron files that are in line with the customsation identifier, a sender CAN NOT claim that he never sends messages that are not compliant to the BIS specification identified by the customization.<\/p>\n
If each service provider (C2 \/ C3) or end user (C1 \/ C4) are asked to achieve this compliance requirement with their own additional validation functionality with their own software. This additional requirement not only deviates from the standardization intent, but  this also may require them unintentionally investmants in compliance. These monetary amounts validation rules were provided completely free of charge in BIS Billing 3.0.<\/p>\n
I hope that it will be improved in the next revision.<\/p>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ID<\/th>\nBT<\/th>\nBIS Billing 3.0<\/th>\n<\/tr>\n
ibt-092<\/td>\nDocument level allowance amount<\/td>\nPEPPOL-EN16931-R040<\/a>
Allowance\/charge amount must equal base amount * percentage\/100 if base amount and percentage exists<\/td>\n<\/tr>\n
ibt-099<\/td>\nDocument level charge amount<\/td>\nPEPPOL-EN16931-R040<\/a>
Allowance\/charge amount must equal base amount * percentage\/100 if base amount and percentage exists<\/td>\n<\/tr>\n
ibt-106<\/td>\nSum of Invoice line net amount<\/td>\nBR-CO-10<\/a>
Sum of Invoice line net amount (BT-106) = \u03a3 Invoice line net amount (BT-131).<\/td>\n<\/tr>\n
ibt-107<\/td>\nSum of allowances on document level<\/td>\nBR-CO-11<\/a>
Sum of allowances on document level (BT-107) = \u03a3 Document level allowance amount (BT-92).<\/td>\n<\/tr>\n
ibt-108<\/td>\nSum of charges on document level<\/td>\nBBR-CO-12<\/a>
Sum of charges on document level (BT-108) = \u03a3 Document level charge amount (BT-99).<\/td>\n<\/tr>\n
ibt-109<\/td>\nInvoice total amount without TAX<\/td>\nBR-CO-13<\/a>
Invoice total amount without VAT (BT-109) = \u03a3 Invoice line net amount (BT-131) – Sum of allowances on document level (BT-107) + Sum of charges on document level (BT-108).<\/td>\n<\/tr>\n
ibt-110<\/td>\nInvoice total TAX amount<\/td>\nBR-CO-14<\/a>
Invoice total VAT amount (BT-110) = \u03a3 VAT category tax amount (BT-117).<\/td>\n<\/tr>\n
ibt-112<\/td>\nInvoice total amount with TAX<\/td>\nBR-CO-15<\/a>
Invoice total amount with VAT (BT-112) = Invoice total amount without VAT (BT-109) + Invoice total VAT amount (BT-110).<\/td>\n<\/tr>\n
ibt-115<\/td>\nAmount due for payment<\/td>\nBR-CO-16<\/a>
Amount due for payment (BT-115) = Invoice total amount with VAT (BT-112) -Paid amount (BT-113) +Rounding amount (BT-114).<\/td>\n<\/tr>\n
ibt-116<\/td>\nTAX category taxable amount<\/td>\nBR-S-08<\/a>
For each different value of VAT category rate (BT-119) where the VAT category code (BT-118) is “Standard rated”, the VAT category taxable amount (BT-116) in a VAT breakdown (BG-23) shall equal the sum of Invoice line net amounts (BT-131) plus the sum of document level charge amounts (BT-99) minus the sum of document level allowance amounts (BT-92) where the VAT category code (BT-151, BT-102, BT-95) is “Standard rated” and the VAT rate (BT-152, BT-103, BT-96) equals the VAT category rate (BT-119).<\/td>\n<\/tr>\n
ibt-117<\/td>\nTAX category tax amount<\/td>\nBR-CO-17<\/a>
VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) \/ 100), rounded to two decimals.
BR-S-09<\/a>
The VAT category tax amount (BT-117) in a VAT breakdown (BG-23) where VAT category code (BT-118) is “Standard rated” shall equal the VAT category taxable amount (BT-116) multiplied by the VAT category rate (BT-119).<\/td>\n<\/tr>\n
ibt-131<\/td>\nInvoice line net amount<\/td>\nPEPPOL-EN16931-R120<\/a>
Invoice line net amount MUST equal (Invoiced quantity * (Item net price\/item price base quantity) + Sum of invoice line charge amount – sum of invoice line allowance amount<\/td>\n<\/tr>\n
ibt-136<\/td>\nInvoice line allowance amount<\/td>\nPEPPOL-EN16931-R040<\/a>
Allowance\/charge amount must equal base amount * percentage\/100 if base amount and percentage exists<\/td>\n<\/tr>\n
ibt-141<\/td>\nInvoice line charge amount<\/td>\nPEPPOL-EN16931-R040<\/a>PEPPOL-EN16931-R040
Allowance\/charge amount must equal base amount * percentage\/100 if base amount and percentage exists<\/td>\n<\/tr>\n
ibt-146<\/td>\nItem net price<\/td>\nPEPPOL-EN16931-R046<\/a>
Item net price MUST equal (Gross price – Allowance amount) when gross price is provided.<\/td>\n<\/tr>\n<\/table>\n
BIS Billing 3.0 defines validation of ibt-116 TAX category taxable amount as follows;
\nBR-S-08 (fatal)
\nFor each different value of VAT category rate (BT-119) where the VAT category code (BT-118) is “Standard rated”, the VAT category taxable amount (BT-116) in a VAT breakdown (BG-23) shall equal the sum of Invoice line net amounts (BT-131) plus the sum of document level charge amounts (BT-99) minus the sum of document level allowance amounts (BT-92) where the VAT category code (BT-151, BT-102, BT-95) is “Standard rated” and the VAT rate (BT-152, BT-103, BT-96) equals the VAT category rate (BT-119).<\/p>\n
where context targets cac:TaxSubtotal\/cac:TaxCategory and defines test as folllows.
\n\/*\/cac:TaxTotal\/cac:TaxSubtotal\/cac:TaxCategory[normalize-space(cbc:ID)=’S’][cac:TaxScheme\/normalize-space(upper-case(cbc:ID))=’VAT’]<\/p>\n
every $rate in xs:decimal(cbc:Percent) satisfies (\r\n  (\r\n    (\r\n      exists(\/\/cac:InvoiceLine[cac:Item\/cac:ClassifiedTaxCategory\/normalize-space(cbc:ID)='S'][cac:Item\/cac:ClassifiedTaxCategory\/xs:decimal(cbc:Percent=$rate]) or\r\n      exists(\/\/cac:AllowanceCharge[cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate])\r\n    ) and\r\n    (\r\n      (\r\n        ..\/xs:decimal(cbc:TaxableAmount - 1) < \r\n        (\r\n          sum(..\/..\/..\/cac:InvoiceLine[cac:Item\/cac:ClassifiedTaxCategory\/normalize-space(cbc:ID)='S'][cac:Item\/cac:ClassifiedTaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:LineExtensionAmount)) +\r\n          sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=true()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount)) -\r\n          sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=false()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount))\r\n        )\r\n      ) and\r\n      (\r\n        ..\/xs:decimal(cbc:TaxableAmount + 1) > \r\n        (\r\n          sum(..\/..\/..\/cac:InvoiceLine[cac:Item\/cac:ClassifiedTaxCategory\/normalize-space(cbc:ID)='S'][cac:Item\/cac:ClassifiedTaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:LineExtensionAmount)) +\r\n          sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=true()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount)) -\r\n          sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=false()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount))\r\n        )\r\n      )\r\n    )\r\n  ) or\r\n  (\r\n    exists(\/\/cac:CreditNoteLine[cac:Item\/cac:ClassifiedTaxCategory\/normalize-space(cbc:ID)='S'][cac:Item\/cac:ClassifiedTaxCategory\/xs:decimal(cbc:Percent)=$rate]) or\r\n    exists(\/\/cac:AllowanceCharge[cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate])\r\n  ) and\r\n  (\r\n    (\r\n      ..\/xs:decimal(cbc:TaxableAmount - 1) < \r\n      (\r\n        sum(..\/..\/..\/cac:CreditNoteLine[cac:Item\/cac:ClassifiedTaxCategory\/normalize-space(cbc:ID)='S'][cac:Item\/cac:ClassifiedTaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:LineExtensionAmount)) +\r\n        sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=true()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount)) -\r\n        sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=false()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount))\r\n      )\r\n    ) and\r\n    (\r\n      ..\/xs:decimal(cbc:TaxableAmount + 1) > \r\n      (\r\n        sum(..\/..\/..\/cac:CreditNoteLine[cac:Item\/cac:ClassifiedTaxCategory\/normalize-space(cbc:ID)='S'][cac:Item\/cac:ClassifiedTaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:LineExtensionAmount)) +\r\n        sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=true()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount)) -\r\n        sum(..\/..\/..\/cac:AllowanceCharge[cbc:ChargeIndicator=false()][cac:TaxCategory\/normalize-space(cbc:ID)='S'][cac:TaxCategory\/xs:decimal(cbc:Percent)=$rate]\/xs:decimal(cbc:Amount))\r\n      )\r\n    )\r\n  )\r\n)<\/pre>\n
For ibt-131 net invoice line amount, the slack () function is used in the invoice line amount (excluding tax) validation rule as follows:<\/p>\n
Context\r\n  cac:InvoiceLine | cac:CreditNoteLine\r\nTest\r\n  u:slack($lineExtensionAmount, \r\n  (\r\n    $quantity * ($priceAmount div $baseQuantity)) + \r\n    $chargesTotal - \r\n    $allowancesTotal,\r\n    0.02\r\n  )<\/pre>\n
The slack() function is following XSL function.<\/p>\n
<function xmlns=\"http:\/\/www.w3.org\/1999\/XSL\/Transform\" name=\"u:slack\" as=\"xs:boolean\">\r\n    <param name=\"exp\" as=\"xs:decimal\"\/>\r\n    <param name=\"val\" as=\"xs:decimal\"\/>\r\n    <param name=\"slack\" as=\"xs:decimal\"\/>\r\n    <value-of select=\"\r\n        xs:decimal($exp + $slack) &gt;= $val and \r\n        xs:decimal($exp - $slack) &lt;= $val\r\n    \"\/>\r\n<\/function><\/pre>\n
It is determined whether the amount to be compared and the amount of the check result are within the range of \u00b1 slack value. In the case of foreign currency, the slack value declared is usually 0.02 because there are two digits after the decimal point. If the difference between the check result and the comparison target amount is within this range, it is judged to be a correct calculation. In Japanese yen, the slack value may be 2 because the normal monetary amount is expressed as an integer.<\/p>\n
This article is based on the following sources:
\nDownloaded files from Japan PINT Invoice Version 0.9.2 Download resources button.
\n\"\"<\/a>
\nand Peppol BIS Billing 3.0 Home page.
\n\"\"<\/a><\/p>\n
I listed the result of tree command for unzipped directory. The schematron file listed above is the Shared rule and the below is the Specific(Aligned).
\n    \u251c\u2500\u2500 schematron
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 PINT-UBL-validation-preprocessed.sch
\n    \u2502\u00a0\u00a0 \u2514\u2500\u2500 PINT-jurisdiction-aligned-rules.sch
\n    \u251c\u2500\u2500 semantic-model.yaml
\n    \u2514\u2500\u2500 syntax-binding.yaml<\/p>\n
Files included in the downloaded directory contains yaml files corresponding to the code list, the Semantic model page, and the Syntax binding page. Unfotunately XSLT file contained in the previous download is not included in this directory. Please make sure to update customizationId in XSLT file, if you want to use previous file.<\/p>\n
pint-jp-resources-dev pontsoleil$ tree .
\n.
\n\u251c\u2500\u2500 common
\n\u2502\u00a0\u00a0 \u2514\u2500\u2500 docs
\n\u2502\u00a0\u00a0     \u251c\u2500\u2500 bis.pdf
\n\u2502\u00a0\u00a0     \u251c\u2500\u2500 compliance.pdf
\n\u2502\u00a0\u00a0     \u2514\u2500\u2500 release-notes.pdf
\n\u2514\u2500\u2500 trn-invoice
\n    \u251c\u2500\u2500 codelist
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 Aligned-TaxCategoryCodes.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 Aligned-TaxCategoryCodes.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 Aligned-TaxExemptionCodes.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 Aligned-TaxExemptionCodes.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 ICD.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 ICD.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 ISO3166.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 ISO3166.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 ISO4217.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 ISO4217.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 MimeCode.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 MimeCode.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 SEPA.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 SEPA.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL1001-inv.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL1001-inv.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL1153.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL1153.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL2005.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL2005.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL4461.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL4461.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL5189.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL5189.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL7143.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL7143.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL7161.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNCL7161.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNECERec20.gc
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 UNECERec20.yaml
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 eas.gc
\n    \u2502\u00a0\u00a0 \u2514\u2500\u2500 eas.yaml
\n    \u251c\u2500\u2500 schematron
\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 PINT-UBL-validation-preprocessed.sch
\n    \u2502\u00a0\u00a0 \u2514\u2500\u2500 PINT-jurisdiction-aligned-rules.sch
\n    \u251c\u2500\u2500 semantic-model.yaml
\n    \u2514\u2500\u2500 syntax-binding.yaml<\/p>\n","protected":false},"excerpt":{"rendered":"
Views: 65Peppol authority of Japan announced new releaseJP PINT 0.9.2 . PINT Complience states; Senders compli […]<\/p>\n","protected":false},"author":2,"featured_media":6373,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[64,57],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/6398"}],"collection":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6398"}],"version-history":[{"count":6,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/6398\/revisions"}],"predecessor-version":[{"id":6409,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/6398\/revisions\/6409"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/6373"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}