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 ...
Hello!Out-of-the-box your options are pretty much to do a UDF (user-defined field) and then link it to the system Sales Employee object like this:You could add as many as you wanted to any of the system objects, BP, SO, etc.Then you would build queri...
Basically yeah. I have not looked specifically at your query but what I'm seeing in your example is the UNION ALL. Trying to merge the real and draft documents into a single table structure is confusing (to me) so my approach would be a UNION. Does t...
Hello!You don't necessarily have to integrate the tables into a single query. You can use a technique called UNION ALL. SELECT 'Invoice' AS "Type",T0."DocNum", T0."DocDate", T0."CardCode", T0."CardName", T0."DocTotal" FROM OINV T0
UNION ALL
SELECT '...
Oh sorry, this came up in my list and I actually didn't see that you said it was ECC, I'm an SAP Business One consultant so my answer is irrelevant and I can't remove it. Good luck!
