cancel
Showing results for 
Search instead for 
Did you mean: 

Block AR Invoice not equals to Approve Sales Order Quantity

mervz02
Explorer
0 Kudos
249

I want to block A.R Invoice if the approve quantity in the sales order is not match. i want to control the A.R Invoice. they will only add A.R Invoice from Approve SO (I have approval procedure) if the rows qty is not lesser than or Greater than the approve item and Quantity

View Entire Topic
msundararaja_perumal
Active Contributor
0 Kudos

mervz02,

You could use transaction notification to validate if the quantity does not match.

You should consider the condition of having multiple A/R Invoice against one Sales Order, if the SO has multiple quantity.

Thanks.

mervz02
Explorer
0 Kudos

Hi, Yes Transaction Notification, i tried some query but it seems it blocks the AR Invoice without reference to SO. but i only want is to block the AR if the SO details in row is not match in AR Invoice. specially Quantiy.

msundararaja_perumal
Active Contributor
0 Kudos

mervz02, You need to reference the SO docentry and group by item group and summarize the quantity for validation, thanks.