Debtors (Sales Ledger)
Customers, Invoices, Credit Control, Direct Debits, Allocations
110 articles
- Sales invoice from FocalPoint posted into Dimensions with negative values
- Chase Debtors – Functions
- Add an address to a customer or supplier record
- Set up and process a direct debit
- Change a customer vat status once transactions are posted. or use additional VAT status codes
- Add a new Customer Record?
- View most recent change to customer, suppliers, company etc.
- Post transactions for a currency supplier or customer in different currencies
- Write off bad debts in the Sales Ledger
- Link sales customer records to a head office
- SOP Estimate Batch enquiry screen is showing the customer head office name
- Information on backups managed for our databases hosted with Access
- Update an email address for Customer / Supplier
- What does Revalue Debtors or Creditors do?
- Export a list of suppliers or customers to Excel
- Manually Allocate Sales or Purchase Transaction
- Bulk update the sort key in multiple customer accounts
- Run Sales Statements (for specific Customers)
- Set a customer or supplier to use a different invoice or report template
- Which SQL table holds the custom user fields on customer records
- When raising invoices for an EU supplier/customer, it is using a different VAT code to what has been set against the supplier/customer
- Report to find which invoices were posted in error from the post batch option
- Aged debtor vs control account agrees as a whole but there is a difference between currencies
- change an account from being a 'Non-EU State' to 'EU State'
- Error - 'Currency defaults have not been specified for the selected sub ledger and customer currency' when trying to allocate
- Restrict access to editing transations on the ledger
- Error - 'This record is currently being used and cannot be flagged as Inactive' when trying to make a customer inactive
- Matching currency transactions and the exchange difference went to rounding
- Edit a customer record code once created
- Post contra entries between Sales and Purchase Ledgers
- Undo incorrect merging of customer accounts
- When running our statement for customer XXXX a zero line ADR transaction appears on the first screen
- Viewing and editing inactive customer records
- How many e-mail addresses can we put against a customer record?
- Allocations not balancing to zero
- No option to reprint a Sales Invoice
- Multiple invoices for different customers sent by e-mail to another customer (GDPR Issue)
- Produce previous customer statements as at a certain period
- Customer balance not matching amount outstanding
- Remove the No Entry On Stop sign
- Email sales statements to specific customers
- Send multiple statements to customers with one click
- Customer balance does not match transaction balance
- Amend an incorrectly dated sales ledger allocation
- Old document information for multiple customer and supplier accounts included in single remittance document via email
- Make an analysis code inactive
- Flag a transaction as Disputed
- Change the Default Bank Account
- Process to Revalue Foreign Currency Bank Accounts
- Amend the rounding analysis code on Allocation
- Change bank details for a company
- Change/add company delivery addresses
- Reverse a transaction using Corrections
- Create Sales Analysis Codes
- Error: 'This query has taken too long to process, please add more search criteria to limit the amount of data that needs to be retrieved' (Access Hosted Client)
- Assistance to un-allocate transactions (fully allocated)
- Write off bad debts
- Change the default filter options on the transaction enquiry screen
- Error 'The transaction ended in the trigger. The batch has been aborted.'
- Prevent duplicate invoice numbers?
- Error - 'SQL Error 37000 (Microsoft) (ODBC SQL SERVER DRIVER) A sales ledger invoice already exists with invoice number **X** Please use reset print status to enable these orders to be printed on a new invoice' (Access Hosted Clients)
- Can you add text to a Sort Key on a Record which is lower case?
- Change the default analysis code for Sales
- Use corrections to amend an invoice
- Change the period after posting transactions to an incorrect period
- Allocation has not updated the outstanding balance on a transaction (non-currency)
- Error - 'Arithmetic overflow error converting expression to data type datetime.' when changing a transaction date using corrections
- Reverse a journal using corrections
- Error '...23000:[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object'
- Error - 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression'
- Aged Debtors does not equal my Sales Control Account
- Error - 'The selected transactions cannot be allocated. Unable to find a X rounding analysis'
- Unable to delete transaction from post batch, SQL error received
- Error - 'The Application was unable to insert into the table...' or 'The Stored Procedure... has failed...' when posting transactions
- Change field names
- Export Aged Debtors Report to excel
- Error - 'The EXECUTE permission was denied on the object xxxxx when editing a record
- Error - 'The currency for analysis code XXX is not the same as the transaction currency' when editing transaction from batch
- Change the period after posting transactions to correct period in PL but showing incorrect an incorrect period in NL
- Error - 'You cannot continue with the Period End as there are rollback transactions in the Current Batch' (Sales Ledger)
- This transaction has been partially rolled back during a crash and is awaiting reposting. It cannot be edited.
- Cannot correct Journal with Corrections, journal does not balance in 2nd base values
- Unable to allocate to an earlier period than already allocated to
- Correct when Transactions Debiting or Crediting wrong accounts
- Set up A Debtors Letter
- Change the Analysis code on fully posted transactions
- Error - 'Violation of Primary Key Constraint' when inserting a record
- Error - 'Journal does not balance! Please amend details before posting' when trying to post a journal from batch
- Use corrections to delete a transaction
- Access to historical detailed transaction data
- When running Aged Debtors as at date, some transactions that should not be showing appear on the report
- Make a Customer/Supplier Inactive
- Cannot delete transactions using corrections
- Change the due date on a transaction
- Aged crystal report does not match aged standard report and one or more accounts shows a double chevron
- Transaction due dates do not reflect the customer terms settings
- Reprinting multiple invoices
- Order of Precedence for VAT
- Cannot choose or use the VAT code for Reverse Charge VAT
- Run the audit report
- Rounding differences value not expected when allocating currency sales invoices
- Using VAT code X for a reverse charge transaction for an EU Customer
- Error: 'You cannot continue with the year end as there are rollback transactions in the current batch when processing the year end for sales or purchase ledger'
- Export customer and supplier transactions to Excel
- Allocated Sales Invoice still showing as outstanding
- Change the Payment Terms on a Customer Record
- Error - 'There are no available debtors letters to print for Debtors Letter' (credit control)
- Export a list of our customers and their respective email addresses to Excel
- Allocated or unexpected transactions are showing in Aged Debtors report
- What should I do if I accidentally roll forward a ledger to the wrong period?