Sage 100

Hello everyone, I have an issue that I haven't been able to find a good fix for. Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…

I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…

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…

There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …

Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated…

When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks

We have a client that needs to run a Time Track Report by job number that includes time track entries for a month were some have not been updated along with some that have been moved to the history file. Has anyone come up with a way to combine the two…

I'm looking for the following fields in a file in the V2019 job cost. In legacy, they were included in the JC1 file. I'm hoping I missed them when I attempted to find them in V2019. Can anyone assist? They are not in the new JC_Job file in V2019. PTDActualCost…

Trying to find a way to get a report or create a report in crystal that shows profitability by cost code. It seems every profit type report is by job. I see there's the job cost detail report and you can add the billing amount but it doesn't seem to be…

We have a client that is converting from Sage 2017 to Sage 2020. They do not own the Time Card module, but did have a Union Automation enhancement from Kissinger. They will still use that enhancement in the new version. DO they have to purchase and set…

Hi there, Trying to recreate a report from legacy job cost with new job cost and not able to duplicate a formula. Old Legacy formula: if Sum ({JC1_JobMaster.JTDInvoiceBilled})=0 then 0 else (Sum ({@JTD Gross Profit})/Sum ({JC1_JobMaster.JTDInvoiceBilled…

Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…

Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…

I have negative time from a time track entry that is not updating and showing on the job transaction detail report, has anyone had this issue and if so can you let me know how to fix?

Trying to convert a Job Cost report from pre-2018 to 2018. The file uses a subreport to get the employee information for a LABOR posting (not done through TimeCard/TimeTracker). The employee information is parsed from the Comment field in the JC Detail…

Deductions are automatically calculated but at times when an employee is on vacation, deductions are not calculated for that week for that employee. They are entered manually next pay period in addition to the automatically calculated deductions. What…

I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…

Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled. Thanks for your help!