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 is automatically 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.
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] |
|
|
AUTILIS [AUS] |
|
|
BANK [BAN] |
|
|
BID [BID] |
Bank ID statement |
|
BPARTNER [BPR] |
|
|
BPCUSTOMER [BPC] |
|
|
BPSUPPLIER [BPS] |
|
|
CACCE [CCE] |
|
|
CADSP [DSP] |
|
|
COMPANY [CPY] |
|
|
FACILITY [FCY] |
|
|
FISCALYEAR [FIY] |
|
|
GACCCODE [CAC] |
|
|
GACCDENCOD [CDA] |
|
|
GACCDUDATE [DUD] |
Open items |
|
GACCENTRY [HAE] |
Accounting entries |
|
GACCOUNT [GAC] |
|
|
PAYLOT [PYL] |
Entry batch |
|
PAYMENTA [PYA] |
Analytical payment lines |
|
PAYMENTD [PYD] |
Payment lines |
|
PAYMENTH [PYH] |
Payment header |
|
PERIOD [PER] |
Periods |
|
PORDER [POH] |
|
|
SORDER [SOH] |
|
|
TABCHANGE [TCH] |
Currency rate table |
|
TABCOUAFF [TCA] |
|
|
TABCOUNTRY [TCY] |
|
|
TABCUR [TCU] |
|
|
TABPAYTYP [TPY] |
|
|
TABUNIT [TUN] |
|
|
TABVAT [TVT] |