• Allow Trade Discount

    Is there a utility that will allow me to check the "Allow Trade Discount" box for a range of inventory items?
  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • Can you change the initial/default UOM for new records in Item Maintenance?

    Hi all, When we start to create a new item record the UOM fields all default to "EACH" automatically. I notice also that "EACH" doesn't even exist in our Unit Of Measure Conversion Maintenance. Customizer says the initial value for this field is…
  • Intracompany transactions

    Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…
  • MATERIAL RECEIVED WRONG WAREHOUSE

    Hello, We sent a PO to one of our vendors and it was supposed to get shipped to our CA location, however they sent it to our FL location. We now need to send this material to our other warehouse as we have no space here to keep the product. For…
  • Sage Alerts HTML email color coded table

    I am writing an html email alert for Sage Alerts and Workflow v9.0 for Sage 100 and I have a table in the email alert and I want the table to be shaded for every other row. I'm using the nth-child(even) method and I can't get it to work. If someone has…
  • Transferring FG inventory from one warehouse to another

    Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
  • Old FIFO tier is stuck. What causes this? Can I see details?

    I have a client with an item that has 2 FIFO tiers: 1 from 2013 with 4 on hand (original qty of 8 when it came from PO) & 1 from 2016 with 5 on hand (original qty of 7 when it came from PO). Total on hand is correct, but they have had a bunch of POs…