Solavel Docs
English

A restaurant chain buys for three branches. How do I invoice each branch and still see the whole chain?

Last updated

Apps: SolaCount (Professional and Simple). Outcome: one parent customer for the chain, one customer per branch with its own code, each invoice posted to the branch that ordered, and "Branch of" printed on the PDF.

#The situation

Harbor Grill Restaurants buys chairs from Palm Grove Furnishings LLC for three outlets: Marina, Old Town and Airport. Each outlet orders on its own, wants its own invoice and statement, and quotes its own code when it phones. The head office should be visible as the chain the outlets belong to. This practice case excludes tax and discounts to keep the numbers readable.

#Desired result

Four customers: the chain Harbor Grill Restaurants (HGR-000) and three branches HGR-001, HGR-002 and HGR-003, each linked to the chain. Typing HGR-002 in an invoice finds Old Town at once. Each invoice sits on its own branch statement and balance. The chain's page lists the three branches and has a group view with the chain's total. The printed invoice says "Branch of Harbor Grill Restaurants".

#What the hierarchy does and does not do

It does It does not
Link a customer to one parent customer, so the chain is identifiable. Move receivables. An invoice always belongs to the customer selected on it, and each branch keeps its own balance and statement.
Let you find a customer by its code in customer lists and document selectors. Change prices, price lists, customer groups or the document-wide Branch dimension.
Show the parent on each branch page and the branches on the parent page. Add the branches' balances into the parent's own balance. The parent's own balance stays its own.
Show a group view on the parent: the group balance, a breakdown by branch and a group statement. Include the group in AR Aging reports, which have no group option yet.
Print "Branch of" and the parent's name on the built-in PDF designs.
Let one receipt recorded on the parent settle open invoices of the parent and its branches. Let a supplier payment do the same (suppliers: one payment per branch).

Read this table before you start: it decides whether the hierarchy is the right tool.

#Before you start

You need customers.manage to create or edit customers and to link them. Layla Haddad (accountant) does the setup. Decide the code pattern first: codes are free text up to 50 characters, leading zeros are kept (00042 stays 00042), and a code can be used by only one customer in the organization. The check ignores upper and lower case and surrounding spaces, and archived customers keep their codes. A blank code is always allowed. Customers that existed before the hierarchy keep working with no code and no parent.

#Exact steps

#In SolaCount Professional

  1. Open AR (Sales) → Add Customer. Enter Name Harbor Grill Restaurants and Customer code HGR-000. Leave Parent Customer empty ("Standalone, or one branch of the chain named after its parent."). Click Save Customer.
  2. Add the first branch the same way: Name Harbor Grill – Marina, Customer code HGR-001. In Parent Customer type HGR or Harbor; the selector searches by name or code on the server. Choose Harbor Grill Restaurants · HGR-000. Click Save Customer.
  3. Repeat for Harbor Grill – Old Town (HGR-002) and Harbor Grill – Airport (HGR-003).
  4. Open the chain's page (AR (Sales) → All Customers, search HGR-000). The Customer Hierarchy card shows Parent: No parent customer. and a table of Name, Code and Status for the three branches. Open a branch: the card shows Parent: with a link back to the chain.
  5. Open Sales → Documents → Invoices and start a new invoice. In the Customer selector type HGR-002. Old Town appears with its code and the chain name under the name. Select it, add DEMO-CHAIR quantity 6 at 75, and post as usual. The invoice, its Balance Due 450 and its statement lines belong to Old Town only.
  6. Post a second invoice for Marina (4 chairs, AED 300) and a third for Airport (2 chairs, AED 150) in the same way.

To link an existing customer, open Edit Customer, choose the Parent Customer and click Update Customer. To unlink, click the remove button beside the chosen parent and save. If your organization requires approval for customer changes, the link is part of the proposal and is checked again when it is approved.

#In SolaCount Simple

  1. Open Customers → Add customer, or use + Add new customer in an invoice's Customer picker. Under More details enter Code and choose the Parent customer (the picker searches by name or code).
  2. On an existing contact click Edit, set Code and Parent customer, and save. The contact page shows a Customer Hierarchy section with the parent link and a table of branches (Name, Code, Status).
  3. In an invoice, the Customer picker finds a branch by typing its code and shows the code beside the name.

#"Branch of" on the PDF

The built-in PDF designs print Branch of Harbor Grill Restaurants (Arabic: فرع من) as the last line of the customer panel when the customer has a parent. A customer with no parent prints nothing there, and no gap is left. You need to do nothing.

If your company saved its own copy of a design, that copy keeps its own layout and does not gain the line by itself. Add the Branch of field in the designer, as described in PDF templates.

Open Preview with a branch invoice and with a standalone customer's invoice to check both. A heading typed as static text prints on every invoice; use the Branch of field instead.

#Worked numbers

Customer Code Invoice Amount (AED) Balance Due
Harbor Grill Restaurants HGR-000 none 0 0
Harbor Grill – Marina HGR-001 4 chairs × 75 300 300
Harbor Grill – Old Town HGR-002 6 chairs × 75 450 450
Harbor Grill – Airport HGR-003 2 chairs × 75 150 150

The chain's own statement and balance stay at zero. The group view (below) shows the three branches together: AED 900.

#See the whole chain

  • Chain page: the Customer Hierarchy card lists the branches with code and status; click a name to open that branch's profile, ledger and statement.
  • Group view: on the chain's page click Show group view. It shows Group balance receivable (the parent plus every branch below it, at any depth), the Overdue part, and a Breakdown by branch with each branch's own balance. Here: Marina 300, Old Town 450, Airport 150, group 900.
  • Group statement: under the breakdown choose From and To and click Apply. The Group statement lists every movement of the group with a Branch column, an opening and closing balance and a running Group balance.
  • Currencies: the group total is in your base currency, taken from the base amount of each posted line (the same method as the balance summaries). Balances in a foreign currency are listed separately under Foreign-currency balances; amounts of different currencies are never added together.
  • Balance Summary: in Reports → Receivables → Customer Balance Summary choose Group by parent to get one row per chain with its member count.
  • AR Aging: the aging reports have no group option yet. Use the group view's Overdue figure, or read the aging report per branch.
  • Excel export: the customer reference export carries code and parent code columns, so you can sort or total the chain in a spreadsheet.
  • The parent's own balance still shows only documents entered on the parent itself. Use the group view for the chain total.
  • Simple: open the parent contact and click Show group view; it has the same balance, breakdown and statement.

#Bulk import with parents

On All Customers → Bulk Upload, the template has Customer Code and Parent Customer Code columns. A parent may appear later in the same file. Each row is checked: a parent code that does not exist, a customer that is its own parent, a loop, an archived parent or a code repeated in the file is reported with the row number. When customer creation needs approval, the parent must already exist as a customer; import the chain first, then the branches.

#Check your result

Check Expected
Chain page Three branches listed with code and Active
Each branch page Parent shows the chain with its code
Invoice selector, type HGR-002 Only Old Town, with its code
Branch statement Only that branch's invoice
Chain statement No lines
Group view on the chain Group balance 900: Marina 300, Old Town 450, Airport 150
Invoice preview "Branch of Harbor Grill Restaurants" on branch invoices only

#Rules to know

  • A customer cannot be its own parent, and a loop (the chain under one of its own branches) is refused with a message naming both customers.
  • You cannot choose an archived customer as a parent.
  • A parent with active branches cannot be archived or merged away; a parent with any branch, archived ones included, cannot be deleted. Reassign or unlink the branches first.
  • An archived branch cannot be restored while its parent is archived.
  • Renaming the parent shows the new name on every branch at once.
  • Code and parent changes are written to the audit trail with the previous and new values.

#Common mistakes

  • Expecting the parent's own balance or statement to include branch sales. Use the group view for the total. Invoice the customer who ordered, or choose the chain as the customer if head office is the real buyer.
  • Using the document Branch dimension for this. They are independent: that dimension reports your own locations on document lines and is not set by choosing a branch customer.
  • Re-using a code. Codes are unique across active and archived customers.
  • Merging a branch into the wrong customer. Merging is permanent; the parent must have no active branches first.

Head office pays for its branches, Customers, Contacts (Simple), PDF templates, Customer statements and sales reports, Customer order to payment, Business Solutions & Examples.