Skip to main content
Question

GL Balance Analysis Basic

  • March 26, 2024
  • 1 reply
  • 149 views
D
Do Gooder (Customer)
Forum|alt.badge.img

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
Sidekick (Customer)
Forum|alt.badge.img+8
  • Michael Kaiser
  • Sidekick (Customer)
  • 100 replies
  • March 27, 2024

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.
S
1 person likes this

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings