• ODBC Database tproject dSExpBalNY entries not matching Job Allocation Expense reports.

    I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…
  • Issue with project allocations

    Hi, I have two questions.. 1) When i pull a project allocation report for this fiscal year (April 1 - March 31, I'm noticing that certain accounts are only displaying entries from 9/02 instead of 04/01, for example. The project allocation for…
  • Project Allocation

    My goal: when I enter a sales invoice (for condo fees) for residents, I wish to allocate the condo fees to a project--the project will be the condo suite number. My condo fees revenue account is "4105 Condominium Fees." When I go to enter the condos…
  • Project Allocation to a Revenue Account

    Trying to delete this post
  • Drop down for project allocation

    How can I delete all of the completed projects from drop down when I am allocating paycheques and expenses? I am getting all of the completed projects as options as well as current projects. I dont need completed projects!!
  • RE: Project expenses and revenue

    Nadine.amps said: is there a way to enter the expense in the month it occurs but then move it to the month we recognize the revenue? You could use a G/L entry to accrue the expenses to a 'Work-In-Process' Current Asset as of the period they occurred…
  • Inventory and Project Help

    Hi I have 2 issues I am trying to figure out and would value any assistance 1. Inventory raw material We buy sheet metal by the plate size and sell by the sq ft but often the cost of the same material thickness will vary by the size and quantity…
  • Project Budget Detail Report

    I am trying to run my Project Budget Detail Reports - Actual Vs. Budget, however the first line of expenses has minimal amounts listed under "unassigned budget amounts". I am not sure why that is or where to go look for the error or what was missed. Does…
  • RE: Project HST

    Hi Lukeys Boat, If you do not see the HST charges on sales account shows up as one of the accounts that you can select in the project allocation report, it means you have not setup the account for allocation. You will need to go to Chart of Account…