• Setting Zones in Sage X3

    Hey All, My company has purchased a wave picking function in Datalinx. During our first brainstorming session we've brought up Zones(zoning our warehouse). We believe we need to set zones as we go down this road. Problem is where to start? My question…
  • Ability to set Product > Sales tab > Base price > in Product-Customers tab (and the same for Purchase base price > in Product-Supplier tab)!

    Price list are great tools in Sage X3 and never failed me in any of my projects to be able to setup even highly complex price lists. The issue is that sometimes client want to be able to add a simple price for each Customer and Supplier as base price…
  • Non billable Delivery with pick ticket for ADC mobile picking?

    We have a nice Sage X3 puzzle, here it goes: We want to pick from new ADC mobile webapp the stock to be issued on a non-billable delivery; We create an order to have the pick ticket, I think we cannot have pick tickets without orders; Then we pick…
  • ALIFMI entry point in TRTVENCDE

    Dear all, I'm new in SAGE X3 and wanted to know if there is a possibility to change the default value for the field FMI in a Sales order line. I found in the entry points documentation that this can be done by using the entry point ALIFMI but not…
  • Creating Sage X3 Alerts

    Hi team, I want to create a rule where Sage X3 will either be notifying or prohibit user from proceeding when they want to create a quotation for a supplier who has reached a certain credits amount (to be agreed) ie has several outstanding invoices…
  • Price Search function not able to search two products ?

    Dear Sage Community, After searching one price for a combination SKU/Customer (click on Apply and it works), I was trying to search a second price for another SKU for the same customer (SKU2/Customer). But the APPLY button does nothing for the second…
  • Conditional style on sales order

    Hello everyone, i'm trying to set up a conditional style on sales order so when the total stock is less than the order qty, glows yellow. I tried a few ways but don't work, i think the next line should be correct but it's not working. [M:SOH4]QTY(NBLIG…
  • Sales Forecast

    Hi All, Is there a place in 2022 where to enter a formal sales forecast in X3? As in customer, products, months/time when to flow them and then compare sales vs forecast? We are thinking to maybe see how can we make "Enterprise Planning" work but…
  • Sales Order Line Is Under Preparation

    Does anyone know what this means? We don't use "preparation". We started getting this error message recently, sometimes we can blow by it and sometimes we can't. This particular product is not managed so there is nothing to allocate. When you hit ok it…
  • Sales orders/invoices and mandatory dimensions

    If a dimension is defined as mandatory for a company, this dimension always needs to be entered when creating sales orders and invoices. Even if the dimension is only setup at one G/L account. It would be great if this behavior could be changed via…
  • Table with link between invoice and order

    Hi. Is there a table, where I can find the link between invoice and sales order? Thanks in advance. MatteoS
  • Return reason for sales return

    Return reason should be allowed to enter when creating a sales return. This reason usually goes on the return document sent to the customer. Currently this field is only allowed to be entered when the return stock is received back.
  • How to allow negative NET price on Sales Order/Deliveries/Invoices?

    Hello, we have the requirement to allow negative NET pricing on certain lines on Sales Orders, Deliveries and Invoices without using the discount fields. I've been able to enter a negative amount on the GROSS price for a line item, but then Sage makes…
  • How to modify the quantities of a delivery and its movements of stock through code or import / export template

    I have a validated delivery to which I want to modify both the delivery quantities and the quantities of the stock movements made; I need to do it by code or template. Would anyone know what template to use or how could I develop it?
  • De-Assignment by Orders

    The client is utilizing assignment rules where when a PO/SO is created, the system will automatically assign it to a existing SO/PO. This is to provide them better visibility on the expected delivery to the customer. However, sometimes they will received…
  • Pay by Scan Business Model

    Hello all, Has anyone modeled Pay-by-Scan business model in Sage? It is basically consignment shipments - where you ship your products to your customer but you do not get paid until that product is sold at the store. So, you can not invoice the customer…
  • Customer BP Invoices

    FormerMember
    FormerMember
    When I try to create a BP Invoice through the menu: A/P-A/R accounting < Invoicing < customer BP invoive, I get the following error: I select the Invoice Type: FAC, tab to next field (document no.) and the error message appears when I tab from the…
  • Information about Commerical Bom Price Lists - Price List Type Component

    Does anyone have any information on the price list type "component" and how it relates to commercial boms ? Trying to see if it can apply to a new project. thank you!
  • Final product permisson

    Hello everybody I want to apply a l permission to sales users that i want to show just Final products items (by category) when they select item in sale orders ... i tried with many ways but i falled because i have not find the category field in ITMSALES…
  • Sales/Customer Price List – By Line Validity Dates

    Allow each detailed line in a pricelist to have its own unique validity date range. Right now, the SPRICLIST (Customer prices) table has fields for a validity range for each line. However, the header dates override any changes made to these fields when…
  • 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…
  • Paid Commissions

    I have been seeing a Function called "Paid Commission" in Sales Utilities since PU9, but have never had anything produced by it. Does anyone know what this function does?
  • Free Webinar - Announcement to Sage Partners in Australia

    Dear Partner We are pleased to invite you to Sage Enterprise Intelligence (SEI) Webinar that will include how to demonstrate Sage Enterprise Intelligence covering a Sales Demonstration, what's new in SEI V8 and an overview of SEI with a Q&A session…
  • 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…