Sage 50 Accounts

Hi, I'm looking to write a report in Report Designer which gives me information on the products that we supply to our customers. I think there may already be a standard report that shows this but as far as I can see it lists sales to the customer…

Does anyone know the expression/data field that i would need for QTY remaining on on the delivery note report. we use the delivery note via reports so the standard SOP is not available. Thank you in advanced

Hello, I have a "previous 12 months stock usage" report that I use to help with predicting stock reorder levels. Its set up with a pre-set date range that I have to change every so often to reflect usage of items that fall outside of the original…

is there a data field or expression that puts the currency symbol and amount together then having 2 separate data fields

I'm trying to create a IF statement. what I want is that if the delivery address box is not populated I want it to take the Invoice address. I have managed that BUT if not all lines are populated on the delivery address it takes it from the invoice address…

Hello, I have a Sales Order confirmation form set up so that each line on the order can show its own delivery date. This calls on SOP_ITEM.DUE_DATE and has to be manually input. Should any line contain a blank SOP_ITEM.DUE_DATE then I want to be able…

Hi, I've have tried a few expressions and filters to figure this out, but I can't seem to crack it. I want the group header and footer to not show if there are no values in the details section within the group. See image below. For reference, this…