...

Also review Creating Leads

How Host Company Settings impact on the Debtor

Branches of your Host Company

Branches are optional in the system

...

Selection of any of these profiles will cause the profile to appear on Debtor / Creditor cards in the system

Is distributor = can purchase "Buy Only" items

Is courier = will be in courier dropdown lists

Provides Leads = can link a new lead to them and provide a report 

Global Persons and Companies

A Person and a Company may be Global - ie visible and a single record across Host Companies.

Owner host company code shows in Advanced Extended Attributes of Person and Company. Will show blank if global.

The relationships between Companies, Persons and Debtors

A company may be owned by a number companies or persons

...

On the company card you can see all the children

Debtor profit and loss can include the children transactions

Image Added

Recent Sales Report

View the profitability by item sold.  Average cost uses the cost at the time of the order.  Average cost for Supplier Direct to Customer orders uses PO landed cost value.

Image Added

Auto emailing Invoices and Credit Notes

If Auto email invoices is ticked then both invoices and credit notes are emailed immediately they are created.

Image Added

Who gets the emails?

1. The system checks who gets the invoices.  Debtors can be invoice me, invoice my parent or invoice my buying group
2. On the entity that gets the invoices AND on the entity that placed the Order
   1. Any contact that has a role of type "Accounts" on the Debtor
   2. Any AP email address from the Entity Card
   3. If none of the above exist - then the email address on the Debtor card for the invoice entity only
   4. If none of the above exist - then the email address on the Company/ person card for the invoice entity only

The email

1. A PDF of the invoice will be attached.
2. Email logged in Correspondence of debtor and invoice.

The email template used for invoices:

Image Added

The email template used for Credit Notes

Image Added

Sending invoices to a Parent Company or Buying Group

On the Debtor 

If an order customer has

• "invoice my buying group" or "invoice my parent"
• and the buying group or parent has "auto email invoices"
• then email the invoice to the buying group or parent when created

Parent Company Statements

...

Buying Group Definition

A buying group is a debtor in the systemThe

Normally when a customer is a member of a buying group will receive invoices - hence it is a debtor in the system= they place orders and the invoices will be paid by the Buying Group.

A special case is Buying Groups that invoice from a different entity if they do the delivery to the store ( normally they will charge the store a greater markup) - this is the Alternate on the Buying Group

Image Added

Sending goods to the Buying Group DC

The buying group may be the delivery address - If if there are multiple addresses on the buying group debtor then the system looks for the one flagged as the DC.

What happens if goods are not sent via the DC

Some buying groups have a different debtor invoiced if you do not send the goods via their DC - this does not apply to all buying groups

There is two debtors listed on the Buying group Definition

Image Removed

The first debtor is the default - if there is no debtor listed in the Alternate debtor and the customer has "Invoice my buying group" then the invoice always goes to the Owner regardless of the delivery method

The second debtor is only used if

...

To make a debtor a member of a buying Group

Any Debtor may be a member of a buying group

...

Note that if the Debtor is the owner or alternate of a buying group the field will not be selectable.

If the Buying Group delivers the goods to store by default

ie if goods are delivered to the Buying Group DC and they deliver to the store (can be over-ridden on the sales order)

Image Added

Debtor Main Screen

Key information that is commonly required is on the main screen area.  

Customer Addresses

The company card will have an address - if no other address is found then this is used on sales orders

When the company has departments setup (eg Dairy, Drygoods etc) then an address may be the default for a department

If the customer has addresses at the debtor level - then these will be available options on the sales order using priority if defined

The number of days delivery on the address is the default number of days from XWarehouse date to customer receipt to go on the sales order

Persons who can login on behalf of a company

Normally required to a website for placing orders or to a Portal to view information

First the company must allow login

Image Added

Add the person as a Contact on the Debtor Form

Image Added

Ensure they have the website menu and tick "Allow Login"

Image Added

Ensure the person has a login code and password setup

Image Added

How to tell if a contact is allowed to login to see the debtor information

Image Added

Credit Cards

Credit Cards stored on Person

Credit Cards are always personal - a person is responsible for the card - so they are held on the person

Image Added

The credit cards held by contacts at the company can be used to make payments

Image Added

Trading Terms Explained

Trading terms includes

1. Days and Reference Type = difference between invoice date and due date = here the due date is based on 30 days from invoice date.  Changing the terms will change due dates on all open invoices
2. Order Discounts = automatically applied discount to all lines on an order
   1. Note Order Discounts will not apply to order lines with Promotions of any kind including Pricing Contracts
3. Settlement discount = A discount that can be manually applied if an invoice is paid within terms
4. Trading Terms (Off Invoice) = A discount that is automatically applied when an invoice is created by creating a credit note for the amount of the trading terms at the time the invoice is created
   1. The credit note that is created will be allocated to the invoice - unless you have selected "do not allocate trading terms credit notes" on the customers "Standard Profile"
5. If a company does not want a per invoice trading agreement - instead based on revenue over a period of time - this is best done manually as a credit note with supporting documentation.

Auto-Email Invoices

Invoices are emailed once an invoice is marked delivered.

Image Added

See Email Templates to setup the following templates:

Email template for Invoices: 

Image Added

Email Template for Credit Notes:

Image Added

Debtor Ageing can be shown for any date

Shows the amount owing compared with the Due Date.

So All Current is within payment terms.  All other amounts are out of payment terms.

This Debtor has amounts 7 days, 14 days and 30 days overdue = sums to total overdue.

Image Added

The Payment Due is the amount and date that a payment must be made to remain in terms.  This date may be in the past.

Image Added

Deliver Address

Setup the addresses and determine if they are an office or a delivery address

Image Added

Detailed information is the concertina

...

A Rating - used only for scarce stock allocation

Invoicing Rules

Invoice : who pays my invoice

...

If New Debtors require approval then:

1. Users with Secure Feature "Can Maintain Debtor Terms" can make debtors active
2. Users without this secure feature will create Debtors in status "Proposed" status
3. Orders placed on users in "Proposed" Status will be on hold until the debtor is made active.

...

To Make a debtor inactive - put an end date on the debtor (this can be in the past or the future).

See Archiving Debtors including "Collect Only" status to explain the process involved if the customer still has debt owing

See Collecting Debt from Customers for collecting processes

Persons - First name First in lists

Image Added

Secure Features that Affect the Debtor Card

Deliver entity is unsecured – anyone can do it.

1.  Secure Features#IsEDImanager can update
   1. EDI code
2. Secure Features#CanMaintainCreditHold can update
   1. Manual Credit Hold - stop supply checkbox
   2. Never Credit Hold checkbox
   3. Never Charge Freight checkbox
3. Secure Features#CanMaintainDebtorTerms can update
   1. Terms Days
   2. Term Type
   3. Invoice Discount
   4. Buying Group
   5. Invoice Entity
   6. Vendor Code
   7. Bank Account Number
   8. Bank Branch
   9. Bank Transaction Identifier
   10. Account Name
   11. Commission Rate
   12. Statement Frequency
   13. Auto email Invoice
4. Secure Features#IsSalesManager
   1. Price List
   2. Sequence Number
   3. Exclude Sales from Raw Data
   4. Standard Profile
5. Secure Features#CanMaintainDebtorSalesRep 
   1. Sales Rep

Foreign Currency Debtor Payments

1. Financials menu, Advanced, Foreign currency debtor payment:
   1. Must be used if customer uses FC.
   2. Must not be used if customer does not use FC.
   3. Automatically used if:
      1. Debtor payment opened from FC customer's Transactions list.
      2. New payment started from FC customer's Action menu,
         1. FC amount from customer's total FC owing.
         2. AUD amount from customer's Total Owing.
         3. FX rate calculated as the relative rate between them.
      3. 'Record a payment for this invoice' chosen from FC debtor invoice Action menu:
         1. FC amount from invoice open FC amount.
         2. FX rate from invoice.
         3. AUD amount calculated from FC amount using FX rate.
   4. When a customer is selected on an FC debtor payment form:
      1. FC amount from customer's total FC overdue (i.e. excluding current). 
      2. AUD amount from customer's Payment Due.
      3. FX rate calculated as the relative rate between them.
   5. On a new FC debtor payment the bank account will default to the lowest sequence bank account in the same currency as the customer. If no bank account in the customer's currency then the default debtor bank account.
   6. The FC amount, the FX rate and the local amount are all editable on a FC debtor payment form.
   7. If the FX rate is empty and either the FC or local amount is changed then the FX rare will be calculated as the relative rate between them.
   8. If the FC amount is changed then the local amount will be recalculated using the FX rate.
   9. If the local amount is changed then the FC amount will be recalculated using the FX rate.
   10. If the FX rate is changed then the local amount will be recalculated using the FC amount.
2. Allocation:
   1. If a FC debtor payment is allocated to an invoice with a different FX rate then an adjustment journal will be written for the difference between the allocation amount converted to local currency using the payment FX rate and the allocation amount converted to local currency using the invoice FX rate.
   2. The adjustment journal will have local currency amounts only.
3. Local currency bank account:
   1. If a FC debtor payment is made to a local currency bank account then the Trade Debtors line will have an FC amount but the bank line will not.

Custom Profile - Fixed Courier

1. If a Marketplace has a Fixed Courier this can be configured on the Custom Profile - Fixed Courier - either TPW or Australia Post
2. To ensure the change take affect right away - Administration Menu - Clear all caches

Image Added