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 ...
From my experience you should just use a single item code with a multi-UoM group with base EACH. Especially since you have the desire to keep a linear relationship with the individual screws (from your example).If you have 5552 screws in a single it...
The only solid way to do inventory aging is to use batches or serials. Everything else is just a guess. What if you transfer the stock between warehouses? What if you sell some and then return it? I can think of a dozen ways that guessing will no...
Hello!Couple of quick questions which will help determine the exact code and approach.Are you using HANA or SQL? HANA is a bit easier to do aggregate string concatenation STRING_AGG() although it's definitely something I have done in SQL too.Secondl...
I hate to be the bearer of bad news but you can't do what you're asking with stock SAP using an FMS.If the data is not in the database then you can't pull it with FMS from a grid. There is no way I know of that can loop the columns to do the total. ...
Oh baby baby this is right in my wheelhouse. A B1UP grid loop of an SQL Report UF??I have done something very similar, not identical but my code will hopefully give you a couple of good ideas on how to troubleshoot your UF.The point of my code is to...