How to Close-Short Sales Order (When Part of Balance Invoiced Outside FCX)

This sometimes comes up with companies who are still in the process of implementing FCX Enterprise.

The situation is this:

• Users create Sales Order and populate it from PO, but part or all of the balance is invoiced outside FCX.
• This leaves a Sales Order with a remaining balance that will never be closed-out.
• Worse still. the revenue may be imported as legacy data, which would leave the BP showing a remaining balance which is not true.

This usually becomes a problem when you try to Close the BP and the system tells you it cannot be closed because of a remaining balance on the Sales Order.

To fix this, we need to edit the Sales Order so that it no longer has a remaining balance.

We can do this by adding a line to the Sales Order with a negative amount equal to the Sales Order's remaining balance... BUT, this will not be a complete fix if the Sales Order lines with a remaining balance are still connected to a PO.

As such, the recommended way to do this is:

• Disconnect all not-invoiced Sales Order lines from PO Lines - Just delete the value in the field of PO and POL for each row of the table
• NOTE - If you have a line that is partially invoiced, we recommend you:
• Reduce the row to equal only the amount that has thus far be invoiced
• Add a new row to the table that equals the not-invoiced balance for that line
• Don't bother connecting the new row to the PO, we want to remove the connection anyway
• Add a line to the bottom of the Sales Order for a negative amount equal to the complete remaining balance of the Sales Order
• Save and close
• You should now be able to proceed with closing the BP