Advance Billing

[Anon Anon]

Hi All,

We have Advance Billing Functionality in Clarity.I have analysed the data Entered here, with the Tables and Found that the data is stored in "Billing Schedule" irrespective of they are Billed or Billed and Approved.
"PPA_BILLINGS" Table stores the data that are Approved only. (if u filter with sourcemodule='9')
"PPA_TRANSBILL" Table Stores the data Billed or Billed and Approved. (if u filter with sourcemodule='9')

My Question:

what is the process after Advance Billing ,is it after the data is posted to wip or before wip?How does the data Entered here impact the Posted wip data?
where can i find the details regarding the Advance Billing.Flow etc..

Iam Comparing with the transno with transno in ppa_wip table ,but i cant find data in ppa_wip.

Please let me know.

Many Thanks
RK

[Anon Anon]

Hi All,

Any ideas on this post.
How to map advance billing data with other table data.

SELECT
a.company_code,
a.project_code,
a.resource_code,
a.resource_class,
a.transdate,
a.quantity,
a.projecttype,
a.transtype,
a.transno, --Transaction no
a.external_id,
a.notes,
a.task_id,
a.ppa_wipapinfo_id,
b.stdcost,
b.billrate,
b.totalamount,
b.totalcost,
b.amountremaining,
b.currency_type,
b.currency_code ,
info.voucherno,
INFO.INCURRED_BY
FROM ppa_wip_values b,
ppa_wip a ,
ppa_wipapinfo info
WHERE a.transno = b.transno + 0
AND a.project_code ='31698946' --Enter project code
AND a.chargeable = 1
AND a.status = 0
AND b.amountremaining <> 0
AND (b.currency_type='BILLING' )
And a.ppa_wipapinfo_id=info.id(+) ;

--
Advance Billing Notes Data:

select * from BILLINGSCHEDULE where project_code='31698946'

Here, my issue is to show the advance billing notes for the above projects.every time i enter a new row in advance billing it is taking as new transaction no.Then how can i map to the already existing ones.do i need to run a job or,where can i find any other data to map.
can somebody help me in getting this.

Many Thanks
RK

[Anon Anon]

One More Table i forgot to mention:
select * from PPA_TRANSBILL where sourcemodule='9' and project_code='31698946'

Here Trans no is created for each new row in advance billing

Many Thanks
RK..

[System]

Hi All,

Any ideas to help RK out here?

Thanks!
Chris

[System]

Moving to General Discussion Board as this doesn't seem to be a XOG/WSDL/GEL issue.