General Ledger Accounts Tables Setup
Click here to see this page in full context

 

 

General Ledger Accounts Tables Setup

General Ledger Accounts Tables Setup

GL Account Tables must be created for linking GL codes to all documents within the system.

  1. From the ribbon, left-click Financials, left-click Administration, and left-click GL Account Tables.

  2. The GL Account List search window will appear.  Left-click the Add button.

  3. The GL Accounts Table window will appear.

    1. Header
      1. Table Code field – Enter the GL account code for the general ledger account. GL accounts may have the same naming conventions as GL codes, but are not required to.
      2. Type group box
        1. Sell radio button – Select to allow entry of the sub-ledger GL codes that are related to sales transactions.
        2. Purchase radio button – Select to allow entry of the sub-ledger GL codes that are related to purchase transactions.
        3. Both radio button – Select to allow entry of the sub-ledger GL codes that are related to both sales and purchase transactions.
      3. Active flag – Mark flag as “checked” to identify the GL account as active.
      4. Name field – Enter the name of the GL account.
    2. For “Sell” Type GL Accounts
      1. Sub Totals tab

        1. Receivables field – Identify the GL code where the debit entry will affect the general ledger.
        2. Advance Pay field – Identify the GL code where the credit entry for applied advanced payments will affect the general ledger.
        3. Misc Receipts field – Identify the GL code where the credit entry for miscellaneous receipts will affect the general ledger.
        4. Doc SubTotal field – Identify the GL code where the credit entry for the document subtotal will affect the general ledger.
        5. Doc Discount field – Identify the GL code where the debit entry for document discounts will affect the general ledger.
        6. Pay Discount field – Identify the GL code where the debit entry for pay discounts will affect the general ledger.
        7. Vendor Adjustments field – Identify the GL code where the debit entry for vendor adjustments will affect the general ledger.
        8. Doc COG Sold [CR] field – Identify the GL code where the credit entry for cost of goods sold will affect the general ledger.
        9. Doc COG Sold [DB] field – Identify the GL code where the debit entry for cost of goods sold will affect the general ledger.

      2. Misc tab



        NOTE: The labels for all fields present on the Misc tab are managed on the Charges tab of the General Settings window in Administration

        1. Misc1 Charge field – Identify the GL code where the credit entry for Misc1 Charges will affect the general ledger.

        2. Misc2 Charge field – Identify the GL code where the credit entry for Misc2 Charges will affect the general ledger.

        3. Misc3 Charge field – Identify the GL code where the credit entry for Misc3 Charges will affect the general ledger.

        4. Misc4 Charge field – Identify the GL code where the credit entry for Misc4 Charges will affect the general ledger.

        5. Misc5 Charge field – Identify the GL code where the credit entry for Misc5 Charges will affect the general ledger.

        6. Misc6 Charge field – Identify the GL code where the credit entry for Misc6 Charges will affect the general ledger.

      3. Taxes tab

        1. Tax A field – Identify the GL code where the credit entry for Tax A will affect the general ledger.

        2. Tax B field – Identify the GL code where the credit entry for Tax B will affect the general ledger.

        3. Tax C field – Identify the GL code where the credit entry for Tax C will affect the general ledger.

        4. Additional Tax field – Identify the GL code where the credit entry for Additional Tax will affect the general ledger.

      4. Line Charge tab



        NOTE: The labels for all fields present on the Line Charge tab are managed on the Charges tab of the General Settings window in Administration

        1. Line Charge 1 field – Identify the GL code where the credit entry for Line Charge 1 will affect the general ledger.

        2. Line Charge 2 field – Identify the GL code where the credit entry for Line Charge 2 will affect the general ledger.

        3. Line Charge 3 field – Identify the GL code where the credit entry for Line Charge 3 will affect the general ledger.

      5. WIP Costs tab

        1. Total Cost group box

          1. Debit radio button – Select to create a debit entry for the identified GL code when WIP costs are posted.  This will cause labor and overhead entries to be created as credits when the general ledger account is selected.

          2. Credit radio button – Select to create a credit entry for the identified GL code when WIP costs are posted.  This will cause labor and overhead entries to be created as debits when the general ledger account is selected.

          3. Total Cost field – Identify the GL code where the entry for total work in progress cost will affect the general ledger.

        2. Regular field – Identify the GL code where the entry for regular time labor will affect the general ledger.

        3. OverTime field – Identify the GL code where the entry for overtime labor will affect the general ledger.

        4. Overhead field – Identify the GL code where the entry for overhead charges will affect the general ledger.

      6. WIP Parts tab



        NOTE: The labels for the three lowest fields present on the WIP Parts tab are managed on the Charges tab of the General Settings window in Administration

        1. Total Cost group box

          1. Debit radio button – Select to create a debit entry for the identified GL code when WIP parts are posted.  This will cause parts costs and additional charges entries to be created as credits when the general ledger account is selected.

          2. Credit radio button – Select to create a credit entry for the identified GL code when WIP parts are posted.  This will cause parts costs and additional charges entries to be created as debits when the general ledger account is selected.\

          3. Total Cost field – Identify the GL code where the entry for total work in progress parts will affect the general ledger.

        2. Cost field – Identify the GL code where the entry for parts cost will affect the general ledger.

        3. Line Charge 1 field – Identify the GL code where the entry for parts Line Charge 1 will affect the general ledger.

        4. Line Charge 2 field – Identify the GL code where the entry for parts Line Charge 2 will affect the general ledger.

        5. Line Charge 3 field – Identify the GL code where the entry for parts Line Charge 3 will affect the general ledger.

      7. Other tab

        1. Purchase Receiver Posting (In lieu of account payable) group box:

          1. Credit field – Identify the GL code where the credit entry for posting a purchase receiver will affect the general ledger.

        2. Stock Updates group box

          1. Debit field – Identify the GL code where the debit entry for a stock update will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for a stock update will affect the general ledger.

        3. W/H Transfer group box

          1. Debit field – Identify the GL code where the debit entry for a warehouse transfer will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for a warehouse transfer will affect the general ledger.

        4. Currency Diff - A/R group box

          1. Net Amount field – Identify the GL code where the debit entry for the net amount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

          2. Discount [CR] field – Identify the GL code where the credit entry for a discount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

          3. Discount [DB] field – Identify the GL code where the debit entry for a discount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

        5. Currency Diff - A/P group box

          1. Net Amount field – Identify the GL code where the debit entry for the net amount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

          2. Discount [DB] field – Identify the GL code where the debit entry for a discount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

          3. Discount [CR] field – Identify the GL code where the credit entry for a discount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

        6. A/P Price Adjustment group box

          1. Debit field – Identify the GL code where the debit entry for an A/P price adjustment will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for an A/P price adjustment will affect the general ledger.

    3. For “Purchase” Type GL Accounts

      1. Sub Totals tab

        1. Doc SubTotal field – Identify the GL code where the debit entry for the document subtotal will affect the general ledger.

        2. Doc Discount field – Identify the GL code where the credit entry for document discounts will affect the general ledger.

        3. Pay Discount field – Identify the GL code where the credit entry for pay discounts will affect the general ledger.

        4. Vendor Adjustments field – Identify the GL code where the credit entry for vendor adjustments will affect the general ledger.

        5. Payables field – Identify the GL code where the credit entry will affect the general ledger.

        6. Advance field – Identify the GL code where the debit entry for applied advances will affect the general ledger.

        7. Misc Payments field – Identify the GL code where the debit entry for miscellaneous payments will affect the general ledger.

        8. Doc COG Core Claim [CR] field – Identify the GL code where the credit entry for cost of goods sold on a claim will affect the general ledger.

        9. Doc COG Core Claim [DB] field – Identify the GL code where the debit entry for cost of goods sold on a claim will affect the general ledger.

      2. Misc tab



        NOTE: The labels for all fields present on the Misc tab are managed on the Charges tab of the General Settings window in Administration

        1. Misc1 Charge field – Identify the GL code where the debit entry for Misc1 Charges will affect the general ledger.

        2. Misc2 Charge field – Identify the GL code where the debit entry for Misc2 Charges will affect the general ledger.

        3. Misc3 Charge field – Identify the GL code where the debit entry for Misc3 Charges will affect the general ledger.

        4. Misc4 Charge field – Identify the GL code where the debit entry for Misc4 Charges will affect the general ledger.

        5. Misc5 Charge field – Identify the GL code where the debit entry for Misc5 Charges will affect the general ledger.

        6. Misc6 Charge field – Identify the GL code where the debit entry for Misc6 Charges will affect the general ledger.

      3. Taxes tab

        1. Tax A field – Identify the GL code where the debit entry for Tax A will affect the general ledger.

        2. Tax B field – Identify the GL code where the debit entry for Tax B will affect the general ledger.

        3. Tax C field – Identify the GL code where the debit entry for Tax C will affect the general ledger.

        4. Additional Tax field – Identify the GL code where the debit entry for Additional Tax will affect the general ledger.

      4. Line Charge tab



        NOTE: The labels for all fields present on the Line Charge tab are managed on the Charges tab of the General Settings window in Administration

        1. Line Charge 1 field – Identify the GL code where the debit entry for Line Charge 1 will affect the general ledger.

        2. Line Charge 2 field – Identify the GL code where the debit entry for Line Charge 2 will affect the general ledger.

        3. Line Charge 3 field – Identify the GL code where the debit entry for Line Charge 3 will affect the general ledger.

      5. Other tab

        1. Purchase Receiver Posting (In lieu of account payable) group box:

          1. Credit field – Identify the GL code where the credit entry for posting a purchase receiver will affect the general ledger.

        2. Stock Updates group box

          1. Debit field – Identify the GL code where the debit entry for a stock update will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for a stock update will affect the general ledger.

        3. W/H Transfer group box

          1. Debit field – Identify the GL code where the debit entry for a warehouse transfer will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for a warehouse transfer will affect the general ledger.

        4. Currency Diff - A/R group box

          1. Net Amount field – Identify the GL code where the debit entry for the net amount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

          2. Discount [CR] field – Identify the GL code where the credit entry for a discount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

          3. Discount [DB] field – Identify the GL code where the debit entry for a discount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

        5. Currency Diff - A/P group box

          1. Net Amount field – Identify the GL code where the debit entry for the net amount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

          2. Discount [DB] field – Identify the GL code where the debit entry for a discount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

          3. Discount [CR] field – Identify the GL code where the credit entry for a discount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

        6. A/P Price Adjustment group box

          1. Debit field – Identify the GL code where the debit entry for an A/P price adjustment will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for an A/P price adjustment will affect the general ledger.

    4. For “Both” Type GL Accounts

      1. Sub Totals tab

        1. Receivables field – Identify the GL code where the debit entry will affect the general ledger.

        2. Advance Pay field – Identify the GL code where the credit entry for applied advanced payments will affect the general ledger.

        3. Misc Receipts field – Identify the GL code where the credit entry for miscellaneous receipts will affect the general ledger.

        4. Payables field – Identify the GL code where the credit entry will affect the general ledger.

        5. Advance field – Identify the GL code where the debit entry for applied advances will affect the general ledger.

        6. Misc Payments field – Identify the GL code where the debit entry for miscellaneous payments will affect the general ledger.

        7. Doc SubTotal field – Identify the GL code where the entry for the document subtotal will affect the general ledger.

        8. Doc Discount field – Identify the GL code where the entry for document discounts will affect the general ledger.

        9. Pay Discount field – Identify the GL code where the entry for pay discounts will affect the general ledger.

        10. Vendor Adjustments field – Identify the GL code where the entry for vendor adjustments will affect the general ledger.

        11. Doc COG Sold [CR] field – Identify the GL code where the credit entry for cost of goods sold will affect the general ledger.

        12. Doc COG Sold [DB] field – Identify the GL code where the debit entry for cost of goods sold will affect the general ledger.

      2. Misc tab



        NOTE: The labels for all fields present on the Misc tab are managed on the Charges tab of the General Settings window in Administration

        1. Misc1 Charge field – Identify the GL code where the entry for Misc1 Charges will affect the general ledger.

        2. Misc2 Charge field – Identify the GL code where the entry for Misc2 Charges will affect the general ledger.

        3. Misc3 Charge field – Identify the GL code where the entry for Misc3 Charges will affect the general ledger.

        4. Misc4 Charge field – Identify the GL code where the entry for Misc4 Charges will affect the general ledger.

        5. Misc5 Charge field – Identify the GL code where the entry for Misc5 Charges will affect the general ledger.

        6. Misc6 Charge field – Identify the GL code where the entry for Misc6 Charges will affect the general ledger.

      3. Taxes tab

        1. Tax A field – Identify the GL code where the entry for Tax A will affect the general ledger.

        2. Tax B field – Identify the GL code where the entry for Tax B will affect the general ledger.

        3. Tax C field – Identify the GL code where the entry for Tax C will affect the general ledger.

        4. Additional Tax field – Identify the GL code where the entry for Additional Tax will affect the general ledger.

      4. Line Charge tab



        NOTE: The labels for all fields present on the Line Charge tab are managed on the Charges tab of the General Settings window in Administration

        1. Line Charge 1 field – Identify the GL code where the entry for Line Charge 1 will affect the general ledger.

        2. Line Charge 2 field – Identify the GL code where the entry for Line Charge 2 will affect the general ledger.

        3. Line Charge 3 field – Identify the GL code where the entry for Line Charge 3 will affect the general ledger.

      5. WIP Costs tab

        1. Total Cost group box

          1. Debit radio button – Select to create a debit entry for the identified GL code when WIP costs are posted.  This will cause labor and overhead entries to be created as credits when the general ledger account is selected.

          2. Credit radio button – Select to create a credit entry for the identified GL code when WIP costs are posted.  This will cause labor and overhead entries to be created as debits when the general ledger account is selected.

          3. Total Cost field – Identify the GL code where the entry for total work in progress cost will affect the general ledger.

        2. Regular field – Identify the GL code where the entry for regular time labor will affect the general ledger.

        3. OverTime field – Identify the GL code where the entry for overtime labor will affect the general ledger.

        4. Overhead field – Identify the GL code where the entry for overhead charges will affect the general ledger.

      6. WIP Parts tab



        NOTE: The labels for the three lowest fields present on the WIP Parts tab are managed on the Charges tab of the General Settings window in Administration

        1. Total Cost group box

          1. Debit radio button – Select to create a debit entry for the identified GL code when WIP parts are posted.  This will cause parts costs and additional charges entries to be created as credits when the general ledger account is selected.

          2. Credit radio button – Select to create a credit entry for the identified GL code when WIP parts are posted.  This will cause parts costs and additional charges entries to be created as debits when the general ledger account is selected.

          3. Total Cost field – Identify the GL code where the entry for total work in progress parts will affect the general ledger.

        2. Cost field – Identify the GL code where the entry for parts cost will affect the general ledger.

        3. Line Charge 1 field – Identify the GL code where the entry for parts Line Charge 1 will affect the general ledger.

        4. Line Charge 2 field – Identify the GL code where the entry for parts Line Charge 2 will affect the general ledger.

        5. Line Charge 3 field – Identify the GL code where the entry for parts Line Charge 3 will affect the general ledger.

      7. Other tab

        1. Purchase Receiver Posting (In lieu of account payable) group box:

          1. Credit field – Identify the GL code where the credit entry for posting a purchase receiver will affect the general ledger.

        2. Stock Updates group box

          1. Debit field – Identify the GL code where the debit entry for a stock update will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for a stock update will affect the general ledger.

        3. W/H Transfer group box

          1. Debit field – Identify the GL code where the debit entry for a warehouse transfer will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for a warehouse transfer will affect the general ledger.

        4. Currency Diff - A/R group box

          1. Net Amount field – Identify the GL code where the debit entry for the net amount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

          2. Discount [CR] field – Identify the GL code where the credit entry for a discount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

          3. Discount [DB] field – Identify the GL code where the debit entry for a discount resulting from a change in exchange rates on accounts receivable transactions will affect the general ledger.

        5. Currency Diff - A/P group box

          1. Net Amount field – Identify the GL code where the debit entry for the net amount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

          2. Discount [DB] field – Identify the GL code where the debit entry for a discount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

          3. Discount [CR] field – Identify the GL code where the credit entry for a discount resulting from a change in exchange rates on accounts payable transactions will affect the general ledger.

        6. A/P Price Adjustment group box

          1. Debit field – Identify the GL code where the debit entry for an A/P price adjustment will affect the general ledger.

          2. Credit field – Identify the GL code where the credit entry for an A/P price adjustment will affect the general ledger.

AEROSPACE     •     DEFENSE     •     ELECTRONICS     •     POWER SYSTEMS     •     METALS•     DEFENSE     •     ELECTRONICS     •     POWER SYSTEMS     •     METALS

 

 

General Ledger Accounts Tables Setup