Browse By Tags

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…

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…

Quick question - I must be missing something. In Sage Accounting (Cloud) Plus: How can an inventory report with cost at certain date be generated that shows each item with count and cost? I just can't find it. Thanks Mark

Hello all again, I've been getting some very good advice here lately, thank you all! I create a custom report in the "Item List" that includes "Total Quantity On Hand". The issues I have is when the report shows a negative qty, however the Item Detail…

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…

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…

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 …

Looking to see quantities and part numbers and value of transactions to tell how many pieces we are selling vs allocating into work tickets. We stock part numbers that could be sold directly to customers or allocated into larger bill of materials/work…

Our company's projects consist of inventory items and non-inventory items purchased specifically for a specialized job. Is there a report that can be pulled by job# that shows the inventory ID of the parts issued to job with quantity? I can drill down…

Hi guys, Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod…

Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\

I am looking for reporting that shows both purchases and sales with quantities and $ CR/DB. Found reports do not show data on items with Current O/H of zero or do not show the desired detail. Working with LIFO inventory and would also like to be able…

I am looking for a report that identifies the last date an item was purchase.

I am really new to Sage program. I ran a physical count variance report after a physical count was done. However, the Quantity on Hand shows zeros for every item. What did I do wrong> Thank you

We have purchased a company using Sage 100 and will need to identify the inventory on hand at a particular point in time. The ERP system we have has all inventory transactions in one table, thus it is possible to start at the end or the beginning and…

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…

For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…

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…

Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…

Any suggestions on a label printer for inventory receipt of goods? I'd like the label to be about 2 x 3 - most printers are either 1 x 2 1/8 or 4 x 6 - to small or too large. I need a printer and of course the labels, compatible with Sage 100. Thanks…

Is it possible to set up a Sage Alert to run a system report on a schedule? I want to get the Inventory report Multi-Bin QOH and Valuation Report to email on a schedule, but I can't get the report to generate values unless I run it through Sage. I've…

Hello Guys, I have a question regarding the processing of the Stock Valuation Report. When I take a Warehouse-wise Stock Report upon entering a back date on the Stock Valuation Report, the Quantity and Amount is displayed as a Negative Value. But…

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…

Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

As an example, I sell Receiving Sets which include a Burp Cloth and a Receiving Blanket. I set up the items Burp Cloth and Receiving Blanket as stock items with the inventory account 12000 (supplies). I set up an assembly Receiving Set and put in the…