Import/export template > Module A/P-A/R accounting > Import/export template PAY (Payments) 

Use this template to import or export payments.

For imports:

  • A payment is not imported if the related payment transaction type in Sage X3 does not require approval and the payment to import is not approved. These payments are blocked because the payment approval status cannot be changed post import.
  • Those records not imported are listed in the log file. You need to change the status to approved before being able to import.
  • If the Sign is Revenue, the approval status is automatically set to yes and represented with a 1 in the file, so the payment can be imported.
  • If the Sign is Expense and the related payment transaction requires approval, the approval status isautomatically set to no and represented with a 2 in the file, so the payment can be imported. The payment can then be approved in Sage X3.
  • The payment type and sign are not considered.

For exports:

  • Approved or unapproved payments can be exported.
  • For approved payments, details like approver and date approved are included in the export.
  • Exported payments are listed in the log file.

Prerequisites

Mandatory fields in the template

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

ATABDIV [ADI]

Miscellaneous tables

AUTILIS [AUS]

Users

BANK [BAN]

Bank accounts

BID [BID]

Bank ID statement

BPARTNER [BPR]

Business partner

BPCUSTOMER [BPC]

Customers

BPSUPPLIER [BPS]

Suppliers

CACCE [CCE]

Dimensions

CADSP [DSP]

Analytical allocations

COMPANY [CPY]

Company

FACILITY [FCY]

Sites

FISCALYEAR [FIY]

Fiscal years

GACCCODE [CAC]

Accounting codes

GACCDENCOD [CDA]

Payment attribute

GACCDUDATE [DUD]

Open items

GACCENTRY [HAE]

Accounting entries

GACCOUNT [GAC]

Accounts

PAYLOT [PYL]

Entry batch

PAYMENTA [PYA]

Analytical payment lines

PAYMENTD [PYD]

Payment lines

PAYMENTH [PYH]

Payment header

PERIOD [PER]

Periods

PORDER [POH]

POs

SORDER [SOH]

Sales orders - header

TABCHANGE [TCH]

Currency rate table

TABCOUAFF [TCA]

Sequence No assignments

TABCOUNTRY [TCY]

Country table

TABCUR [TCU]

Currency table

TABPAYTYP [TPY]

Payment transactions

TABUNIT [TUN]

Table of units of measure

TABVAT [TVT]

Tax code table