It's taking us too long to key transport jobs on our transport portal plus its just a boring repetition keying sales order details again!
Been given the transport import csv template and attempted to make a sage sales order report to mirror (by adjusting current report) but having a few probs.
Probs I think are I'm clueless with sections and interrelationship between them...think sage literature is poor for this
Having probs:
- Removing a gap in my report Excel cells V:AC dont want a gap for first line of each new sales order/transport job. If that sales order has haz items then first line should contain first haz details item line. If non haz job (none on excel e.g.) then V:AC blank then very next row down is next sales order/transport job
- Also want the report to run only on sales orders highlighted in sales order module. Aware there's a current filter on this report which runs sales order not complete. But when took this filter out so filters blank it runs for all historical sales order. Took sage advice changing criteria but still runs for all historical. Also tried to mirror a sales invoice report which only runs highlighted but no diff.
Many Thanks
Gareth