• 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…
  • Inserts and updates for inventory transactions tables

    Inventory transactions can originate from Purchase Order, Sales Order, Manufacturing, or Inventory Management modules. Here are the tables that are inserted and/or updated when an inventory transaction is posted: Insert a record into the inventory…
  • Warehouse Setup

    We have a warehouse that is not setup to track items at the Bin level - can this warehouse be changed to track at the Bin level?
  • InvtTranLog table

    What is the difference between the tran date in the timinvttran table and the trandate in the invttranlog table? Pete Gentile The Robbins Company
  • Big Box Retailer Ordering Woes

    We sell bins of mixed product to big box retailers. We purchase and inventory those bins as 1 item number, but the stores will only order the individual eaches that make up the bin. For example, Bin D is equal to 100 Part A 200 Part B 300 Part…
  • Invoice for Purchase Order before Receipt of Goods

    In a lot of cases we prepay our vendors for all or a portion of the goods. The invoice is received and partial or all of the payment is made prior to the goods being shipped. We use purchase orders within the inventory process. How do I put in the invoice…
  • How can I correct data entry errors specific to inventory quantities?

    Good Afternoon. In my last blog “ How can I correct data entry errors?” I made some suggestions for financial modules. In today’s blog the focus is on transactions with the core in inventory module or anything that affect inventory quantities. Committed…
  • Lots with Zero Quantity

    When I go into Explore Inventory and search for all lots that are open, there are a dozen lots with 0 quantity. How can I close the lots? I tried to create a SO but it wouldn't let me because the quantity is 0.