• Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Is there a way to include a Date Object in a pass through query in Access....

    Hello All, Below is my pass through query. This is how I extract data from MAS and upload to Axiom to do my P/L reporting. This works flawlessly. The unfortunately part of this query is that I have to open each query and change start & end dates.…
  • Historical AP Aging for YE doesn't match GL Balance

    I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…
  • Extension Price on Report not calculation discount %

    Running standard report in Sage 100 and the report is not calculating the % that is put in the discount column of the order. example: qty 1 list price 100 discount 10% extension 90.00 the report will read qty 1 list 100 but then it will say the…