Question

GL Balance Analysis Basic

  • 26 March 2024
  • 1 reply
  • 60 views
D
Rank
Badge

hi

we just upgraded to Cloud.

I’m really sad to see that Cloud doesn’t have the same advanced search functions that we left behind in Apps 9.

I cannot figure out a way to download a list of invoices for the month with all the invoice lines rolled up to one total.

I also cannot figure out how to use the GL Balance Analysis screens to tell me what the balance of an account was at the close of business yesterday.  Seems like there are no date parameters available to use as a search.

How do we find the balance of an account for a given date???

1 reply

Michael Kaiser
Rank
Userlevel 4
Badge +7

Hi Dawn,

wellcome to the community and a lot of fun talking to all the experts here!
I would recommend a QuickReport (QR) on ORACLE View OUTGOING_INVOICE_QRY or better
fetch data from INVOICE_ITEM_TAB joined to INVOICE_TAB


Just use SUM() on NET_CURR_AMOUNT or NET_DOM_AMOUNT.
 

 

GROUP BY INVOICE_DATE (from INVOICE_TAB)

 

 

We import this tables every night into a DataWareHouse (MS SQL) and create a Star-Schema + Cubes every day.

 

This way you have maximum of flexibility.

hope this helps.

Michael

 

 

 

Know your goal, ask relevant questions, decide strong, fast and smart.

Reply


Terms & ConditionsCookie settings