Sage 100

Hello, I'm trying to export the history tab of Item Inquiry window (see above) to excel sheet for reporting purpose. I created query which pulls data from the table of IM_PeriodPostingHistory. However, the beginning quantity of each month shows 0…

Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…