Browse By Tags

  • Benefits entry

    Hi, How to post the journal entries for the paying the benefits statement to the benefits company at the beginning of the month the employee and employer portion is automatic out of the account. How to post the payroll entry with the employee deduction…
  • VI General Ledger Journal Entry Import - JournalComment Issues

    Hello Sage 100 Community, I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout: Account No. Debit Credit Posting Comment Journal Comment 6570-00 500.00 0.00 Test comment…
  • Database error (operation=GET-LE, error=105)

    Dear Gurus, I am using SAGE 300 Premium 2018. I installed and loaded SAMSYS, SAMINC and SAMLTD. I am at the General Ledger Module --> G/L Transactions, trying to browse Journal Entries. Whenever I scroll to the end of the entries, I will get this…
  • Display a screen field as a searchable entry in the browser object - is it possible?

    Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…
  • Question about 1-3 Journal entry

    When recording a journal entry via 1-3, is there a way to reference a vendor invoice to make the journal entry pay that?
  • Refundable Deposit

    We have paid a damage deposit to the local county for property improvements. It will either be refunded in full in a few months time, or the county may apply it to the cost of any damage we would be liable for. I am unsure how to enter it, as…
  • Sage 200 API

    Can a Journal entry endpoint be added to the Sage 200 API for standard and professional?
  • Journal Import

    Can you import journals in csv format in Sage 50? How do you do it?
  • On Journal Entry, Rate value is different from the other item line

    Hi all, my customer is making a journal entry when this happen. Please refer to the Rate column and the cell value in red rectangle. The value of the rates on this column are prefill accordingly. But the value for the last item line is different from…
  • Journal Entry Upload for Multiple Post Dates

    I have recently started a new job as A/R Manger where we are on Sage 500 - ERP 2018 Product Update 6 Desktop Enterprise Edition. One of the first limitations I came across was the ability to upload a journal entry that crosses multiple periods. Is this…
  • Journal Entry errors: unable to add new GLJED row because of multiple error

    Hi, I am doing customization to add multiple lines to GLJED. But I get multiple error that I cannot find out why it is happening, note that I only trying to add to GLJED, not GLJEH Below is my code. Instead of getting the record by Batch in GLBCTL…
  • Job Cost Batch Reversals

    Hello, We recently had an individual accidentily post a number of batches in Job Cost that should not have been posted. These batches ranged from accouting dates in February 2021 to April 2021. Luckily the GL was closed up to April 2021 and as a result…
  • LTD Benefits paid 100% by employee

    Looking to find information on the correct posting for LTD Benefits 100% paid by employee. The LTD payment by employee is being posted to LTD Payable account 2000 through the Payable module The LTD payment made to the insurance company is being paid…
  • Posting One Journal at a time...

    I've uploaded multiple Journal Entries from the VI. How can I post only 1 at a time? (in the example below, I am ready to post GJ-000005, but not GJ-000004 just yet) Will Sage 100 post whatever is in the queue even though the JE contains zero or has been…
  • Journal entry uploads

    Hi, My company is currently importing journal entries to the General Journal Entry module by uploading a csv file through the General Ledger Exchange. I was wondering if there's a way to customize the settings so that Sage is the one assigning the journal…
  • Drilldown to journal posting

    It would be very useful if you clicked onto a nominal code e.g. Prepayments, and double-click again to view the journal lines associated with this posting.
  • To stop journal entry copying dimensions from line above

    A couple of customers have complained that when using journal entry it seems to copy the dimension from the line above, regardless of any default dimension that may already be attached to the GL code. This is causing them issues when entering data.…
  • Payroll entry by former bookkeeper

    Good Afternoon, My former bookkeeper posted an entry on Sage50 for an employee, who has the following details: Regular wage $14, Overtime wage $21 per hour. Bi weekly pay - 80 hours per a period Vacation is 6% retained Deductions: Group…
  • Fun Financial Facts

    Financials Fun Facts To start the summer season, here are a few fun Financials facts (I love alliterations). For your beach reading pleasure, sit back, relax, put your feet into flip-flops (alliteration!) and enjoy this blog. Do know that you can…
  • journal entry sage 50 accounts

    Hi there, Is it possible to upload journal entries on sage 50 accounts through an excel file? Thank you
  • How to import bank receipts into several nominal codes using Excel

    We are trying to find a way to import bank payments from Excel into Sage50 Essentials (Version 24). Each single bank payment represents several sources of income and need to be split into several nominal codes. If we use the standard input form we have…
  • Auto complete drop-down not working in 'Details' box in Journal Entry

    Auto complete will suggest previous entries made enabling a couple of letters to be typed and then a repeated entry selected from the drop-down list. Whilst this function still exists (and works correctly) everywhere else in the program that I use it…
  • Inserting the project field when creating a journal

    Hi, When creating a double-entry journal from the Nominal list, I am unable to insert a Project or Cost Centre field into the journal template. This would enable me to create a Dr/Cr manual posting against a project. Does anyone know how to rectify…
  • Journal Upload from Excel

    Hi, Is there an add-on out there for Sage 50c that allows journals to be uploaded from an excel journal template directly into Sage 50 at the click of a button?
  • journal entry review prior to posting

    For Sage 500, within a subledger transaction (i.e. accounts receivable invoice batch , accounts payable payment batch, etc.), I would like to review the journal entry (see the debit and credit sides in a traditional journal format) before posting the…