You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need sql query to retrun Original Invoice Number for a Rebill Invoice

in Project Management

Summary:


Scenario:

1.) Time interfaced from Fusion Time and Labor for 8 Hours. Invoice #1 created in PPM and fully billed in AR and sent to Customer

2.) Time adjusted in Fusion Time and Labor from 8 to 6 Hours. Invoice #2 created for the Credit of the 8 hours. Invoice #3 created for the rebill of 6 hours

3.) Straight forward in the tables to tie Invoice #1 and Invoice #2 (the credit Memo). What is not straight forward is a query for the Rebill on Invoice #3 to return the Original Invoice #1.

Does anyone have a sql query that will return the results.

Thanks

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!