Share this link

    What are the validation rules?

    324 5 Created on 2019-09-12 16:01:08; Last updated on 2022-07-01 13:01:10

    Field Name Purchase Order Invoices Purchase Order Credit Notes Non Purchase Order
    Invoices
    Non Purchase Order
    Credit Notes
    Additional Explanation
    Supplier Company Name X X X X -
    Supplier Street X X X X -
    Supplier Tax Number X X X X VAT number when available
    Jacobs Douwe Egberts company Name X X X X -
    Jacobs Douwe Egberts Legal Identifier X X X X This identifier is comprised of the Company Code and the Country where the invoice is being sent. A validation is in place and the accepted format is 0440-NL.
    Jacobs Douwe Egberts VAT X X X X -
    Jacobs Douwe Egberts Street X X X X -
    Document (Invoice/Credit Note) Number X X X X -
    Document (Invoice/Credit Note) Date X X X X -
    Purchase Order Number X Not Mandatory Not Mandatory Not Mandatory The Purchase Order number must be within the range of (5000000000 – 5999999999) Must match PO data available in Tradeshift and has to be against same supplier
    Invoice Number (Billing Reference) Not Applicable X Not Applicable Not Mandatory
    Actual Delivery Date X Not Applicable X Not Applicable Header Level of the invoice
    Buyer Contact ID Not Mandatory Not Mandatory X X -
    Payment Means (Bank Details) X Not Applicable X Not Applicable -
    Tax Point Date
    Mandatory for Prepayment Invoices
    -


    The following information is mandatory for all invoices on Line Level:


    Field Name Purchase Order Invoices Purchase Order Credit Notes Non Purchase Order Invoices Non Purchase Order Credit Notes Additional Explanation
    Purchase Order Number X Not Mandatory Not Mandatory Not Mandatory The Purchase Order number must be within the range of (5000000000 – 5999999999) Must match PO data available in Tradeshift and has to be against same supplier
    Purchase Order Line Number X Not Mandatory Not Mandatory Not Mandatory Must match referenced PO line number
    Currency X X X X The invoice must be issued in the local currency of the supplier. In case another currency is used for the invoice, exchange rate must be included.
    Invoice Line Cost Center Not Mandatory Not Mandatory X X -
    Tax Exemption reason If Applicable If Applicable If Applicable If Applicable If your invoice includes 0% taxes, tax exception reason needs to be provided on each line of the invoice.
    Exchange rate If Applicable If Applicable If Applicable If Applicable If your invoice will be issued in a different currency than the official currency for your country
    Exchange rate Date If Applicable If Applicable If Applicable If Applicable If your invoice will be issued in a different currency than the official currency for your country

    5 people found this helpful.

    Related Articles