AP Sub-Ledger

In This Topic

Menu Code: APL
Accounting/Finance - Accounts Payable

A searchable list of AP Transactions generated from AP workflows. These transactions feed into the General Ledger via the Posting Assistant.

Transaction Types

The following transaction types are used in AP workflows:

Type	Form	Line Types
APCHK - AP Payments	Pay Invoices	BAL - Balance Entry against cash account PMT - Payment Total to the AP account PMTD - Payment Discount to the Discount account (only if a discount is taken) CRD - Credit Total from the AP account CRTD - Credit Discount from the Discount account (only if a discount is credited)
VOIDC - Void Payment	Void Payments	Same as APCHK. Each VOIDC transaction will reverse the original APCHK transaction.
APINV - AP Invoice	AP Invoice Entry Approve Invoices	BAL - Balance Entry against AP account SALE - Amount from type N lines, normally expenses and specific balance sheet accounts FREIGHT - Amount from type F lines to freight expense account PREPAY - Amount from type P lines to prepay account TAX - Tax amount for type T lines to designated PURCH_TAX account.
VOIDI - Void Invoice	Cancel button on AP Invoice	Same as APINV. Each VOIDI transaction will reverse the original APINV transaction.

Tip: If the JrnlID field is blank then the transaction has NOT yet been posted to the General Ledger.

Zoom Links

Column	Zoom Link
SuppCode	Supplier Entry (SUP), for the specified supplier
Acct	Chart of Accounts (COA), for the specified account
ProjCode	Projects (PRJ), for the selected project
PONo	Purchase Orders (POS), for the selected PO
VoucherNo	AP Invoice Entry (API), for the selected voucher
CheckNo	Browse Payments (BCK), focus for specified check number
JrnlID	Browser Ledger (LED), focus of ledger lines for specified journal

Columns

Index	Visible	Field Name	Caption	Usage / Description
0	Yes	APID	ID	Accounts Payable Sub-Ledger Identification Number (Systemic)
1	No	CompCode	Comp	Company Code
2	Yes	SuppCode	Supp	Supplier Code (AANNN)
3	Yes	SuppName	Supp Name	Supplier Name
4	Yes	RemitCode	Remit	Remit To Code
5	No	RemitName	Remit Name	Remit To Description
6	Yes	TrxType	Trx Type	Transaction Type
7	Yes	LineType	Line Type	AP Sub-Ledger Line Type (Set by transaction processor)
8	Yes	TrxDate	Trx Date	Transaction Date
9	Yes	DocDate	Doc Date	Document Date
10	Yes	VoucherNo	Voucher	Voucher Number or Accounts Payable Invoice Number
13	Yes	CheckNo	Check	Check Number
14	No	TrxAmt	Amount	Transaction Amount
15	No	CurCode	Cur	Currency Code
16	No	CurDes	Cur Des	Currency Description
17	No	ExchRate	Exch	Foreign Currency Exchange Rate [Edit via Currencies in Accounting\Finance Support Menu]
18	Yes	USDAmt	USD Amount	Amount USD
19	Yes	Acct	Acct	Account Number
20	No	AcctDes	Acct Des	Account Description [Edit via Chart of Accounts]
21	Yes	ProjCode	Proj	Project Code
22	No	ProjName	Proj Name	Project Name
23	Yes	CC	CC	Cost Center
24	No	CCDesc	CC Desc	Cost Center Description
25	Yes	JrnlID	Jrnl ID	Journal Identification Number (Systemic)
26	Yes	JrnlPeriod	Jrnl Per	Financial Posting Period (YYYYMM) [Edit via Accounting/Finance/General Ledger/Posting Periods]
27	No	OrigID	Orid ID	Original Identification Number (Other side of the Void ID)
28	No	VoidID	Void ID	Voided Identification Number (Other side of the Original ID)
29	Yes	IsBal	Bal	Balance Entry Checkbox (Green Check = True) Visual Indicator for the Balance Entry Side of the Transaction.
30	Yes	EmpCode	Emp	Employee Code (FOURA User ID)
31	No	APAcct	AP Acct	Accounts Payable Account
32	No	CheckRunID	Chk Run	Check Run Identification Number (Systemic)
33	Yes	PONo	PO	Purchase Order Number
34	No	ReceiptID	Receipt	Receipt Identification Number (Systemic)

Security

The following default roles can use this form:

Role	Allowed Actions
rl_Accounting	View
rl_FinRead	View
rl_APRead	View

Form Types

Browse Form

Reference

Filter Syntax