Sending Intrastat Data to Avalara VAT Reporting for Purchase Credit Notes

This topic details the setup required in order to send Intrastat data to Avalara VAT Reporting for purchase credit notes.

Creating Lookups from Accounting Payable Credit Note to Supply Chain Management AP Voucher Credit

  1. Go to Setup | Objects and Fields | Object Manager | Payable Credit Note | Fields & Relationships.
  2. Click New.
  3. Select Lookup Relationship.
  4. Click Next.
  5. In the Related To drop-down select AP Voucher Credit.
  6. Click Next.
  7. In the Field Name field, ensure it reads AP_Voucher_Credit.
  8. Click Next | Next | Next | Save.

Creating a New Custom Lookup Field in Payable Credit Note Line Item Object Related to AP Voucher Line Object

  1. Go to Setup | Objects and Fields | Object Manager | Payable Credit Note Line | Fields & Relationships.
  2. Click New.
  3. Select Lookup Relationship.
  4. Click Next.
  5. In the Related To drop-down select AP Voucher Line.
  6. Click Next.
  7. In the Field Name field, ensure it reads AP_Voucher_Line.
  8. Click Next | Next | Next | Save.

Update Fieldset on Payable Credit Note Line Item Object

  1. Go to Setup | Objects and Fields | Object Manager | Payable Credit Note Line | Fieldsets | Manage Product Lines (VAT).
  2. In the Quick Find field enter AP Voucher Line.
  3. Drag-and-drop the field into the In the Field Set section.
  4. Click Save.

Updating Avalara VAT Reporting Integration Custom Metadata to Include Payable Credit Note Mappings

You must ensure that the custom lookup field names created for both Product and Expense match with the mappings provided. For example, in the example below, the field name used for line lookups is AP_Voucher_Line. For more information, see Customizing the Default Mappings.

To copy and paste the JSON content for the entries in the table, see JSON Content.

Source Field

XML Path

Document Type

Required

Country

Child Relationship

Parent Object

c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c

InvoiceProperties/IntrastatDocumentData/CountryDispatch

PCN

TRUE

      

c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Ship_To_Warehouse__r.SCMC__Address__r.SCMC__Country__c

InvoiceProperties/IntrastatDocumentData/CountryArrival

PCN

TRUE

      

c2g__codaPurchaseCreditNoteLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c

InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode

PCN

TRUE

  

c2g__PurchaseCreditNoteLineItems__r

c2g__codaPurchaseCreditNote__c

c2g__codaPurchaseCreditNoteLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c

InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1

PCN

TRUE

  

c2g__PurchaseCreditNoteLineItems__r

c2g__codaPurchaseCreditNote__c

c2g__codaPurchaseCreditNoteLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name

InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1

PCN

TRUE

  

c2g__PurchaseCreditNoteLineItems__r

c2g__codaPurchaseCreditNote__c

c2g__codaPurchaseCreditNoteExpLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c

InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode

PCN

TRUE

  

c2g__PurchaseCreditNoteExpenseLineItems__r

c2g__codaPurchaseCreditNote__c

c2g__codaPurchaseCreditNoteExpLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c

InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1

PCN

TRUE

  

c2g__PurchaseCreditNoteExpenseLineItems__r

c2g__codaPurchaseCreditNote__c

c2g__codaPurchaseCreditNoteExpLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name

InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1

PCN

TRUE

  

c2g__PurchaseCreditNoteExpenseLineItems__r

c2g__codaPurchaseCreditNote__c

c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_State_Province__c

InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch

PCN

  

BE,FR,DE,ES,IT,SK,BG

    

c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c

InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin

PCN

TRUE

      
Copy 
[
  {
    "SourceField": "c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c",
    "XMLPath": "InvoiceProperties/IntrastatDocumentData/CountryDispatch",
    "DocumentType": "PCN",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Ship_To_Warehouse__r.SCMC__Address__r.SCMC__Country__c",
    "XMLPath": "InvoiceProperties/IntrastatDocumentData/CountryArrival",
    "DocumentType": "PCN",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNoteLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode",
    "DocumentType": "PCN",
    "ChildRelationship": "c2g__PurchaseCreditNoteLineItems__r",
    "ParentObject": "c2g__codaPurchaseCreditNote__c",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNoteLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1",
    "DocumentType": "PCN",
    "ChildRelationship": "c2g__PurchaseCreditNoteLineItems__r",
    "ParentObject": "c2g__codaPurchaseCreditNote__c",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNoteLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1",
    "DocumentType": "PCN",
    "ChildRelationship": "c2g__PurchaseCreditNoteLineItems__r",
    "ParentObject": "c2g__codaPurchaseCreditNote__c",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNoteExpLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode",
    "DocumentType": "PCN",
    "ChildRelationship": "c2g__PurchaseCreditNoteExpenseLineItems__r",
    "ParentObject": "c2g__codaPurchaseCreditNote__c",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNoteExpLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1",
    "DocumentType": "PCN",
    "ChildRelationship": "c2g__PurchaseCreditNoteExpenseLineItems__r",
    "ParentObject": "c2g__codaPurchaseCreditNote__c",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNoteExpLineItem__c.AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1",
    "DocumentType": "PCN",
    "ChildRelationship": "c2g__PurchaseCreditNoteExpenseLineItems__r",
    "ParentObject": "c2g__codaPurchaseCreditNote__c",
    "Required": "true"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_State_Province__c",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch",
    "DocumentType": "PCN",
    "Country": "BE,FR,DE,ES,IT,SK,BG"
  },
  {
    "SourceField": "c2g__codaPurchaseCreditNote__c.AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c",
    "XMLPath": "InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin",
    "DocumentType": "PCN",
    "Required": "true"
  }
]

Creating a Payable Credit Note Linked to Corresponding AP Voucher Credit

  1. In Supply Chain Management, create an AP voucher and push it to Accounting. If you do not know how to do this, see Pushing a Single Document to Accounting in the SCM Help. This generates a payable invoice in Accounting.
  2. In Supply Chain Management, void the AP voucher. This generates an AP voucher credit in Supply Chain Management, associated with the AP voucher. If you do not know how to do this, see Voiding an AP Voucher in the SCM Help.
  3. In Accounting, convert the payable invoice into a payable credit note. If you do not know how to do this, see Creating a Credit Note from a Payable Invoice.
  4. In Accounting, edit the AP Voucher Credit field in the payable credit note to associate it with the AP voucher credit. If you do not know how to do this, see Editing Payable Credit Notes.
  5. In Accounting, for each payable credit note line item edit the AP Voucher Line column in order to associate it with the corresponding AP voucher line. If you do not know how to do this, see Payable Credit Note Line Items.