/
Purchase Card Statement Import error missing fields

Purchase Card Statement Import error missing fields

Owned by Knowledge Assistant
Dec 12, 2023
1 min read



Description of Issue

When importing PCard statements, receiving error for Missing Fields charge date, post date, amount, vendor name, address line 1, city, state



Context

  • EERP

  • Accounts Payable

  • Purchase Cards

  • Import



Cause

Import file fields are separated by pipes (|) and not commas



Resolution

Replace commas with pipes



Additional Information












Related content

Purchase credit card import
Purchase credit card import
Knowledge Assistant
More like this
PCard import preview errors not displaying issues in Red text and not populating missing fields column
PCard import preview errors not displaying issues in Red text and not populating missing fields column
Knowledge Assistant
More like this
P-Card Import Failure-unknown error inserting temp table
P-Card Import Failure-unknown error inserting temp table
Knowledge Assistant
More like this
Error encountered while fetching status of purchase card
Error encountered while fetching status of purchase card
Knowledge Assistant
More like this
Purchase card statements imported into the incorrect period
Purchase card statements imported into the incorrect period
Knowledge Assistant
More like this
String or binary data would be truncated error during PCARD import when file contains multiple warnings
String or binary data would be truncated error during PCARD import when file contains multiple warnings
Knowledge Assistant
More like this