Complex invoicing

[qubit]

Hi,

I have installed the invoice payment module which works very well.

I have a query on invoicing, and if anyone could point me in the right direction it would be much appreciated.

The majority of customers will be purchasing via invoice for their hotel which is part of a chain. So the customer will be the purchasing manager for the individual hotel but the company will be the head office. Every month I need to invoice the head office with the total amount for all the individual hotels (including details on how many of the product each hotel purchased).

Is this acheivable? Thanks in advance for any information.

Q

[wolfsz]

Hi there
Unless someone has a better idea I would do this be creating a SQL report to extract the relevant orders from the order and order_totals tables. Sorry, we are renovating our offices at the moment and my network is down and I only have my notebook PC connected so I can't include some SQL queries I usually use as examples. However here is a previous post with an issue somewhat similar to yours to get you started:
http://www.zen-cart.com/forum/showthread.php?t=54465

[qubit]

That's brilliant. Thanks a lot :)

Q