Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Also review Creating Leads

How Host Company Settings impact on the Debtor


Excerpt

Gliffy
namehost company and debtors
pagePin8



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

Gliffy
namepeople and companies
pagePin2

A company may be owned by a number companies or persons

...

Debtor profit and loss can include the children transactions

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.

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:

...

Note

If you do not want to also auto-email credit notes then set this option on your host company debtor profile settings and it will appear as an option on the debtor

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

...

Note

Cross Dock

If a Debtor has the Delivery to "My Buying Group" then they are a Cross Dock Customer ( the buying group picks up the stock, takes it to a DC and then delivers it to the store)

Charge Through

If a Debtor has Delivery by your company + invoice to my buying group - then they are a Charge through customer.  They will be charged using the buying group price list.

Goods not sent using the default delivery method

Note: The debtor that gets invoiced may be different if you do not send the goods to the default delivery method.  

The Invoice will still go to the buying group - but will be sent to a different entity for the buying group - see Buying Group Definition

Buying Group Definition

A buying group is a debtor in the system

...

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.

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)

...

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

...

  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.

...

Note

Requires also a profile setting to be activated


See Entering Email Templates to setup the following templates:

Note

Configurations available:

RequirementSymbol Config Required
FromEmailAddressemailaddress@yourcompany.com
FromEmailAddressAPemailaddress@yourcompany.com
FromEmailAddressARemailaddress@yourcompany.com
AutoEmailInvoices1
AutoEmailInvoiceDefault1

Image Added



Email template for Invoices: 

...

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

 


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

...

Deliver entity is unsecured – anyone can do it.

  1.  Secure FeaturesFeatures#IsEDImanager can update
    1. EDI code
  2. Secure FeaturesFeatures#CanMaintainCreditHold can update
    1. Manual Credit Hold - stop supply checkbox
    2. Never Credit Hold checkbox
    3. Never Charge Freight checkbox
  3. Secure FeaturesFeatures#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 FeaturesFeatures#IsSalesManager
    1. Price List
    2. Sequence Number
    3. Exclude Sales from Raw Data
    4. Standard Profile
  5. Secure FeaturesFeatures#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