How to find total sales invoice amount for a sale order?

kenl

Hello,

I need to find the total sales invoice amount for a sales order. Do you have any suggestion for this?

I need to capture two ways of sales invoice:

case 1) Post invoice directly in sales order
case 2) Create a consolidate sales order with type "Invoice".

Case 1 is easy to find, but I have troblem for case 2.

Any idea? :-k

Marije_Brummel

I am not sure I understand you correctly. What are you trieing to do.

There is a amount field available on the sales header that is populated when the sales order/invoide is released. But somehow i donnot think this is what you mean.

Could you be more specific please?

DenSter

You can do number 2 by creating a sales invoice for a customer and then run the 'Get Shipments' function. Using that function you can invoice multiple shipments on one invoice, from multiple sales orders even if you want.

The same is available on the purchase side, where you have a 'Get Receipts' function.

kenl

Hello,

Yes, I need to find out the total invoice amount for a sales order.

But finally I find the solution. I make sure of the sales statistic form, which calculate the sales order total amount AND the outstanding invoice amount. Then I substract outstanding invoice amount by total amount = Total invoiced amount.

Maybe there is a better way to find it.

Marije_Brummel

Ah ok. Now I think I know what you mean

The amount fields get populated when you release the order/invoice.

This you find via the function button...

Is this wat you are looking for?