[JrnlRow].[GLAcntNumber]

Question

I'm trying to create a sales report. Can anyone tell me what this field relates to elsewhere in the database? I need to know specifically what the account names are that are defined by the integers in this field. I've looked on https://help-sage50.na.sage.com/en-us/2023/Content/DDFs/A_List_of_Data_Files.htm but I can't find it.

termerins · Answer

The JRNLROW.GLAcntNumber is the field that we typically link to the CHART.GLAcntNumber to be able to pull the Chart of Account ID. 
 Tammi M. Ermerins ( tammi@pcosupport.com ) 
 Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer 
 800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com

Sage 50 US

[JrnlRow].[GLAcntNumber]

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING