Column mapping: Ap aging

Mappings · approved version 1

Canonical fields and suggestions

Canonical fields
Field	Required	Approved source	Suggested source	Notes
party_code	required	Vendor ID	Vendor ID(synonym)	—
kind	required	Type	Type(synonym)	map the column's values to: document, unapplied_payment
reference	required	Num	Num(synonym)	—
item_date	required	Date	Date(synonym)	63 values also read as DD/MM/YYYY; confirm
currency	required	Currency	Currency(exact)	—
functional_open_amount	required	Open Balance (USD)	—	—
due_date	optional	Due Date	Due Date(exact)	74 values also read as DD/MM/YYYY; confirm
party_name	optional	Vendor	Vendor(synonym)	—

Unmatched columns: Current, 1 - 30, 31 - 60, 61 - 90, > 90, Open Balance (USD). Start from the suggestion

Edit and preview

Mapping (JSON)

{
  "fields": {
    "currency": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "currency"
        }
      ],
      "source": "Currency"
    },
    "due_date": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "empty_to_null"
        },
        {
          "step": "parse_date",
          "format": "MM/DD/YYYY"
        }
      ],
      "source": "Due Date",
      "required": false
    },
    "functional_open_amount": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_decimal",
          "thousands_separator": ","
        }
      ],
      "source": "Open Balance (USD)"
    },
    "item_date": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_date",
          "format": "MM/DD/YYYY"
        }
      ],
      "source": "Date"
    },
    "kind": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "value_map",
          "mapping": {
            "Bill": "document",
            "Payment": "unapplied_payment"
          }
        }
      ],
      "source": "Type"
    },
    "party_code": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Vendor ID"
    },
    "party_name": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Vendor"
    },
    "reference": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Num"
    }
  },
  "exclude_rows_where_blank": [
    "Vendor ID"
  ]
}

View-only in public demo

Preview a mapping to propose it.

Versions

Version 1 approvedchange request