Sage 100

I do rent a warehouse for my business, about 45 thousand square feet; my rent is about $45,000.00. but from this space I do rent to somebody else and receive $3,000.00. The question is, how can I book the $3,000.00, should I credit rent expense or another…

The situation is a leased piece of equipment with 48 payments of 701.00. However, the first month payment is prorated based in delivery date of the equipment. SO the first month payment is 316.58 calculated as: 701.00/31=22.61, and then 22.61 x 14 days…

Anyone use BI360 for their Financial Reports in Sage 100? What do you think? I've used BizInsight for years and have worked with F9 and Sage Intelligence. Currently, I believe that BizInsight is the superior product, but with the recent acquisition I…

Just wondering what financial report alternatives are available for Sage 100. I have seen Sage Intelligence years ago, but was not impressed, it was clunky, difficult to use and not flexible. I have worked with F9 which is user friendly and is super flexible…

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.…

We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…

I'm trying to pull sales data that can be sliced and diced by customer, SKU, date, sales rep, etc. but ties exactly to the GL. So far, the reports I can get using Microsoft Query all have great data, but it won't tie to the GL. There has to be a simple…