Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion

      Get to Know us

      Our team members share their experiences.

  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 300 Newsletter – April 2018 » Make Improvements to the Sage 300 General Ledger (GL) Transaction Listing

Sage 300 Newsletter – April 2018

Keeping You Up-To-Date With Information About Sage 300

Make Improvements to the Sage 300 General Ledger (GL) Transaction Listing

By: Susi Gaus, Sage 300 Senior Consultant

Are you trying to balance your General Ledger to your Account Receivable or Payable? Ever wish the GL transaction listing would show document type, document number and purchase number for an A/P invoice? There is a way to do that for future transactions.

Every sub-module in Sage 300 has a program icon called “GL Integration” in the setup area of each module.

This program not only controls and maintains posted transactions to the General Ledger it also defines the source codes, shows the last posting sequences, when and how transactions are posted and lets you control what information is posted to the GL Detail Comment, G/L Description and G/L Reference is listed in the “Transaction” tab as long as you have “Do Not Consolidate” selected in the dropdown for the Consolidated G/L Batches.

Let’s look at an accounts payable invoice to illustrate how this transaction is posted to the G/L Transactions – “Batch List” and then printed on the G/L Reports – “Transaction Listing” report.

 

Invoice:

G/L Entry Description     Description: Office Supplies Susi

G/L Detail Reference      Vendor Number – Vendor Name: 1200-Cloride Systems

G/L Detail Description    Document Type – Document Number: Invoice-INV124156

G/L Detail Comment       Batch Type/Batch Number : IN-56

 

Invoice Detail:

G/L Detail Reference      Vendor Number – Order Number: 1200-OE 766768

G/L Detail Description    Document Number–Vendor Name – Detail Description: INV124156–Chloride Systems-Office Supplies/Office Purchases

G/L Detail Comment       Batch Type – Batch Number: IN-56

 

In the “A/P G/L Integration”,“Transaction” tab those fields and values are defined.

 

In this example, I like to add the purchase order information of the A/P invoice on the G/L transaction listing report. Go to “A/P Setup”, open “G/L Integration”, click on “Transaction” tab and highlight “Invoice”. Click on the “Open” button.

Change the dropdown G/L Transaction Field to “G/L Detail Description”, highlight “Purchase Order Number” , click  the button “Include” and then “Save”

In order to save this setting everyone has to be out of Accounts Payable and make sure you have a backup.

Next time you enter an A/P invoice you will see not only the document type and document number in the G/L Detail Description, but also the purchase order number.

 

« Return to Newsletter
In This Issue
  • From the Desk of the Sage 300 Practice Director
  • Sage 300c Version 2018 – Are you Making the Most Out of the Latest Enhancements?
  • Doing a Sage 300 Upgrade? Why You Should Explore the Cloud Today
  • Make Improvements to the Sage 300 General Ledger (GL) Transaction Listing
  • Revaluation of Multicurrency Transactions in Sage 300
  • Sage 300 Third-Party Advantage Conference (TPAC) 2018 Update
  • Sage 300 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Sage 300 Webinar Series

    Building a True Cloud-Connected Back Office
    April 26 | 2pm ET
    Register Here

    An Understanding of the New Lease Accounting Standards
    April 26 | 2pm ET
    Register Here

    Why You NEED AP Automation
    May 25 | 2pm ET
    Register Here

    Popular Recorded Webinars

    Demystifying Cloud Confusion: The Human Side of Digital Transformation

    Increase Profitability with Sage 300 Integrated Payments

    Keeping IT Cyber Safe & Always On

    The Computer Hardware Supply Chain Crisis: Reducing the Risk

    Why Sage ERP On-Premise Users are Moving to Sage Intacct

    Sage 300 Webinar Archive

    View our library of on-demand recorded webinars.

    Sage 300 – Live Online Training Courses

    Browse the course calendar & register

    Newsletter Archive

    Read our previous Sage 300 Newsletters here

     Refer a friend, get a $100 Gift Card!

    Submit a Referral / Learn More!
    Do you have a friend or colleague whose company might benefit from utilizing a Net at Work service or solution? If so, refer them to us below and receive a $100 gift card or donation to your charity of choice!

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin