Browse By Tags

In the General Ledger, I would like to transfer history in a GL Code to a new GL. The new account will not have been used before, just trying to clean up the books. Is there a way to do this?I have looked at Utilities/Change accounts, but am not sure…

Hi Team Please help to locate the Opening Balance column/field in the GL table list. Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP. Thanks Thulasi.

Currently we use payroll for expensing the labor expense on our setup. There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O. When WIP got turned off the offsetting transaction for the…

Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…

We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account. To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…

How to enter a deposit payment without applying an invoice?

We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

I am trying to check the box under GL Options for Integrate with Bank Reconciliation and I get this message: You cannot enable or disable integration to Bank Reconciliation while Transaction Journal Entry is in progress. I do not have any TJE in progress…

We have revamped our naming convention for "budgets". I want to delete the old budget codes. I went into General Ledger, Setup, GL Options, "Budget" tab. When I click on the old budget name I want to delete, I get a message that states I cannot delete…

Is there any way to set a default expense (purchase) or default income (sales) ledger account for an individual cost code. I would like it so that when I select a cost code on a line within a PO,CO, AR invoice, etc. the account is auto populated with…

Hi, We are working with Sage 100 Contractor. We are using Subaccounts in our General Ledger. We want an Income Summary with Subaccount Detail Actual/ Budget report. Currently S100 has an Income Summary with Subaccount detail Actual/ Income, but no option…

One our accountants created a new account group and catergorized it as an Asset.. Then a main account was assigned to this group, and a GL account created assigned to the Main account. A/P then processed an invoice and used the GL account that was created…