Knowledge Base

Contract Automatic Invoice was blank but it can be created manually.

Hint Ref: 020803260001
Hint Date: 26/03/2008

Hint Details:

SYMPTON:

 

A customer had a contract which, when on-going contract invoices were generated by the Startup Routines, had no details lines. Expanding the invoice showed nothing but empty blank lines.

However, if the contract invoices were created manually using the 'Issue Next Invoice' button on the contract, everything appeared normal.

SOLUTION:

The customer had recently increased prices and for some unknown reason the 'Apply Price Update' process had not completed correctly. The result was that the contract now had no current Movement Record (with the MovementEnd and EndStatus fields NULL).

To correct the situation, the last movement record was reinstated by having MovementEnd and EndStatus set to null and then the MakeMovement Database Function was used to re-apply the Apply Price Update.

(Please Note: This Procedure can be destructive and should only be used by Advanced Users.  RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command.  Responsibility resides solely with the user.  

IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)