I create a stock transaction file export in file-maker so we can update our stock figures on sage.
Everything works fine but the export file isn't is efficient is i want it to be.
i.e there could be several of the same product codes with quantities. But really what I could do with is just the one product code with all the quantities combined like a summary of that product code?
how could I make it more efficient?