• Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
  • 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…
  • Product Line in Open Sales Order Report

    As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…
  • Business Insights List Query

    Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…
  • I want to print an Accounts Receivable Invoice History report sorted by Customer Type.

    I need to print an Accounts Receivable Invoice History Report sorted by Customer type. I have created the UDF for Customer Type and added to all the work and history files. When I run the report just selecting invoice dates I get my report showing the…
  • Filter the look of UDT

    Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…
  • Trouble in write lines details to a UDT

    Hello, I have a script on cash receipt header table, post-write, will bring cash receipt header and detail to a UDT. It is working fine, EXCEPT, If there is more than one lines in the detail, it will only return the last line to the UDT. Only showing…