The General Ledger is designed to be the central component of a fully integrated accounting system. This means that other accounting modules post automatically to the G/L. To accomplish this, autopost numbers are assigned to selected accounts in the General Ledger using the Maintain Account Descriptions program. These autopost numbers act as a pointer or account identifier for certain accounting programs such as Accounts Payable Entry, and the autopost number or numbers control the General Ledger account or accounts that these programs will post to. By assigning an autopost number to certain accounts, the system can support varied General Ledger account numbering schemes.
In some cases only a particular autopost number will work for a program. An example would be Inventory Receiving program. The Receiving program will post the extended cost of the inventory being received to the Unvouchered Inventory Account to record the liability to the vendor for the items. This account must exist and it must be assigned an autopost number of 340 or you may not receive inventory. In cases like this where only one autopost number will work, the program has been "hardcoded" to post only to that particular autopost account, and it expects the account to exist and to be ready for posting in the current period.
In other cases it is possible to have a range of accounts posted to by certain programs. A good example of this is the Accounts Payable system. In the Accounts Payable Check Printing program, the user is allowed to specify the cash account that the A/P checks will be deducted from. Valid cash accounts would include those with autopost numbers between 110 and 129. The General Ledger cash account numbers do not have to be same as the autopost numbers but the accounts must have autopost numbers in the proper range assigned to them. This provides flexibility and allows for easy handling of transactions for companies with multiple bank accounts, check numbering schemes, etc. In cases where a range of various autopost numbers will work for a particular program, a default autopost number can be entered and changed when necessary in the System Control file.
Autopost |
Description |
System |
0-99 |
Cash Clearing Accts |
AR |
100-119 |
Cash – Operating |
AP,AR |
120-129 |
Accounts Receivable |
AR |
150-199 |
Inventory |
WMS/SP |
1001 |
Cash Box – POS System |
POS |
1002 |
POS Clearing – Checks, C Cards |
POS |
1999 |
In Transit Inventory |
ASN (AP) |
200-249 |
Pending (not yet implemented |
PN |
250-299 |
WIP (not yet implemented) |
SF |
310-319 |
Accounts Payable |
AP |
320 |
Vendor Rebates Receivable |
SP/RM |
340 |
Inventory Liability |
WMS/AP |
341 |
Freight Liability |
WMS/AP |
360 |
Price Protection Accrual |
PP |
370-399 |
Vat Payable (370) / Paid(371-399) |
AP/SP |
3700-3799 |
Sales Tax / VAT Payable |
SP |
500-549 |
Net Sales |
SP |
5000-5499 |
Net Sales |
SP |
550 |
Sales Discount |
SP |
560 |
Shipping |
SP |
570-599 |
Discounts Taken |
AR |
600-649 |
Cost of Sales |
SP |
6000-6499 |
Cost of Sales |
SP |
650 |
Rebates Revenue |
RM |
660 |
Gain /Loss - Returns to Vendors |
RTV |
670 |
Gain /Loss - Returns to Inventory |
PN |
680 |
Gain/ Loss - Returns from Manuf |
MAN |
700-710 |
Inventory Adjustments |
WMS |
711-720 |
Pending Adjustments |
WMS |
721-730 |
Inventory Cost Adjustments |
WMS |
780-789 |
Bank Charges |
BK |
790-799 |
Miscellaneous Deposits (Non AR/AP) |
BK |
800 |
Net Income |
GL |
801 |
Current Retained Earnings |
GL |
820 |
Discounts Earned |
AP |
830 |
Finance Charges Income |
SP |
835 |
Foreign Currency Rounding |
SP |
840 |
Foreign Currency Gain/Loss |
AP/AR |
Modules
ASN = Advanced Shipment Notification (automated AP invoices).
BNK = Bank System
AP = Accounts Payable
AR = Accounts Receivable
IN = Inventory (Receiving, Adjustments, Cost Adjustments)
MAN = Manufacturing system (Shop Orders)
PN = Pending (Gains, losses, adjustments)
RM = Rebate Management System
RTV = Return to Vendor
SP = Sales Posting
Notes: Autoposts 660 and 670 must both exist if you are processing transactions in the Pending file. The autopost for pending gains and losses due to creating AP invoices from the pending file is hard coded to 660. The autopost used when returning pending records to inventory in fv161s01 is based on F248:161s01. The autopost used when receiving an IFT PO (which goes thru pending file) is hard-coded to 670 in FV100G12. This means both autoposts must exist in order for Pending system to work correctly.
More: