• Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • HOLD button in sales order entry

    We are trying to get our receivables under control and our IT department has helped so that our customers now go on automatic credit hold when they have invoices in 120 days. In our system, when a salesman attempts to open a sales order and the customer…
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • Auto send email on entering / invoicing orders

    Is there any ways to enable Sage 100 auto send email notification to a certain group of recipients upon SO is entered / invoiced? I assume this has to involve scripting, right? Thanks, Haibo
  • VI job addDays to add business days

    Hello, I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns. What im trying to do is have the ShipExpireDate be 5 business days added to the order…
  • Possible to add additional 'Order Status' type?

    Hello, We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'. Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
  • Add a column in BIE? Help, I am not that smart!

    I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…
  • Miscellaneous Items in Designer

    Hello, I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…