Content Security Policy
I’ve recently been developing a WordPress replacement for https://found-art.roguelj.co.uk. WordPress is overkill for the needs of that site, and the additional functionality that I required would have had to have been provided by 3rd party plug-ins. Or I could have created the plug-ins myself, but it’s been a while since I coded any PHP. In […]
The Return
Ok, after a couple of years experimenting with a different website (that I also left to rot), I’ve decided to return to the blog format with most of the old content still intact. I’ve tidied up some posts that were no longer relevant and updated where necessary. The graffiti art photo posts have moved to […]
Open Sales Order Lines SQL query
SQL Query for SAP Business One to return a list of open sales order lines at row detail. SELECT T0.[DocNum], T0.[DocDate], T0.[NumAtCard], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[WhsCode], T1.[Quantity], T1.[OpenQty], T1.[ShipDate], T2.[SlpName] FROM [dbo].[ORDR] T0 INNER JOIN [dbo].[RDR1] T1 ON T0.[DocEntry] = T1.[DocEntry] LEFT JOIN [dbo].[OSLP] T2 ON T1.[SlpCode] = T2.[SlpCode] WHERE T1.[LineStatus] !=’C’ The handy thing […]