• Relationship between Sales Kit and component products in SINVOICED table

    I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components. I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…
  • Sales Prices / Price Entry in v11

    The price structure for a particular product is: 60.00 for 0 - 9 units, for 10 - 49 units a price of 50.00, for 50-99 units a price of 40.00 then from the 100th unit onwards 30.00 each. We would like the Sales Person to be able to enter a single line…