General Ledger Integration
SYSPRO Ribbon bar > Setup > Setup Options > General Ledger Integration
This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
This prints detail entries on the Expense and Disbursement distribution reports to be summarized by ledger code before being posted to GL.
This prints each detail entry on the Expense and Disbursement distribution reports to be posted to GL. It also enables the zoom facility within the GL Query.
This prints detail lines for control accounts on distribution reports which can be viewed using the GL Query program and from within the relevant journals maintenance program.
If Accounts Payable is linked to General Ledger, then this creates the journal for GL from the AP transaction journal automatically whenever you successfully post a transaction in the Accounts Payable module. If you don't select this option, then you'll need to use the AP Invoice GL Integration and AP Payments GL Integration programs to manually create the journals for GL.
This posts journals (output by the AP Invoice GL Integration program) to GL automatically. Otherwise you'll need to use the GL Journal Entry program to post the journals manually after they're created. You can't select this if you've enabled the GL preference (and vice versa). Sub module journals are created, but placed on hold if a GL account used in the journal is on hold. You'll need to correct the error and post the journals manually.
This ensures that journals from the AP Payment Cycle are created with check numbers, where applicable. Otherwise journals are created using only the Execute AP Payment Run program without check numbers. Only when you print the checks and run the AP Payment Register program are the check numbers allocated to journals not yet posted. You can only select this if you have enabled both the Create GL journal and Post GL journal options.
This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
This lets you enter GL analysis information when the ledger journal for the transaction is posted (you can select an Ask Me Later option in the Capture GL Analysis Entries program) and the GL analysis information must then be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted.
This indicates that Dimension analysis is not required in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting journal entries to the General Ledger.
Ledger codes not set to Control account in detail may cause unpredictable results for transactions created with dimension analysis.
This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
This prints detail entries on the Payments and Sales distribution reports to be summarized by ledger code before being posted to GL.
This prints each detail entry on the Payments and Sales distribution reports to be posted to GL. It also enables the zoom facility within the GL Query.
This prints detail lines for control accounts on distribution reports which can be viewed using the GL Query program and from within the relevant journals maintenance program.
If Accounts Receivable is linked to General Ledger, then this creates the journal for GL from the AR transaction journal automatically whenever you successfully post a transaction in the Accounts Receivable module. If you don't select this option, then you'll need to use the AR Invoice GL Integration and AR Payments GL Integration programs to manually create the journals for GL.
This posts journals (output by the AR Invoice GL Integration program) to GL automatically. Otherwise you'll need to use the GL Journal Entry program to post the journals manually after they're created. You can't select this if you've enabled the GL preference (and vice versa). Sub module journals are created, but placed on hold if a GL account used in the journal is on hold. You'll need to correct the error and post the journals manually.
This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
This lets you enter GL analysis information when the ledger journal for the transaction is posted (you can select an Ask Me Later option in the Capture GL Analysis Entries program) and the GL analysis information must then be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted.
This indicates that Dimension analysis is not required in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting journal entries to the General Ledger.
Ledger codes not set to Control account in detail may cause unpredictable results for transactions created with dimension analysis.
If you intend processing inter-company Cash Book transactions, then we strongly recommend that you define the same General Ledger integration options in both SYSPRO companies
This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
This prints detail entries on the Cash Book distribution report to be summarized by ledger code before being posted to GL.
This prints each detail entry on the Cash Book distribution report to be posted to GL. It also enables the zoom facility within the GL Query.
This prints detail lines for control accounts on distribution reports which can be viewed using the GL Query program and from within the relevant journals maintenance program.
If Cash Book is linked to General Ledger, then this creates the journal for GL from the CB transaction journal automatically whenever you successfully post a transaction in the Cash Book module. If you don't select this option, then you'll need to use the Cash Book GL Integration program to manually create the journals for GL.
This posts journals created from the Cash Book module to GL automatically. Otherwise you'll need to use the GL Journal Entry program to post the journals manually after they're created. You can't select this if you've enabled the GL preference (and vice versa). Sub module journals are created, but placed on hold if a GL account used in the journal is on hold. You'll need to correct the error and post the journals manually.
This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
This lets you enter GL analysis information when the ledger journal for the transaction is posted (you can select an Ask Me Later option in the Capture GL Analysis Entries program) and the GL analysis information must then be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted.
This indicates that Dimension analysis is not required in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting journal entries to the General Ledger.
Ledger codes not set to Control account in detail may cause unpredictable results for transactions created with dimension analysis.
This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
This prints detail entries on the Inventory distribution report to be summarized by ledger code before being posted to GL.
This prints each detail entry on the Inventory distribution report to be posted to GL. It also enables the zoom facility within the GL Query.
This prints detail lines for control accounts on distribution reports which can be viewed using the GL Query program and from within the relevant journals maintenance program.
If Inventory is linked to General Ledger, then this creates the journal for GL from the Inventory or GRN transaction journals automatically whenever you successfully post a transaction in the Inventory module. If you don't select this option, then you'll need to use the Inventory GL Integration and GRN GL Integration programs to manually create the journals for GL.
This posts journals (output by the Inventory GL Integration and GRN GL Integration programs) to GL automatically. Otherwise you'll need to use the GL Journal Entry program to post the journals manually after they're created. You can't select this if you've enabled the GL preference (and vice versa). Sub module journals are created, but placed on hold if a GL account used in the journal is on hold. You'll need to correct the error and post the journals manually.
This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
This lets you enter GL analysis information when the ledger journal for the transaction is posted (you can select an Ask Me Later option in the Capture GL Analysis Entries program) and the GL analysis information must then be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted.
This indicates that Dimension analysis is not required in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting journal entries to the General Ledger.
Ledger codes not set to Control account in detail may cause unpredictable results for transactions created with dimension analysis.
This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
This prints detail entries on the Assets distribution report to be summarized by ledger code before being posted to GL.
This prints each detail entry on the Assets distribution report to be posted to GL. It also enables the zoom facility within the GL Query.
There is no Control account in detail option for assets because posting to asset control accounts have always been in detail.
If Assets is linked to General Ledger, then this creates the journal for GL from the Assets transaction journal automatically whenever you successfully post a transaction in the Assets Register module. If you don't select this option, then you'll need to use the Asset GL Integration program to manually create the journals for GL.
This posts journals (output by the Asset GL Integration program) to GL automatically. Otherwise you'll need to use the GL Journal Entry program to post the journals manually after they're created. You can't select this if you've enabled the GL preference (and vice versa). Sub module journals are created, but placed on hold if a GL account used in the journal is on hold. You'll need to correct the error and post the journals manually.
This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
This lets you enter GL analysis information when the ledger journal for the transaction is posted (you can select an Ask Me Later option in the Capture GL Analysis Entries program) and the GL analysis information must then be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted.
This indicates that Dimension analysis is not required in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting journal entries to the General Ledger.
Ledger codes not set to Control account in detail may cause unpredictable results for transactions created with dimension analysis.
This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
This prints detail entries on the WIP Part Billings Distribution and WIP Labor Distribution reports to be summarized by ledger code before being posted to GL.
This prints each detail entry on the WIP Part Billings Distribution and WIP Labor Distribution reports to be posted to GL. It also enables the zoom facility within the GL Query.
This prints detail lines for control accounts on distribution reports which can be viewed using the GL Query program and from within the relevant journals maintenance program.
If Work in Progress is linked to General Ledger, then this creates the journal for GL from the Work in Progress transaction journal automatically whenever you successfully post a transaction in the Work in Progress module. If you don't select this option, then you'll need to use the WIP Part Billings GL Integration program to manually create the journals for GL.
This posts journals (output by the Inventory GL Integration and GRN GL Integration programs) to GL automatically. Otherwise you'll need to use the GL Journal Entry program to post the journals manually after they're created. You can't select this if you've enabled the GL preference (and vice versa). Sub module journals are created, but placed on hold if a GL account used in the journal is on hold. You'll need to correct the error and post the journals manually.
This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
This lets you enter GL analysis information when the ledger journal for the transaction is posted (you can select an Ask Me Later option in the Capture GL Analysis Entries program) and the GL analysis information must then be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted.
This applies integration to General Ledger using the ledger accounts defined against the WIP company options.
This applies integration to General Ledger using the ledger accounts defined against the WIP branch.
This applies integration to General Ledger using the WIP branch and ledger accounts defined against the job classification.
This indicates that Dimension analysis is not required in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
This indicates that Dimension analysis must be triggered at the time of posting journal entries to the General Ledger.
Ledger codes not set to Control account in detail may cause unpredictable results for transactions created with dimension analysis.
Entries are posted to this capital-type account to correct an out-of-balance situation in the General Ledger. The posted value can then be journalized out to the correct ledger code manually.
Entries are posted to this account when you run a GL Year End and choose to set expense and revenue accounts to zero, resulting in a net income/loss. This applies to ledger accounts against which a retained earnings account has not been defined. You can define multiple retained earnings accounts by defining them against your expense and revenue type ledger codes. The retained earnings account defined against a ledger code takes precedence over the account defined here.
This is the account to which the merchandise value of a supplier invoice is posted during processing in the AP Invoice Posting program if the account is not defined against the supplier. You should only enter a default account here if you charge all inventory purchases to one account and a very large portion of the invoices posted are inventory-related. This account is not applicable if the GRN system is in use.
This is the account to which the freight value of a supplier invoice is posted during processing in the AP Invoice Posting program, if the account is not defined against the supplier.
This is the account to which tax entries are posted during processing in the AP Invoice Posting and AP Permanent Entries Posting programs, if you selected to disburse tax over a single GL tax account; your tax AP tax distribution is set to detail or summary; and you require a global tax file.
If using the EC VAT system, then this is the account to which 'self-charged' VAT is posted when you purchase goods from a supplier within an EC Member State (excluding local purchases) and you supplied the supplier with your VAT details (i.e. the supplier does not include VAT on the invoice to you).
This is the account to which withholding tax entries are posted when processing supplier payments using the Payment Cycle Maintenance program and you selected Single GL tax account at the Disburse tax amount over setup option. This field is only displayed if the Withholding tax required setup option is enabled.
This is the account to which second tier tax entries are posted during processing using the AP Invoice Posting and AP Permanent Entries Posting programs. This field is only displayed if the Second tier tax required setup option is enabled.
If the Request QST amount setup option is enabled then this is the account to which the 2nd tier tax portion of settlement discount must be disbursed. Since tax is based on the gross amount before settlement discount is calculated when posting an AP invoice, when you take advantage of terms discount the amount of 2nd tier tax refundable to you must be reduced. The system passes a credit through this link to the tax recoverable account in GL.
This is the account to which the value of supplier invoices offset against customer invoices is posted when using the Customer-Supplier Contra program (typically a credit). This could be the same code you enter at the Contra suspense field on the Receivables form. The credit posted from offsetting the supplier invoices and the debit posted from offsetting the customer invoices are then posted to the same account, resulting in a zero balance in this account.
This is the account to which tax accrual entries are posted for suppliers whose tax assessment is defined as Self (USA tax only).
This is the account to which previously-claimed input tax (not yet paid to a supplier) must be repaid to the tax authority. The account is credited by the AP Tax relief program and debited by the Execute AP Payment Run program when paying invoices against which tax relief was previously processed. The account must be manually adjusted when using the AP Invoice Posting program to post adjustments, debit notes and credit notes against invoices for which tax relief was previously processed.
This is the ledger account description for merchandise printed on the Accounts Payable distribution report if Accounts Payable integration to General Ledger is set to Not linked to GL distribution report.
This is the ledger account description for freight printed on the Accounts Payable distribution report if Accounts Payable integration to General Ledger is set to Not linked to GL distribution report.
This is the ledger account description for input tax printed on the Accounts Payable distribution report if Accounts Payable integration to General Ledger is set to Not linked to GL distribution report.
This is the account to which exchange rate gains or losses are posted when using the AR Payments and Adjustments program. You can override this account at the time of entering a payment against a foreign customer. Also, if you did not use the AR Currency Variance GL Interface program to define interface ledger accounts by branch/currency, then the AR Exchange Rate Revaluation program also uses this account to post exchange rate variances.
This is the account to which withholding tax entries are posted when processing customers' payments using the AR Payments and Adjustments program. You can only access this field if the Withholding tax required option is enabled against the Setup Options > Tax > Company Tax Options form.
If you enabled the option to request the tax portion for an invoice, then the tax portion of an adjustment or discount amount is posted to this account from the AR Payments and Adjustments program.
This is the account to which the value of customer invoices offset against supplier invoices is posted when using the Customer-Supplier Contra program (typically a debit). This could be the same code you enter at the Contra suspense field on the Payables form. The credit posted from offsetting the supplier invoices and the debit posted from offsetting the customer invoices are then posted to the same account, resulting in a zero balance in this account.
This account is used for tax relief and recovery in Accounts Receivable (reserved for future use).
This is the account to which the expense/revenue side of a Balance rounding correction is posted by the AR Period End program. This is an expense/revenue type account.
This is the account to which the balance sheet side of a Balance rounding correction is posted by the AR Period End program. This is an asset type account.
This is the account to which inter-company distribution amounts are posted. It serves as the link for inter-company transactions entered in the Cash Book Deposits and Withdrawals program. This account is only used if Cash Book is linked to General Ledger and you intend entering distribution codes for companies other than the one in which you are working.
This is the default account to which the tax portion of any deposit (or adjustment to a deposit) is posted during processing in the Cash Book Deposits and Withdrawals program. All Tax only transactions for deposits processed in the Cash Book Deposits and Withdrawals program are posted to this account.
This is the default account to which the tax portion of any withdrawal (or adjustment to a withdrawal) is posted during processing in the Cash Book Deposits and Withdrawals program. All Tax only transactions for withdrawals processed in the Cash Book Deposits and Withdrawals program are posted to this account.
This is the clearing account used when processing inter-bank transfers using the Cash Book Deposits and Withdrawals program. This should be an asset-type account. If Cash Book is linked to General Ledger, then this must be a valid SYSPRO ledger account. In addition, you can only select the Interbank Transfers option from the Cash Book Deposits and Withdrawals program if this account is specified.
This is the ledger account description for deposits printed on the Cash Book distribution report if Cash Book integration to General Ledger is set to Not linked to GL distribution report.
This is the ledger account description for withdrawals printed on the Cash Book distribution report if Cash Book integration to General Ledger is set to Not linked to GL distribution report.
This account links the Inventory Control module to the non-stocked control accounts in the General Ledger. The debit side of a non-stocked inventory receipt is passed through this link. Non-stocked items must be received against a purchase order. You cannot run the Inventory Movements program if you don't enter a ledger code here.
This is the account to which cost of sales adjustments are posted, arising when the inventory balance on hand goes negative. This only applies if you are using average costing and you have allowed the warehouse to go negative. The adjustment value is calculated as the new cost less the old cost multiplied by the quantity received. This account is used when a receipt is entered where the current quantity on hand is negative and the costing method is based on average costing.
This is the account to which postings are made when the receipt of a subcontract purchase order line is made directly to a job, and the GRN suspense system is not required.
This is the account to which distribution entries are posted during processing within the AP Invoice Posting program, where GRN matching is selected.
This is the account to which distribution entries are posted during processing in the AP Invoice Posting program, where GRN matching is selected and there is a variance between the actual receipt value and the invoice value. Purchase price variances that are below a pre-defined percentage that you set to ignore are posted to the GRN suspense account.
This is the account to which rounding errors are posted during the processing of a receipt into stock of an item that requires Activity Based Costing. Postings are only made to the ABC costing variance account if the value of the total cost of the receipt differs from the value of the new unit cost multiplied by the receipt quantity.
This is the account to which postings are made for goods in transit transactions processed against a warehouse which has not been assigned a Goods in transit control account. This account (usually defined as an asset) is debited when processing a non-immediate transfer out, and credited when processing a transfer in.
This account (usually defined as an asset) is debited at the time of creating a dispatch note, and credited once the dispatch note is invoiced. If this account is defined against the warehouse from which the items are being dispatched, then the Dispatched but not invoiced account held against the warehouse takes precedence. Dispatches involving non-stocked items will always use the account defined here.
This is the account to which the cost/value amounts are posted for asset additions, asset disposals and changes to asset cost/value amounts.
This is the account to which postings are made for the gain/loss you incur when you dispose of an asset using the Asset Disposal program.
This is the account that is
This is the account to which postings are made when an asset is revalued using the Asset Revaluation program.
This is the account to which postings are made for asset additions,
asset disposals and changes to asset cost/value amounts. The cost/cash price
of asset additions is
This is the expense account to which book value depreciation amounts are posted. If you are depreciating assets at individual asset level then the account entered here is ignored for book value depreciation, regardless of whether a ledger code is defined against the asset. If no ledger code for book value depreciation is defined against the asset, then the transaction journal is created with a blank ledger code (i.e. it does not default to the depreciation ledger code defined here).
This is the balance sheet account to which book value depreciation amounts are posted.
This is the clearing account used when transferring assets between SYSPRO companies.
This is the account to which the difference between the book value in the current company and the transfer book value to the new company is posted.
This is the default account to which the value of work in progress is posted when a job is created, if a work in progress account has not been assigned to the stock item for which the job is being created. The ledger code defined in the Capex in Progress field is used for all jobs created for and linked to a capex requisition line.
This is the account to which postings are made during the Backflushing function of the Inventory Movements program if there is a variance between the entered cost of the manufactured item and the cost of the item's material and labor allocations calculated by the system.
If you're using standard costing, then this is the default account to which WIP variances (falling below your specified value) are posted automatically when receiving a finished part into stock from a completed job. The account is only used if the Automatically cleared variance account is not defined against the warehouse.
If WIP inspection is required, then this is the default account to which the WIP value of goods received into inspection is posted. The account is used if a WIP inspection account is not held against the warehouse into which the goods are being received. You can't receive items from inspection into stock using the WIP Inspection Maintenance program if you haven't defined a WIP inspection account here or against the warehouse and you didn't enable the Request ledger code at transactions option.
This lets you define ledger accounts for each branch when Work in Progress is integrated to General Ledger by branch.
This lets you define the ledger accounts for each job classification when Work in Progress is integrated to General Ledger by job classification.
This is the default account to which the value of accrual promotions must be credited when processing a sales order. The GL promotion accrual account defined against the promotion code is used if it differs from the code entered here.
This is the default account to which the value of the accrual promotion must be debited when processing a sales order. The GL promotion expense account defined against the promotion code is used if it differs from the code entered here.
This is the default account to which deduction amounts are accumulated in the General Ledger (typically the AR Deduction Control Account). This can be changed for individual deduction codes. The GL deduction receivable account defined against the deduction code is used if it differs from the code entered here.
This is the default account to charge when a deduction is resolved for a reason other than a match to a corresponding accrual promotion account. This can be changed for individual deduction codes. The GL deduction resolution account defined against the deduction code is used if it differs from the code entered here.
This is the expense account charged when a deduction is written off and can be changed for individual deduction codes. The GL deduction writeoff account defined against the deduction code is used if it differs from the code entered here.
This is the account to which postings are made for RTS items accepted for a credit, or rejected and scrapped transactions.
This is the account to which variances (positive or negative) are posted when an RTS is accepted and the price differs from the original captured price.
This is the account to which the cost of rejected goods returned by a supplier needs to be expensed.
This is the account to which posting is made when an RTS item is accepted for credit or replacement.
The entry creates an accrual in GRN Suspense against the anticipated credit note from the supplier.
This is the account to which posting is made to decrease the cost of goods sold and to move the value of non-stocked goods returned via RMA into the RTS control account.
The RTS Journal Report must be run to generate this journal entry.
This is the account credited by the freight charges for an RTS item that has been accepted by the supplier.
The default AP control account is debited by this amount in anticipation of a supplier credit for freight charges.
This is the account credited by the handling charges for an RTS item that has been accepted by the supplier.
The default AP control account is debited by this amount in anticipation of a supplier credit for handling charges.
Copyright © 2024 SYSPRO PTY Ltd.