Hello,
I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having some difficulty finding a good way to extract batches that were made today, but are no longer active (already posted/completed). Below is my working code to the first part:
select batchno, recordcount,DateCreated, u.UserLogon
from GL_CompanyActiveBatch c
left join SY_User u
on c.UserCreatedKey = u.UserKey
where ModuleCode = 'A/P'
I have tried both GL_DailyPosting and GL_detailPosting for the second part but can't get results. Any help would be much appreciated.
*(We use sage 100 Premium 2018)
Thanks,
