Browse By Tags

  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.

  • Table that stores monthly "beginning qty"

    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…

  • How to delete an in process inventory from the scanner

    our AP department did a backup of the system while there was an inventory in process and the Data was deleted from the system. Now that inventory download is still on the scanner as an open inventory. How can I delete it from the scanner?

  • SQL Query to find what Group a Stock Item belongs to

    Hi there, I was wondering if someone could point me in the right direction perhaps please? so I am trying to find out what group a stock item (inventory item) belongs. SELECT * FROM StkItem WHERE Code = <code> SELECT * FROM _btblInvoiceLineDetails…

  • Import and export inventory

    I am using sage 50 and the way that I import is —> file—> select import/export —> inventory—> inventory item list where I’m trying to create my own template in csv in order to import item/inventory however it doesn’t go through which I believed the template…

  • Inventory item Additional Costs

    Hi we just got the SAGE Business accounting subscription and started entering data. At the moment I have a problem on adding core charges on products. My e-commerce business has spare parts with core charges, is there a way to ad a custom field to add…

  • INVENTORY

    Hi, When I do an inventory inquiry, it shows 104 of an item on hand, but we only have 40. I couldn't do an inventory adjustment of -64, because there are less than 64 to distribute. How do I get the inventory that shows on hand in inventory inquiry to…

  • Import inventory list with stock

    Hello - I know this article shows how to upload your inventory listing ( https://ca-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=220924150010124 ). But how I update the stock currently on hand as part of the upload? I can't make…

  • Barcode scanner with SAGE X3

    Hi Sage Expert We are looking for some guidance on getting a barcode scanner installed with SAGE X3, please share your experience? or a good supporting partner to use in Australia.

  • Inventory Scrap Policy

    Hi! Could someone share a Scrap policy? Or direct me to a website that may have examples. Thank you!

  • Website integration to sync with inventory in Sage 50

    I am looking for recommendations for syncing our SAGE 50 Premium CDN edition inventory to our website. SAGE still has no functionality for real-time syncing our inventory in our software to a website. Anyone use any third party apps or companies that…

  • CLEARING OUT OLD INVENTORY ITEMS/DATA

    I have a number of old inventory items i would like to clear out but Sage won't allow me to unless I clear the look up data first. However agreeing to this prompt window that pops up does not tell me if the next screen will allow me to choose which inventory…

  • Purchase return in Weighted Average & FIFO Inventory Methods

    Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…

  • batch report creation

    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\

  • Warehouse Inventory not showing up in WhseStk table Evo 10.1.3.005

    When I create a new item in Inventory warehouse items it doesn't show up in the WhseStk table. The item shows in the GUI when I create it but when I exit the Inventory Warehouse Items screen and go back it is not there anymore

  • COMMITTED ITEMS NOT ACTUALLY SHOWING ON ORDER

    Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…

  • Inventory Item

    Is there a way if we updated and Inventory Item for a different price that it would be retroactive, or do I need to change the price manually on every item that we used that inventory item on.

  • Entering of Opening Balances

    Hello House, Please what is the procedure to enter opening balances for the followings after creating a new company in Sage 200 Evolution. General Ledger Accounts Inventories Customers Suppliers Bank Accounts Any assistance will be…

  • Make Pictures automatically pop up in the "Maintain Inventory Items". Please.

    This is the sole reason why we can't switch to Sage50 for inventory purposes which would make our business process much better, since we use Sage50Q for everything else, because inventory and other personnel MUST see the picture right away when they are…

  • Allow Trade Discount

    Is there a utility that will allow me to check the "Allow Trade Discount" box for a range of inventory items?

  • UNITS/MEASURES

    We purchase some items in Jars. When we purchase a jar with 100 units, the number of units is 100. I want to see a 1 unit(jar). Can you do that in units/measures? I setup up a unit of measure called UNIT-100, with number of stocking units as 100. I tried…

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

  • Inventory Item Linked Variance Account

    Is it possible to change a linked account on an inventory item that has been created and already has history of purchases/sales. I inadvertently selected the wrong Variance Linked account and am now trying to fix the error.

  • Inventory Valuation Report, Decimal Places for Last Unit Cost

    Is there a way to increase the decimal places on the report for Avg Cost or Last Unit Cost? The reporting for cost, is inaccurate as it rounds to the nearest penny. The value of many products may be based on purchases in hundreds or thounds of an item…

  • Update Inventory Item Costs

    Hi There, Slight Background: We currently operate on an Average Cost Valuation Method within SAGE 200, With that being said, we are also within the manufacturing industry and thus, once a manufacturing Process Order is closed, A finished product …

*Community Hub is the new name for Sage City