Understanding the Account Number in General Ledger

The account number in manual JV postings are derived from the account number entered in the account ledger.

During setup of customized account ledgers in Master Data > Accounting Menu > Account Ledgers, the account number for that particular account ledger is defined. The account number entered in the account ledger is created and maintained in Master Data > Accounting Menu > Account Number.

If the account number in the account ledger is a fixed code in numeric format, that accounting number is used in the manual JV posting. For instances when the account number depends on variable parameters, the entered account number in the account ledger uses several variables that are then converted according to specific scenarios. The converted value is the value that is shown in the manual JV posting.

Agent account numbers are taken from the information in the Forwarder screen separated with (.) periods. If the Account # field of the Agent is blank, the value is taken from the Forwarder's Code.

The conversion details applicable to account number are similar to how the values for Sub Ledger and Ctrl No. are derived.

Table 1. Variable Conversions
Variable	Conversion Details
`AGNT ACCT`	(AC or CS) `AGNT ACCT` is converted to the account number of the Agent. For Shipper invoices, it is converted to the account number of the Shipper.
`RECV AGT`	(CC) `RECV AGT` is converted to the account number of the Import Agent.
`CUSTOMER`	(CC, AC, or CS) This value is converted to the account number of the Agent from the Payment record.
`INV`
`STN`	For CC AWBs, `STN` is converted to the numeric Station Code of either the: AWB destination Agent Sales Region
`GSN`	(CC) For Import AWBs, `GSN` is converted to the numeric GSA Code of either the: AWB destination Agent Sales Region
`STA`	(CC) For Import AWBs, `STA` is converted to the alphabetic Station Code of either the: AWB destination Agent Sales Region
`GSA`	(CC) For Import AWBs, `GSA` is converted to the alphabetic GSA Code of either the: AWB destination Agent Sales Region
`ORG`	(CC) For Import AWBs, `ORG` is converted to the AWB Origin.
`DST`	(CC) For Import AWBs, `DST` is converted to the AWB Destination.
`CARRIER`	`CARRIER` is converted to the AR Account# in the carrier record of the participating carrier. If the carrier record does not have AR Account# filled in, `CARRIER` is converted to the Carrier Code. The participating carrier is usually the Issuing Carrier, except for Interline Postings where the participating carrier is derived from the Invoice Carrier.
`CARRIEP`	`CARRIEP` is converted to the AP Account# in the carrier record of the participating carrier. If the carrier record does not have AP Account# filled in, `CARRIEP` is converted to the Carrier Code. The participating carrier is usually the Issuing Carrier, except for Interline Postings where the participating carrier is derived from the Invoice Carrier.
`OAL`	`OAL` is converted to the carrier Prefix of the other airline.
`DDMMMYY`	`DDMMMYY` is converted to the Account Date of the AWB.
`YYYYMM`	`YYYYMM` is converted to the Clear Period.
`MMYY`	`MMYY` is converted to the month and year.
`MMM`	`MMM` is converted to the month's three-letter abbreviation.
`XGSA`	`XGSA` is converted to the Clear Week and the `GSA`.

The GSAConversion and StationConversion tables can be viewed in Master Data > Others > View Master Codes provided you have the appropriate duty codes.