• Is there a job report that I can pull that shows both inventory item ID and quantity used on job?

    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…
  • Inventory Movement Analysis/Report

    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…
  • Setting up inventory items and assemblies

    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…
  • Purchase dates for specific GL codes

    I need to know how much fabric I bought each month. When I purchase fabric, I enter the payment directly. I don't use the receive inventory feature. The GL code I'm looking for is 132 (inventory). I use hybrid accounting, accrual for inventory and cash…
  • 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…
  • Problem with inventory beginning balance

    Hi, I capture inventory beginning balance and in dont show in GL Summary Report, some one knows why this happend
  • Is there a way to calculate the commission by item sold?

    Hello, I have a warehouse of items that are are sold by sales reps. I need to compute commission earnings by sales rep; linking customer invoice detail to vendor costs. How can this be done for warehouse items? Thank you in advance. Ellen
  • Inventory Report - Duplicating Items

    I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…
  • Item Sales Report Sorting

    I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…
  • How do I run a report for a specific range of SKUs showing a year's worth of usage?

    The company I am consulting for currently does not have a stocking plan. They have not done an ABC inventory evaluation which is the first step I want to take them to get this project started. They do know how to pull up a report showing the CoG for each…