- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Why CM line stuck in the staging with an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT?
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
There is a validation in the system as part of the batch collection process to stop the CM-C or CM-R transactions when they are collected for an amount which is greater than the corresponding Invoice. Below discussed are the different scenario.
Scenario1:
- SO & Invoice were already collected into RevPro with Ext Sell Price as $1000
- Later, a CM-C collected with Ext Sell Price -$1000 to cancel the collected invoice
If the system receives another CM-C referring to the same invoice line then the system stops the line in the stage itself by stamping an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT as there is no remaining amount in the Invoice line to be canceled.
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
DEF AMT |
REC AMT |
INV |
SO123 |
1 |
SO123-1 |
INV123 |
|
1000 |
0 |
0 |
CM-C |
SO123 |
1 |
SO123-1 |
CM123 |
INV123 |
-1000 |
0 |
0 |
Scenario2:
- SO & Invoice were already collected into RevPro with Ext Sell Price as $1000
- Later, a CM-C collected with Ext Sell Price -$1200 to cancel the collected invoice
The system stops the CM-C in the stage itself by stamping an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT as CM-C has a value which is higher than the Invoice.
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
DEF AMT |
REC AMT |
INV |
SO123 |
1 |
SO123-1 |
INV123 |
|
1000 |
1000 |
0 |
Scenario3:
- SO & Invoice were already collected into RevPro with Extended Sell Price as $1000
- Later, a CM-R is collected with an Ext Sell Price of -$500 referring to the same invoice. Now, the system reduces the Allocatable Ext Price to $500 on the SO line and reverses the revenue of $500 on the invoice.
- Again, a CM-C is collected with an Ext Sell Price of -$1000 referring to the same invoice. This time, the system stops the line in the stage itself with an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT as the remaining amount in the invoice to be canceled is $500.
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
ERROR MESSAGE |
CM-C |
SO123 |
1 |
SO123-1 |
CM125 |
INV123 |
-1000 |
CM AMOUNT IS MORE THAN INVOICE AMOUNT |
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
DEF AMT |
REC AMT |
INV |
SO123 |
1 |
SO123-1 |
INV123 |
|
1000 |
500 |
0 |
CM-R |
SO123 |
1 |
SO123-1 |
CM123 |
INV123 |
-500 |
0 |
0 |
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
There is a validation in the system as part of the batch collection process to stop the CM-C or CM-R transactions when they are collected for an amount which is greater than the corresponding Invoice. Below discussed are the different scenario.
Scenario1:
- SO & Invoice were already collected into RevPro with Ext Sell Price as $1000
- Later, a CM-C collected with Ext Sell Price -$1000 to cancel the collected invoice
If the system receives another CM-C referring to the same invoice line then the system stops the line in the stage itself by stamping an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT as there is no remaining amount in the Invoice line to be canceled.
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
DEF AMT |
REC AMT |
INV |
SO123 |
1 |
SO123-1 |
INV123 |
|
1000 |
0 |
0 |
CM-C |
SO123 |
1 |
SO123-1 |
CM123 |
INV123 |
-1000 |
0 |
0 |
Scenario2:
- SO & Invoice were already collected into RevPro with Ext Sell Price as $1000
- Later, a CM-C collected with Ext Sell Price -$1200 to cancel the collected invoice
The system stops the CM-C in the stage itself by stamping an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT as CM-C has a value which is higher than the Invoice.
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
DEF AMT |
REC AMT |
INV |
SO123 |
1 |
SO123-1 |
INV123 |
|
1000 |
1000 |
0 |
Scenario3:
- SO & Invoice were already collected into RevPro with Extended Sell Price as $1000
- Later, a CM-R is collected with an Ext Sell Price of -$500 referring to the same invoice. Now, the system reduces the Allocatable Ext Price to $500 on the SO line and reverses the revenue of $500 on the invoice.
- Again, a CM-C is collected with an Ext Sell Price of -$1000 referring to the same invoice. This time, the system stops the line in the stage itself with an error message CM AMOUNT IS MORE THAN INVOICE AMOUNT as the remaining amount in the invoice to be canceled is $500.
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
ERROR MESSAGE |
CM-C |
SO123 |
1 |
SO123-1 |
CM125 |
INV123 |
-1000 |
CM AMOUNT IS MORE THAN INVOICE AMOUNT |
TYPE |
SO NUM |
SO LINE NUM |
SO LINE ID |
INVOICE LINE ID |
ORIG INV LINE ID |
EXT SELL PRICE |
DEF AMT |
REC AMT |
INV |
SO123 |
1 |
SO123-1 |
INV123 |
|
1000 |
500 |
0 |
CM-R |
SO123 |
1 |
SO123-1 |
CM123 |
INV123 |
-500 |
0 |
0 |
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √