Hello,I've successfully run an SQL query and output it to a local CSV file and it works perfectly.I now want to upload the same file in the exact same format to an FTP location. I have the FTP location working fine, it creates the file with the same...
Hello,I'm making a scenario where I take an SQL query then I transform it into a specific format and output it to CSV.I have everything working fine for the query and the output file and formatting. However, when I output the final results the rows ...
I have had the request from several SAP Business One customers to view the last price given to a specific customer for a specific item. Well the only real solution I could come up with would be to make an FMS on the price with a query. This is an O...
At some point in your SAP Business One consulting career you will get the question as to WHY the Inventory Audit Report (Inventory >> Inventory Reports >> Inventory Audit Report) doesn’t match the GL balances or balance sheet totals.Generally this qu...
When you make a dropdown list in SAP the data is stored as a code in the system. When trying to do an SQL query or Crystal Report you will find that only the code is output so the user reading the query / report doesn’t see the description.You could ...
OK, this should do it. It's relatively complex so hopefully you know how to modify StorProcs to use the PTN system. I have a video here (PTN is later on but it's worth watching the whole thing HANA is not identical but similar): https://youtu.be/V4...
My understanding is that this is a printer driver issue. If the printer settings are locked to black and white it will force the print to be black and white.There seem to be some options in the Crystal Reports code which allow programmers to set a f...
Hello,Give this code a try, it should do you what you need: SELECT
T0."CardCode" AS "Cliente"
,T0."DocNum" AS "NumAlbaran"
,X."InvCardCode"
,X."Invoice" AS "NumFactura"
,T0."DocDate" AS "FechaContabilizacionAlbaran"
,YEAR(T0....
Hi Brad,The way you are joining the tables will limit your data. Say there are invoices on days with no production orders, those will be lost.I used a CTE table setup here:-- DECLARE VARIABLES
DECLARE @Date1 DATETIME
DECLARE @Date2 DATETIME
SET @...
I have SAP Business One V10 (10.00.240) SP 2402 HOTFIX1 (SQL Server) which is the newest as of me replying to this question.This version appears to have the 1000.240 SDK version, you can see below:You can get this from the Software Download Center or...