Troubleshoot unconverted or incorrectly mapped transactions | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/troubleshoot-unconverted-transactions Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Troubleshoot unconverted or incorrectly mapped transactions Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Find why a source record did not convert or posted to unexpected ledger accounts. Audience: Finance administrators; Feature: Conversion troubleshooting; Module v1.4.5; Where to goAccounting → Transactions and Accounting → Settings → Mapping Setup (https://pixiecrm.com/help-centre/topic/mapping) Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Transactions View and Settings View/Edit. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver (https://pixiecrm.com/help-centre/topic/approval). What you’ll accomplish Find why a source record did not convert or posted to unexpected ledger accounts (https://pixiecrm.com/help-centre/topic/chart-of-accounts). It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping (https://pixiecrm.com/help-centre/topic/mapping) flow rather than a generic spreadsheet process. How it works Because the module supports many sources, the required mapping (https://pixiecrm.com/help-centre/topic/mapping) differs by workflow. An invoice (https://pixiecrm.com/help-centre/topic/invoice) needs receivable, income and tax mappings (https://pixiecrm.com/help-centre/topic/tax); an expense (https://pixiecrm.com/help-centre/topic/expense) needs category, payment (https://pixiecrm.com/help-centre/topic/payment) and tax mappings (https://pixiecrm.com/help-centre/topic/tax); a warehouse (https://pixiecrm.com/help-centre/topic/warehouse) event needs inventory and cost mappings (https://pixiecrm.com/help-centre/topic/mapping). Status hooks are important. A draft or unapproved record may correctly remain unconverted. If conversion code reports (https://pixiecrm.com/help-centre/topic/report) an exception, retain the record identifiers and server log evidence for technical support without exposing confidential financial data. Follow these steps - Go to the source record and note its type, status, date and currency (https://pixiecrm.com/help-centre/topic/currency). - Check (https://pixiecrm.com/help-centre/topic/check) whether the transaction appears in the appropriate Accounting tab. - Check automatic-conversion settings. - Check all relevant mappings (https://pixiecrm.com/help-centre/topic/mapping) and account active status. - Check (https://pixiecrm.com/help-centre/topic/check) for an existing converted record or error indicator. - Correct one cause at a time and retest with a controlled record. - Use transaction and ledger reports (https://pixiecrm.com/help-centre/topic/report) to confirm the result. Settings to check Source statusThe record may not yet be in an eligible state. Automatic conversion switchCan be disabled globally or for the integration. Mapping (https://pixiecrm.com/help-centre/topic/mapping) completenessRequired account mapping (https://pixiecrm.com/help-centre/topic/mapping) may be absent or inactive. Account statusA mapped account may be deactivated. Optional moduleThe integration may be inactive or incompatible. Existing conversionA duplicate-prevention marker may already exist. Check it worked After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits (https://pixiecrm.com/help-centre/topic/double-entry) must balance and the accounts must match the approved mapping (https://pixiecrm.com/help-centre/topic/mapping) or manual selection. - Open the saved record and confirm its final status. - Review the source reference and every debit and credit (https://pixiecrm.com/help-centre/topic/double-entry) line where ledger data was created. - Use the relevant register, ageing, reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) or report (https://pixiecrm.com/help-centre/topic/report) to verify the wider effect. Common mistakes to avoid - Do not repeatedly click Convert without diagnosing the cause. - Do not map to a random account to pass validation. - Do not remove duplicate protection without code review. - Pause bulk automation when a systemic mapping (https://pixiecrm.com/help-centre/topic/mapping) error is found. - Use the least destructive correction available and record the reason for material changes. - Do not bypass a permission, approval (https://pixiecrm.com/help-centre/topic/approval) or closed-period control by changing unrelated data. Accounting and data safetyDeletion, reset, void, refund, mapping (https://pixiecrm.com/help-centre/topic/mapping), journal and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report (https://pixiecrm.com/help-centre/topic/report). Browse connected topics:invoice (https://pixiecrm.com/help-centre/topic/invoice)payment (https://pixiecrm.com/help-centre/topic/payment)expense (https://pixiecrm.com/help-centre/topic/expense)reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)Chart of Accounts (https://pixiecrm.com/help-centre/topic/chart-of-accounts)check (https://pixiecrm.com/help-centre/topic/check)report (https://pixiecrm.com/help-centre/topic/report)tax (https://pixiecrm.com/help-centre/topic/tax)currency (https://pixiecrm.com/help-centre/topic/currency)purchase (https://pixiecrm.com/help-centre/topic/purchase)warehouse (https://pixiecrm.com/help-centre/topic/warehouse)payroll (https://pixiecrm.com/help-centre/topic/payroll)credit note (https://pixiecrm.com/help-centre/topic/credit-note)manufacturing (https://pixiecrm.com/help-centre/topic/manufacturing) Related guides Accounting mapping setup overview (https://pixiecrm.com/help-centre/mapping-setup-overview)Accounting transaction centre overview (https://pixiecrm.com/help-centre/transaction-centre-overview)Review, correct or delete converted transactions (https://pixiecrm.com/help-centre/review-edit-or-delete-converted-transactions)Enable Accounting access and permissions (https://pixiecrm.com/help-centre/enable-accounting-access-and-permissions)Convert sales invoices to Accounting (https://pixiecrm.com/help-centre/convert-sales-invoices-to-accounting)Convert invoice payments to Accounting (https://pixiecrm.com/help-centre/convert-invoice-payments-to-accounting)