Browse By Tags

  • 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.
  • Inventory transfer macro is failing when negative levels allowed

    I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…
  • DATABASE QUERY: Find qty of a particular sku that has been purchased/received since date.

    As per the subject, could someone help me with the query to find the Quantity Received since a particular date for a particular SKU ? If an order is placed for 10 of SKU(ABC) we receive 1 on date X, I'm assuming TODATEQTY would be 1. we receive…
  • Inventory listing by Inventory Item Description

    How can I get a listing of the inventory Items in a specific location that contains a specific word in the description? For example a want a listing of all item with "Widget" in the Inventory Item Description. HELP???? Our OLD system could have…
  • Explanation of differences between MaterReqPer and MatReqPc?

    FormerMember
    FormerMember
    We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
  • Adding inventory

    Hello - I need to create inventory. Using one number for the purchase or said inventory, and a separate number for the sale of the same. Purchase and sale price will also be different. Can someone help me?
  • General Alias lookup for inventory

    We want to create a general alias for some of our raw material inventory items. I would like to create a custom lookup in inventory inquiry that will sort by the general alias number, how do I set that up? I can't seem to find the field for that when…