Debtors (Sales Ledger)
Customers, Invoices, Credit Control, Direct Debits, Allocations
92 articles
Sales Invoice from FocalPoint has posted into Dimensions with negative values
Chase Debtors – Functions
Add an address to a customer or supplier record
Setup 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 the Revalue Debtors or Creditors in a currency record 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
Correct a record using Corrections
When running Aged Debtors as at date, some transactions that should not be showing appear on the report