Vendor Bill
To use the templates, paste the content into the "FIELD MAPPING FOR INBOUND E-DOCUMENT" field of the new E-Document Template creation page.
In the template, while you create, select "ANZ PEPPOL Inbound CDS" from the Inbound Custom Data Source Plug-in Implementation drop down.
If no tax rate is present in for the item in XML reference, then by default, tax code with 0% tax rate will be applied to the item in the bill. This is applicable only if one tax code with tax rate 0% is present in the account.
If there are multiple tax codes of same rates or no tax codes present with specified tax rate, then an error will be thrown. The inbound conversion will be failed.
Limitations:
-
Expenses is not supported in this template; users can change the template and add expenses, if required.
-
Items with vendor code will only be considered for inbound conversion. So, users have to make sure that the items in the XML Reference have vendor code value under the Vendors section of the Purchasing Tab in the item records along with the Vendor's Name. The vendor code should be same as the Item name.
-
Inbound Conversion using PEPPOL for Australia and New Zealand is not supported in SuiteTax accounts.
-
No other language other than English is supported for Inbound Conversion.
-
Multi-Subsidiary vendors are not supported for Inbound Conversion.
S.NO |
JSON Key in Template |
XML Element applied from XML Reference |
Information for the Key |
---|---|---|---|
1 |
tranid |
D:Invoice/cbc:ID |
This key uniquely identifies the Vendor Bill, that is, Reference Number. |
2 |
trandate |
D:Invoice/cbc:IssueDate |
This key displays the issue date of the bill provided by the vendor, that is, Date. The date is in the format of the system preferences set in the account. If the element cbc:IssueDate is missing in the XML reference file then it will throw an error "The issue date XPath for the transaction could not be found in the XML reference file." and If the value of the cbc:IssueDate element in XML Reference file is not in the format YYYY-MM-DD then it will throw an error "The issue date of the transaction in the XML reference file is not in correct format.". |
3 |
duedate |
D:Invoice/cbc:DueDate |
This key displays the payment due date. The date is in the format of the system preferences set in the account. The Bill will be populated only if the XML Reference has relevant value. If the value of the cbc:DueDate element in XML Reference file is not in the format YYYY-MM-DD, you get the error "The due date of the transaction in the XML reference file is in invalid format." |
4 |
memo |
D:Invoice/cbc:Note |
This element displays unstructured note related to the Bill. The Bill will be populated only if the XML Reference has relevant value. |
5 |
currency |
D: |
This key displays the Currency Name in Vendor Bill. The value of this field is derived from the Custom Data Source Plug-in (CDS) used in the template. It retrieves Currency Name from the Currency ISO code present in the XML Reference. Multi Currency feature must be enabled in the account. |
6 |
item |
D:Invoice/cac:InvoiceLine |
This key iterates over all line items in the XML Reference. |
7 |
vendorcode |
D: |
This key displays Vendor Code that is same as the item name. It does not support any other reference apart from item name. Check Limitations section for more details. |
8 |
vendorrate |
D: |
This key displays Vendor Name that is same as the item name. |
9 |
quantity |
D: |
This key displays Quantity of each line item. Quantity is not added if the quantity of each line item is not present in the XML Reference. The element value with a decimal separator (.) or a whole number is valid. Group separator (Thousands separator) or more than one decimal separator is invalid. |
10 |
rate |
D: |
This key displays net price or unit price of the item. It displays the rate of each line item, exclusive of GST after subtracting item price discount. The element value with a decimal separator (.) or (,), or a whole number is valid. Group separator (Thousands separator) or more than one decimal separator is invalid. |
11 |
taxcode |
D: (We are fetching the tax percent and from that we are finding the corresponding tax code in the account) |
This key provides tax codes that is extracted from the tax rate in the XML Reference. [Check the XML Element given in second column]. The tax code which belongs to the specific tax rate for the applicable country. You need to extract the tax codes from this XML Reference: D:
The element value with a decimal separator (.) or (,), or a whole number is valid. Group separator (Thousands separator) or more than one decimal separator is invalid. |
12 |
amount |
D: |
The key displays invoice line net amount. The amount is “net” without GST, that is, inclusiveness of line level allowances and charges along with other relevant taxes. The element value with a decimal separator (.) or (,), or a whole number is valid. Group separator (Thousands separator) or more than one decimal separator is invalid. |
13 |
description |
D: |
This key’s description is taken from the item’s name. You can change the reference in the XML Reference if needed. |
14 |
inventiorydetailreq |
|
This key is a required field for items. The default value is set to ‘False’ for each item. |