• The quantity to be delivered is in shortage and negative stock is prohibited, or shortage quantities are not deliverable

    When trying to create a delivery for a sales order I got the following error: On the sales order, line item number one is has order quantity of 14784. On the stock by site inquiry; The product shows on sales order 14784 and available stock at…
  • SQL & Graphical Query

    I have the following Graphical query, the two tables are BPCUST AND SINVOICE. How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018. When I search for this its outputting all the invoices and duplicating…
  • Crystal Report

    We have instances where a customer accepts back orders. On the sales order, it will allow you to put all the product, even the ones on back order. However on the invoice, it will only show the products that are available and drop off the back order products…
  • INVOICE INQUIRY TABLES

    I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?
  • Is it Possible to Combine multiple deliveries on one Invoice

    Does X3 allow you to put different deliveries from the same customer on one invoices?
  • How To Process Sales Invoices In Non Financial Sites

    I have couple of invoices that are sitting in non financial sites. The invoices do not show up as open item under ACH payment when we try to apply a payment. How can we process these invoices. The site is not suppose to be a financial site, converting…