• From: USA, Colorado
  • Registered: 07/19/2018
  • Posts: 25

Topic: 1 Customer who has 50 customers

We have a single customer (Call them ABC Corp.) that wants us to drop ship our product to their many customers around the US. We only invoice our customer.

They also want us to be able to tell them how many units were shipped to each customer every week.

Is there a way to set up a single customer (ABC Corp.) and have their customers be a sub-group and roll up to the single customer level (ABC Corp.)?

Example:

ABC Corp (our customer)
-ABC Corp Customer 1
-ABC Corp Customer 2

scott.randall's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 629

Re: 1 Customer who has 50 customers

Would customer branches be sufficient? Try it out on your training copy first.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: 1 Customer who has 50 customers

Since you are only drop shipping it, have a separate PHP Application or FA module made that reads from the FA tables and do it as a cron job for population of the new application/module's tables. The only real page for the application/module would be to choose the drop ship customer and provide reports. This way, you need not divulge the rates / prices of your real customer to their downlines.

apmuthu's Website

  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: 1 Customer who has 50 customers

Branches are a good suggestion, but FA support for reporting/inquiry by branch is limited.  I have been working to improve this in my fork and you might be able to rework this commit to FA (ignore the first two ui_lists.inc changes).

See also, https://frontaccounting.com/punbb/viewtopic.php?id=8379.