Invoice Value should not exceed Order Value

[Former Member]

Dear All,

I have a requirement in which whenever a user creates an A/R invoice ( Partial or full ) the total invoice value ( Partial or Full ) should not exceed the total Sales Order Value.

Scenerio :

Sales Order No 10001 has 3 line items i.e Item 1, Item 2, Item 3 with line totals of each as 100, 200, 300. Now Invoice is done for Item 1 and Item 2 on 1/1/09 line total 100, 200 which totals to 300. Now again after some days final invoice is done for Item 3 whose line total is 300.

Now I want a check that the system should check the total sales order value which is 600 with the Invoice Value and it should not allow to add the invoice if 600 is exceeded ( May be Invoice done partially also )

Also a check is required that the line total value of Sales Order should not get exceeded when making the AR Invoice.

I think this could be possible using SP. Pls advise how to make this SP.

Best Regards,

Depika

[Former Member]

Dear Depika,

First you need to confirm if you create all invoices based on sales order directly or not.

Thanks,

Gordon