Export Mapping - Accounts Payable

The Accounts Payable export will include reconciled Vendor Order and Purchase by Invoice transactions, and Vendor Returns but will exclude open ‘Accrual’ PBI transactions. Users will have the option to include or exclude transactions for "Internal" vendors.   {Note}Closed: Physically Reconciled vendor orders expecting an e-invoice will not be exported until the e-invoice has been received.

For Cruise companies, the user can choose whether to export consolidated vendor orders after Consolidation or Reconcile but the export will NOT include Warehouse Orders (these will be available in the Accounts Receivable export).

Accounts Payable data will be exported at the General Ledger account level and can be exported in sets of header/detail records or just detail records.

File mapping for this export can only be created by a corporate user associated with a User Group that has the "Export Mapping - Accounts Payable - Add/Delete/Save" control enabled.  A user with just the "Export Mapping - Accounts Payable - View" permission will be able to view but not create or edit this file type.

 

  1. Under the Interfaces menu, click Export Mapping.
  2. To create a new mapping, click the Plus (Add) icon, click the Export Name link to edit an exiting mapping, or click on a mapping row and click the Pages (Copy) icon to copy and modify it.

On the Export Detail tab:

  1. In the Export Type drop-down, select 'Accounts Payable'.
  2. Enter an Export Name and Export Description.
  3. Select the following from the appropriate drop-downs:
  • Date Format - Determines the format used for all file component dates; this does not apply to a date used in the file name.
  • Number Format - Select '0000.00' or '0000,00'; the latter cannot be used if "Field Delimiter" = ' , ' (comma).
  • Negative Numbers (format) - Select '( )' or ' - '
  • Decimal Places - Choose from '0' to '4'
  • Time Format - Determines the format used for all file component times; this does not apply to time used in the file name.
  • File Extension - Select '.csv', .dat' or '.txt
  • Field Delimiter Type - Select 'Variable Width' or 'Fixed Width'
  • Field Delimiter - Select ' , ' (comma), ' ~ ' (tilde), ' _' (underscore), 'Tab', or 'Other'.  If 'Other', a field will appear to the right to specify a character. This field will be disabled if "Field Delimiter Type" = 'Fixed Width'.
  • File Name Delimiter Type - Select 'Variable Width' or 'Fixed Width'
  • File Name Delimiter - Select ' , ' (comma), ' ~ ' (tilde), ' _' (underscore), or 'Other'. If 'Other', a field will appear to the right to specify a character. This field will be disabled if "File Name Delimiter Type" = 'Fixed Width'.
  • File Name Date Format - Determines the format used for the date component of the file name.
  • File Name Time Format - Determines the format used for the time component of the file name.

In the Export Preferences section:

  1. Check the following preference settings, as applicable:
  • Export zero values in file - If checked, the export file will include '0' values.
  • Auto-Generate AP Export Credits/Debits - If checked, the application automatically generates an extra column in the export to indicate whether a credit is due from or a debit is owed to the vendor based on discrepancies between the Physical vs. Invoice Quantity and/or the Contract vs. Invoice Price on reconciled vendor orders. This give the accounting system a "heads-up" concerning how much the vendor is actually owed.
  • Exclude Transactions with Check Number - If checked, the export file will not include transactions (VO and PBI) that have a check number uploaded.
  • Exclude Transactions with Payment Information - If checked, the export file will not include transactions (VO and PBI) that have payment information uploaded.
  • Export Transactions for Internal Vendors - If checked, the export file will include these transactions.
  • Export Transactions for Non-COD Vendors - If checked, the export file will include these transactions.
  • Export Transactions for COD Vendors - If checked, the export file will include these transactions.
  • Include Vendor Return Transactions - If checked, the export file will include these transactions.
  • Export Consolidated Vendor Orders at "Consolidated" or "Reconcile" (Cruise only) - Choose a radio button to determine which status the orders must be at to be included in the export file.
  • Export Accounts Payable By
  • Day - Specific records for a period must be selected during the export process. These may be in posted or unposted periods.
  • Post - All records for the selected post period will be exported.
  1. Click the Disk (Save) icon before proceeding.

On the Export File Components tab:

  1. Click the Plus (Add) icon to add a row and select a component Type from the drop-down. For this mapping, the 'File Name' and 'Transaction Detail' options are required. Additional component options include: 'File Header', 'Transaction Header', 'File Summary', and 'Transaction Product'.
  2. Enter a Record Name and Record Description for each component type. Then click the Disk (Save) icon before proceeding.
  3. To define component details, click on a row and then click the Mapping button to open the mapping details pop-up window.
  4. Click the Plus (Add) icon to add a row, then define the mapping fields for each component Type as follows.
  • All types include the following fields:
  • Sequence - Determines the order of the fields in the file. (Hint: When editing, a decimal value can be entered to reorder the sequence, instead of changing the sequence of each entry.)
  • Export Field - Select a Field Name from the drop-down.
  • Static Text - Enter text here if this option is selected as the "Export Field".
  • Export Field Name - Enter the Field Name as it should appear in the file.
  • The Transaction Header & Detail, File Header & Summary types also include the following fields in the window header:
  • Debit Indicator - If 'Debit/Credit Indicator' is selected as an "Export Field", this will populate the field if the record value is a debit (i.e. - if the actual Invoice amount < 0 prior to removal of sign for export); limited to 20 characters.
  • Credit Indicator - If 'Debit/Credit Indicator' is selected as an "Export Field", this will populate the field if the record value is a credit (i.e. - if the actual Invoice amount is ≥ 0 prior to removal of sign for export); limited to 20 characters.
  • Size - Sets the column size for fixed width files; must be a whole number between '1' and '999'.
  • Justified - Sets the column values to 'Left' or 'Right' justified for fixed width files.
  • Pad - Sets the field padding (e.g. blank space, 0, etc.) for empty characters in fixed width files. If the field has a "Size" of 10 and but only contains 5 characters, the export will fill the remaining spaces with this character; if left blank, the file will leave empty spaces.
  • The Transaction Header & Detail types also include the following fields in the window header:
  • Debit Document Type - If 'Document Type' is selected as an "Export Field", this will populate the field if the record value is a debit; limited to 20 characters.
  • Credit Document Type - If 'Document Type' is selected as an "Export Field", this will populate the field if the record value is a credit; limited to 20 characters.
  • Append to system generated debit invoice number - This entry will be appended to the invoice number in an auto-generated row if the record value is a debit.
  • Append to system generated credit invoice number - This entry will be appended to the invoice number in an auto-generated row if the record value is a credit.
  • Credit Payment Terms (Header only) - If 'Vendor Terms' is selected as an "Export Field", this will populate the field if the "Terms" field in the Vendor setup screen is not populated; limited to 20 characters.  {Note}Closed: The "Terms" field in the Vendor setup screen is limited to 6 characters.
  • Tax Line Indicator (Detail only) - If 'Tax Line Indicator' is selected as an "Export Field", this will populate the field; limited to 20 characters.

If necessary, you can click on a new row and click the Trash Can (Delete) icon to delete the entry if it is not needed.

  1. Click the Disk (Save) icon before proceeding.
  2. Click the X (Close) icon to close the pop-up window.
  3. Check the Active box to activate this component type.
  4. Repeat steps 8-14 for each component row to add.  If necessary, you can click on a new row and click the Trash Can (Delete) icon to delete the entry if it is not needed.
  5. Click the Disk (Save) icon.
  6. Click on the Export Details tab and check the Active box to activate this mapping scheme.  See Minimum Requirements for activation. 
  7. Click the Disk (Save) icon, then click the X (Close) icon.

  

 

Related Topics Link IconRelated Topics