Browse By Tags

  • Receivables

    I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.
  • Beginning Balance wrong on GL Detail Report

    It appears that the beginning balance for period 1 is coming into the reports without regard to the beginning period selected. The subordinate transactions come into the report correctly, but the balances are all off because of the incorrect beginning…
  • Are First and Last Names needed for printing or eFiling 1099s?

    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…
  • Printing error

    HI All Please assist on how to resolve this error. It appears when trying to print any report in the system. The print server is configured and the service is running. Job 2 - ERR 262 coming from the edition server : Connection to the X3 file server…
  • Full Inventory Inventory List w/filters

    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…
  • Setting up ZPL Printer (Private Network) with Sage X3 (Cloud)

    Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…
  • Work Ticket Printing Error

    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 …
  • How do I run a Ledger Activity report by Job

    I'm trying to delete a job. I'm getting a message that there is Ledger Activity but no job cost or committed cost. Is there a way to run a Ledger report by job number?
  • Windows 11 / Business Vision 2023 Reports freezing when printing &/or saving as pdf

    Hello community, I am in desperate need of HELP ! We use Sage Business Vision for small business version 2023. We installed it on 1 new computer with Windows 11 operating system in November 2022. Originally, there was an immediate C++ runtime error…
  • Sage 300 2023.1.0 - Web Screen Print Destination> Preview | Print to Email

    Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…
  • How to print TB for future year.

    Hi, The scenario is like this: The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how…
  • ZPL List "cuting" my file

    Hello, I need help, i'm creating a PAT file using openo and wrseq with some ZPL code, that file is then called by a Report wich has been created using a ZPL list. The PAT file is created without any problem, but when i call the report the .DATA is generated…
  • OECOINI comments

    Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?
  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
  • How to find the cause of variance between invoice total and the number on income statement ?

    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…
  • Report showing jobs associated to companies?

    Hi, Within a datafolder we have numerous companies - all with jobs associated to them. Is there a report or easy way to show what company each job is associated to or show a list of jobs associated to a certain company within a datafolder? Further…
  • Need to pull out the user who created a GL Gen Journ entry

    An auditor is asking for a report from G/L that lists all General Journal Entries from 2020 and includes the User Name that created the Entry and the User Name that posted the Entry. Obviously I can link SY_User to GL_DetailPosting and pull a report…
  • Purchase Order Printing

    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
  • PR related amounts in GL is described as PR Post checks summary.

    Dear team, When ever we review the amounts in GL , check amounts from PR is showing as PR Post checks summary irrespective of the original PR summary contains breakage pay roll to Salary, other allowances ,deductions , fringes and so on. Could you please…
  • 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
  • Sage 50 1099-NEC prints one record per page instead of 2

    Hi All, I followed the instructions to have the templates for the 2020 1099-NEC, 1099-MISC & 1096 forms added to my Sage account (I do NOT have a payroll subscription, so those are the instructions I followed). When I open Sage, the forms are now…
  • Positive Pay file generation

    When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
  • Printing error

    Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error.... Automation error The object involved has disconnected from its client. This only seems to happen for specific user. When logged…
  • When will the Year End be posted?

    When will the year end be posted?
  • Error printing checks via remote desktop. Error "EAccessViolation"

    We just recently upgrade our servers and are running BW2011. When I try to print checks to my home printer via remote desktop, I receive the error code "EAccessViolation". When I switch by to my windows 7 computer and do the exact same steps, it prints…