Combine Multiple Invoices and Invoice Lines into One Invoice 2

[Dominican1979]

Hello Everyone,

Thank you in advance for reading my post. I am trying to figure how to approach this problem. My company ships stuff internationally to Asian countries and to make things easier we want to create one invoice out of multiple ones for the same customer for any given billing period. Basically a single customer may have lets say 3, 5 or however many invoices for a billing period. Each separate invoice will already have been created in our ERP system. I would like to create an invoice report that will take the following as parameters: customer number, billing period date range, and multiple invoice numbers (the number of of invoices may vary by billing period) and based on that information go out to the database and look up each invoice number and invoice lines for each one and combine them all into one report. This new invoice will be assigned a unique number from the database (haven't decided how to do that yet) but that's not the most important at the moment. I know how to create parameter input on a report, but I guess I am not sure on how to handle this multiple invoice on the report as well as on the SQL Server.

I am using Crystal Reports XI and SQL Server 2008

Thank you Soooooo much for your help!

 

[IdoMillet]

Simply have a record selection formula such as:
{Customer_ID} = {?Customer_ID} AND
{Invoice_N} in {?Invoice_N}

And design the {?Invoice_N} parameter as multi-value.

Perhaps I'm guessing at the wrong problem. It would make it easier to help you if you specify where the problem is. In other words, what's stopping you from creating this report?

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

If you create a record selection formula like this:

{Table.Customer_ID} = {?Customer_ID} AND
{Table.InvoiceDate} in {?BillingDateRange}

...then the report will pull in the correct invoices without having to specifically select them. Then if you want to, you can group on InvoiceNo and then also create summaries in the report footer as needed.

-LB

 

[Dominican1979]

Hi IdoMillet and lbass, thank you very much for taking the time to respond to my post. lbass I think your answer will work best because there is only so many invoices that will be generated for a particular customer each month, so with the date range + custNo should do the trick, didn't think about it that way. I need to find some more info from my boss regarding the shipment of these goods because I have a feeling that they may want to combine only certain invoices, but not all from this date range, but I will find out. Thanks a lot again for your help.