Focus Advanced Publishing Software Tutorial
Customer Records
The Sales Ledger enables you to
How to add a new customer record
- Go to Accounts > Sales Ledger > Customer
- Click the NEW button
- Enter a new Account Code
- Enter the Account Name
- Select an Account Type
- Click Next
- Select a Price Numberto set customer’s currency
- Click Finishto add customer record using initial setup defaults
Customer Account Types
The concept of customer account type is fundamental to the way Focus identifies who the customer is. It predetermines the destination account for all sales to them and helps to identify customers when running reports and searches. Focus identifies three broad categories:
- Trade Customers
- Non-Trade Customers
- Prospects
Under these broad categories you are able to classify your customers under names (which you make up) such as Local trade, export trade, mail order, schools, subscribers, etc. To setup account type codes
- Go to Maintenance> Preferences
- Select Defaults & Codes
- Click Account Types
- To add a new account type Click here to add a new line, then enter the following details
- Category
- Code
- Description
- Sales nominal code
- For subscription Only flag
- Order must be paid flag
- Apply postage flag
- First Line Charge
- Other Line Charges
- Maximum Charge
- Apply Per Qty flag
To assign customer account type code
- Go to Accounts > Sales Ledger > Customer
- Search for customer in the Account Code box
- On the Account Type panel, select one of Trade, Non-Trade or Prospect.
- Click on the drop-down arrow to select from a list of account type codes.
- Click Savebutton to finish.
How to edit existing customer record
- Go to Accounts > Sales Ledger > Customer
- Search for customer in the Account Code box
- Edit record
- Click Save button to finish
How to delete a customer record
- Go to Accounts > Sales Ledger > Customer
- Search for customer in the Account Code box
- Click the Delete button
NOTE: Deleting a customer code that has been used for transactions will affect the integrity of your data and the consistency of reports. Hence, Focus Advanced Publishing software will not delete a customer record with outstanding orders or transactions. If you must delete a customer record, you must first move the associated orders and transactions.
Move a customer’s sales transactions
- Go to Maintenance > Data Utilities
- Tick and expand the number 4 box beside Move Sales Transactions from branch Office to head office.
- Then enter the customer code you wish to move from in the Branch Account Codebox, and the code you wish to move to in the Head Office Account Code box
- Click OK.
Move a customer’s sales orders
- Click the drop-down arrow underneath Accounts > Sales Order Processing > Orders to selectTransfer Orders
- Enter the customer code you wish to delete in the From Old Account Codebox, and the new code in the To New Account Code
- Click OK.
How to attach customer record to a Sales Rep
- Go to Accounts > Sales Ledger > Customer
- Search for customer in the Account Code box
- Go to the General page
- Tick the Is Represented By box and select a Rep name from the drop-down box
- If the desired Sales Rep is not in the drop-down list, click the Add button to add a new Sales Rep record.
- Enter the Code and Description then click OK
- Click Save button to finish
How to display Customer Profile
- Go to Accounts > Sales Ledger > Profile
- Search for customer in the Account box
- The Transactions tab displays the selected customer’s outstanding transactions by default
See the tabs at the bottom of the window, for more sub-windows.
- Transactions
- Aged
- Orders Due
- Sales by Title
- Statements
- Consignments
- Letters
- EDI History
- Returns History
- Questionnaire
Under the option icon, untick the “Outstanding Transactions Only” option to view the full transactions history.
How to View/Print GDPR Compliance Data Portability Sheet
- Go to Accounts > Sales Ledger > Customer
- Search for product in the Product Code box
- Click the Print Preview icon or press SHIFT+ALT+P to view the GDPR Compliance Data Portability Sheet
- Click the Print icon or press CTRL+P to print the GDPR Compliance Data Portability Sheet
Cost of Sales Overview
Post costs from Purchases
Post Direct Job Transactions
Calculate unit costs
Job Profile / Enquiry
Calculate Royalty
Print, Email Royalty Statements
Post Royalty Payments
Withholding Tax on Royalty
Add Author Records
Set Royalty Rates
Set Rights Royalty