0

G_L Entries, Posted Sales Invoices and Dimensions

Ronald McVicar

February 27, 2023 19:29

None

Follow

Are there any existing Jet Reports that have all of the following: G_L Entries, Posted Sales Invoices and Dimensions? As I need to report Revenue G_L Entries (G_L Accounts 4000 - 4999) from Posted Sales Invoices this needs to include

Sell to Customer Number, 

Product Name which is a Dimension (e.g., 1000 is Product "Black", etc.),

Local Currency Indicator  AS we need to know the source Currency.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks February 27, 2023 21:58

  Just from memory, I would say nothing like that exists.  Most of the prebuilt reports were more summary level rather than detail level.

  Should be a quick build with a Key and NFs to get all the GL Entries, Source No., Dimensions, and Document Type.  Probably need some filters to limit document type or source type.