• SumIf not giving correct result

    Hi all, I've been trying to create a simple SumIf expression, which references an expression earlier in the report that I've created to add a small value of 0.50 to invoiced items that come in at 0 value. Here's the referenced expression: SOPInvoiceCreditLines…
  • Commercial Invoice Date Criteria

    I need to add a criteria to our commercial invoice sage layout to allow filtering by despatch date. Essentially I need to be able to print the invoice with only items from the order that were despatched that day. Is anyone able to advise what would be…
  • When Consolidating 2 orders to 1 invoice In SAGE200 you lose customer reference

    Currently when we print invoices from single orders we have the Customer Reference showing on the invoice print. We have had to do some consolidation of Orders to 1 invoice print, whilst the details of the orders consolidate you loose any customer reference…