Browse By Tags

  • Disabling "Clear History" in G/L Periodic Processing for certain users

    Hi have been trying to figure out how I can disable "Clear History" for certain Users.) (last item in screengrab) Tried unticking "Period End Maintenance" and "History/Budget Maintenance" - both did not work. ( please see list of options for GL ) …
  • Bank Account variation with General Ledger

    I have my system automatically update the Bank ledger But now the Balance Sheet Bank amount differ from my Bank ledger However the balance sheet Bank amount reconcile to my actual bank Thus for me this is not a bank reconciliation problem but SAGE…
  • Financial Reporter will not Preview

    We have a customer that is having an issue on 1 workstation only with the financial reporter. It will not generate in preview, but they can print to file. The same statement works from other workstations. It is Sage 300 2021 with the latest Produce…
  • G/L Journal Entry Error - Please Help

    Has anyone experienced this error before when processing G/L Journal Entry? Not sure where to even begin but processing a few transactions / posting banking transactions and then doing G/L Journal Entry and we get this error. We are running Sage 300 2022…
  • Correcting the period on a posted invoice batch

    A batch of about 200 Invoices was posted to a previous year (period) and the checks were posted in the current period. How do we get the invoices corrected into the current period?
  • Net Loss Accumulated - General Ledger Trial Balance

    Hi Team, Need some expertise, there is figure of Net Loss (Accumulated) on extracting trial balance (on the top) I need to know if I want to make changes to that figure what entries will be passed to bring that change. Thanking you, Murtaza
  • Credit Card Receipt Confirmation Report Customization

    Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
  • Cash Management Register's Posted & Reconciled, But General Ledger didn't catch transaction.

    I have Cash Management register (CM) matching the bank account. The General ledger (GL) didn't pick up this transaction. CM is reconciled. how would I add this to GL and keep everything balanced? last time this happened, I had to do a funky chicken…
  • Year end adjustments to account payables

    I know there was few topics on similar issue but it seems I didin't find the answer. I received following year end adjustments Account payables Cr 20 000 consulting services Db 20 000 Since I cannot do adjustments to accounts payables without…
  • AR Invoice Adjustment not reflected in GL

    Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…
  • Inventory Count Issues

    Hello, We were performing an inventory count however one of our employees made a stock transfer from one location (being counted) to another. When we look at the part number through the inquiry function, we see the appropraite quantity in each location…
  • Closing the General Ledger Module for 2017, 2018, and 2019?

    Good afternoon, We need to close the General Ledger Module for 2017, 2018, and 2019. What are the steps? Please and thank you!! -Jazmin
  • GL Relink

    Hello, I am getting the following error when doing a relink of my GL. How do I go about addressing this issue?
  • Income statement report

    Hello, All users suddenly began getting this error when generating income statement reports. How can I replace or find the missing class to solve the problem? Sage version in in use is 10.1.1. Appreciate the assistance in advance.
  • Chart of Accounts in Web Screens

    I cannot seem to find the "Chart of Accounts" screen in web screens. Is this not available or am I missing something? Thanks, Ubaidullah Nubar.
  • Posting to previous FY

    Hi we have an error batch as the error occurred because the user has posting to a prior year (posting date 22 July 2021and value date 30 June 2021). The posting has to be done to last financial year (2020-2021). We have already done End of Year Processing…
  • Sage 300 2019 Data Conversion to 2021

    During data conversion of one of the three databases, I come across the following error message. The other databases were converted successfully. Description: You cannot upgrade because some of the features you currently use are not available in the…
  • INVENTORY VALUATION AND GL ACCOUNT DIFFERENCE

    My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,
  • Incorrect GL account type Balance Sheet > Income Statement

    Our client has a few GL account configured as Balance Sheet account instead of Income Statement account. The account was incorrectly created as a balance sheet account. We need to change the account type to income statement but firstly, correct the…
  • Export Multiple Trial Balance Report

    Hi, Thanks to this forum that I have learn a lot of skill and knowledge about Sage. Recently, I am working on a project, and I am wondering if I could do it in a efficient way. Here are my situations: 1. We have more than 20 sage 50 files setup…
  • Rental Property

    Hi, Our company has built a rental property. The property will have one unit as a rental and the lower unit will be used for staff traveling at no expense to them. My question is how do I set up the accounts to keep track of the expenses for both the…
  • Missing "updated by" GL Journal Drill down

    Sage 100 2020 Premium (6.20.1) After deleting old users off a system, the GL drill down from Transaction tab "Updated By" is blank for the deleted users. The deleted user keys are listed in SY_UserHistory. Short of 'reactivating' the deleted users…
  • ERROR " This batch will be retained because deleted entries exist" in General Ledger

    Hello, I tried to delete a batch in General Ledger, but I received this error "This batch will be retained because deleted entries exist". Has anyone had this error before? How to fix it. Thanks a lot! Jun
  • Intracompany transactions

    Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…
  • Trial Balance - Active Accounts Only

    How can I change my settings in the GL Module to only show Active accounts on my Trial Balance? Currently it is showing deleted and inactive accounts along with the active? Thank you