General Ledger Integration
SYSPRO Ribbon bar > Setup > Setup Options > General Ledger Integration
 General Ledger
General Ledger
                                                                 Accounts payable integration methods
Accounts payable integration methods
                                                                         Integration level
Integration level
                                                                                 Not linked to GL distribution report
Not linked to GL distribution report
                                                                                        This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
 Linked to GL in summary
Linked to GL in summary
                                                                                        This prints detail entries on the Expense and Disbursement distribution reports to be summarized by ledger code before being posted to GL.
 Linked to GL in detail
Linked to GL in detail
                                                                                        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.
 Control account in detail
Control account in detail
                                                                                        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.
 Create general ledger journal
Create general ledger journal
                                                                                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.
 Post general ledger journal
Post general ledger journal
                                                                                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.
 Force check no
Force check no
                                                                                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.
 Force general ledger analysis
Force general ledger analysis
                                                                                 Transaction entry
Transaction entry
                                                                                        This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
 GL journal posting
GL journal posting
                                                                                        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.
 Dimension analysis
Dimension analysis
                                                                                 Not required
Not required
                                                                                        This indicates that Dimension analysis is not required in the sub-module.
 Transaction entry level
Transaction entry level
                                                                                        This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
 GL entry level
GL entry level
                                                                                        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.
 Accounts receivable integration methods
Accounts receivable integration methods
                                                                         Integration level
Integration level
                                                                                 Not linked to GL distribution report
Not linked to GL distribution report
                                                                                        This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
 Linked to GL in summary
Linked to GL in summary
                                                                                        This prints detail entries on the Payments and Sales distribution reports to be summarized by ledger code before being posted to GL.
 Linked
  to GL in detail
Linked
  to GL in detail
                                                                                        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.
 Control account in detail
Control account in detail
                                                                                        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.
 Create general ledger journal
Create general ledger journal
                                                                                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.
 Post general ledger journal
Post general ledger journal
                                                                                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.
 Force general ledger analysis
Force general ledger analysis
                                                                                 Transaction entry
Transaction entry
                                                                                        This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
 GL journal posting
GL journal posting
                                                                                        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.
 Dimension analysis
Dimension analysis
                                                                                 Not required
Not required
                                                                                        This indicates that Dimension analysis is not required in the sub-module.
 Transaction entry level
Transaction entry level
                                                                                        This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
 GL entry level
GL entry level
                                                                                        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.
 Cash book integration methods
Cash book integration methods
                                                                         Integration level
Integration level
                                                                                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
 Not linked to GL distribution report
Not linked to GL distribution report
                                                                                        This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
 Linked to GL in summary
Linked to GL in summary
                                                                                        This prints detail entries on the Cash Book distribution report to be summarized by ledger code before being posted to GL.
 Linked
  to GL in detail
Linked
  to GL in detail
                                                                                        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.
 Control account in detail
Control account in detail
                                                                                        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.
 Create general ledger journal
Create general ledger journal
                                                                                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.
 Post general ledger journal
Post general ledger journal
                                                                                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.
 Force general ledger analysis
Force general ledger analysis
                                                                                 Transaction entry
Transaction entry
                                                                                        This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
 GL journal posting
GL journal posting
                                                                                        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.
 Dimension analysis
Dimension analysis
                                                                                 Not required
Not required
                                                                                        This indicates that Dimension analysis is not required in the sub-module.
 Transaction entry level
Transaction entry level
                                                                                        This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
 GL entry level
GL entry level
                                                                                        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.
 Inventory integration methods
Inventory integration methods
                                                                         Integration level
Integration level
                                                                                 Not linked to GL distribution report
Not linked to GL distribution report
                                                                                        This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
 Linked to GL in summary
Linked to GL in summary
                                                                                        This prints detail entries on the Inventory distribution report to be summarized by ledger code before being posted to GL.
 Linked
  to GL in detail
Linked
  to GL in detail
                                                                                        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.
 Control account in detail
Control account in detail
                                                                                        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.
 Create general ledger journal
Create general ledger journal
                                                                                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.
 Post general ledger journal
Post general ledger journal
                                                                                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.
 Force general ledger analysis
Force general ledger analysis
                                                                                 Transaction entry
Transaction entry
                                                                                        This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
 GL journal posting
GL journal posting
                                                                                        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.
 Dimension analysis
Dimension analysis
                                                                                 Not required
Not required
                                                                                        This indicates that Dimension analysis is not required in the sub-module.
 Transaction entry level
Transaction entry level
                                                                                        This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
 GL entry level
GL entry level
                                                                                        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.
 Assets integration methods
Assets integration methods
                                                                         Integration level
Integration level
                                                                                 Not linked to GL distribution report
Not linked to GL distribution report
                                                                                        This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
 Linked to GL in summary
Linked to GL in summary
                                                                                        This prints detail entries on the Assets distribution report to be summarized by ledger code before being posted to GL.
 Linked
  to GL in detail
Linked
  to GL in detail
                                                                                        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.
 Create general ledger journal
Create general ledger journal
                                                                                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.
 Post general ledger journal
Post general ledger journal
                                                                                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.
 Force general ledger analysis
Force general ledger analysis
                                                                                 Transaction entry
Transaction entry
                                                                                        This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
 GL journal posting
GL journal posting
                                                                                        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.
 Dimension analysis
Dimension analysis
                                                                                 Not required
Not required
                                                                                        This indicates that Dimension analysis is not required in the sub-module.
 Transaction entry level
Transaction entry level
                                                                                        This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
 GL entry level
GL entry level
                                                                                        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.
 Work in progress integration methods
Work in progress integration methods
                                                                         Integration level
Integration level
                                                                                 Not linked to GL distribution report
Not linked to GL distribution report
                                                                                        This generates a distribution report from which manual postings to GL can be made. Accounts aren't validated and account descriptions aren't printed.
 Linked to GL in summary
Linked to GL in summary
                                                                                        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.
 Linked to GL in detail
Linked to GL in detail
                                                                                        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.
 Control account in detail
Control account in detail
                                                                                        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.
 Create general ledger journal
Create general ledger journal
                                                                                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.
 Post general ledger journal
Post general ledger journal
                                                                                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.
 Force general ledger analysis
Force general ledger analysis
                                                                                 Transaction entry
Transaction entry
                                                                                        This forces you to enter GL analysis information at the time the transaction is processed in the sub-module.
 GL journal posting
GL journal posting
                                                                                        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.
 Apply integration level at
Apply integration level at
                                                                                 Company level
Company level
                                                                                        This applies integration to General Ledger using the ledger accounts defined against the WIP company options.
 WIP branch level
WIP branch level
                                                                                        This applies integration to General Ledger using the ledger accounts defined against the WIP branch.
 Job classification level
Job classification level
                                                                                        This applies integration to General Ledger using the WIP branch and ledger accounts defined against the job classification.
 Dimension analysis
Dimension analysis
                                                                                 Not required
Not required
                                                                                        This indicates that Dimension analysis is not required in the sub-module.
 Transaction entry level
Transaction entry level
                                                                                        This indicates that Dimension analysis must be triggered at the time of posting transactions in the sub-module.
 GL entry level
GL entry level
                                                                                        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.
 General ledger control accounts
General ledger control accounts
                                                                         Forced balance
Forced balance
                                                                                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.
 Retained earnings
Retained earnings
                                                                                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.
 Payables
Payables
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Default merchandise
Default merchandise
                                                                                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.
 Default freight
Default freight
                                                                                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.
 Input tax
Input tax
                                                                                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.
 EC VAT acquisition
EC VAT acquisition
                                                                                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).
 Withholding tax control
Withholding tax control
                                                                                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.
 Default QST control
Default QST control
                                                                                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.
 QST discount control
QST discount control
                                                                                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.
 Contra suspense
Contra suspense
                                                                                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.
 Auto vouchering tax accrual
Auto vouchering tax accrual
                                                                                This is the account to which tax accrual entries are posted for suppliers whose tax assessment is defined as Self (USA tax only).
 Tax relief/recovery
Tax relief/recovery
                                                                                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.
 Ledger descriptions
Ledger descriptions
                                                                         Description for merchandise
Description for merchandise
                                                                                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.
 Description for freight
Description for freight
                                                                                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.
 Description for tax input
Description for tax input
                                                                                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.
 Receivables
Receivables
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Exchange rate variance
Exchange rate variance
                                                                                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.
 Withholding tax control
Withholding tax control
                                                                                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.
 Adjustment value (tax)
Adjustment value (tax)
                                                                                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.
 Contra suspense
Contra suspense
                                                                                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.
 Tax relief/recovery
Tax relief/recovery
                                                                                This account is used for tax relief and recovery in Accounts Receivable (reserved for future use).
 Balance correction rounding
Balance correction rounding
                                                                                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.
 Balance correction control
Balance correction control
                                                                                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.
 Cash Book
Cash Book
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Inter-company
Inter-company
                                                                                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.
 Tax for deposits
Tax for deposits
                                                                                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.
 Tax for withdrawals
Tax for withdrawals
                                                                                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.
 Interbank transfer suspense
Interbank transfer suspense
                                                                                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.
 Ledger descriptions
Ledger descriptions
                                                                         Description for deposits
Description for deposits
                                                                                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.
 Description for withdrawals
Description for withdrawals
                                                                                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.
 Inventory
Inventory
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Non-stocked
Non-stocked
                                                                                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.
 Cost of goods sold adjustment
Cost of goods sold adjustment
                                                                                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.
 Subcontract operations
Subcontract operations
                                                                                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.
 GRN suspense
GRN suspense
                                                                                This is the account to which distribution entries are posted during processing within the AP Invoice Posting program, where GRN matching is selected.
 Purchase price variance
Purchase price variance
                                                                                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.
 ABC costing variance
ABC costing variance
                                                                                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.
 Goods in transit
Goods in transit
                                                                                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.
 Dispatched but not invoiced
Dispatched but not invoiced
                                                                                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.
 Assets
Assets
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Assets control
Assets control
                                                                                This is the account to which the cost/value amounts are posted for asset additions, asset disposals and changes to asset cost/value amounts.
 Profit and loss
Profit and loss
                                                                                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.
 Capex in progress
Capex in progress
                                                                                This is the account that is 
 Revaluation reserve
Revaluation reserve
                                                                                This is the account to which postings are made when an asset is revalued using the Asset Revaluation program.
 Asset clearing
Asset clearing
                                                                                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 
 Depreciation
Depreciation
                                                                                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).
 Accumulated depreciation
Accumulated depreciation
                                                                                This is the balance sheet account to which book value depreciation amounts are posted.
 Asset inter-company clearing
Asset inter-company clearing
                                                                                This is the clearing account used when transferring assets between SYSPRO companies.
 Profit and loss inter-company
Profit and loss inter-company
                                                                                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.
 Work in Progress
Work in Progress
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Work in progress
Work in progress
                                                                                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.
 Variance
Variance
                                                                                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.
 Automatically cleared variances
Automatically cleared variances
                                                                                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.
 WIP inspection
WIP inspection
                                                                                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.
 Branches
Branches
                                                                                This lets you define ledger accounts for each branch when Work in Progress is integrated to General Ledger by branch.
 Job classifications
Job classifications
                                                                                This lets you define the ledger accounts for each job classification when Work in Progress is integrated to General Ledger by job classification.
 Trade Promotions
Trade Promotions
                                                                 General ledger control accounts
General ledger control accounts
                                                                         Promotion accrual
Promotion accrual
                                                                                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.
 Promotion expense
Promotion expense
                                                                                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.
 Deduction receivable
Deduction receivable
                                                                                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.
 Deduction resolution
Deduction resolution
                                                                                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.
 Deduction writeoff
Deduction writeoff
                                                                                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.
 Return to Supplier
Return to Supplier
                                                                 General ledger accounts
General ledger accounts
                                                                         Control
Control
                                                                                This is the account to which postings are made for RTS items accepted for a credit, or rejected and scrapped transactions.
 Variance
Variance
                                                                                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.
 Scrap
Scrap
                                                                                This is the account to which the cost of rejected goods returned by a supplier needs to be expensed.
 GRN offset
GRN offset
                                                                                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.
 RMA credit
RMA credit
                                                                                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.
 Freight
Freight
                                                                                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.
 Handling
Handling
                                                                                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.