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!If you do this manually in the UI and you have for example 10 quantity of a batch managed item and then you count it to zero you have to select all of the batches at a negative quantity to write out. In my example you would need -10 quantity o...
I like the sales BOM approach and it may work. If you got the quantity linked together via BOM and then dynamically selected the price using an FMS query based on city I think this is something worth testing.You can dynamically pull the city address ...
There is no way to do this using tax code determinations in a USA localization (flat fees over percentage). So you should give that up.Simplest way is a non-inventory item linked to the right GL account, then a user just adds it to the document and m...
Hello, I do not represent SAP but I doubt they are going to randomly increase the size of all of their numeric fields. You could log a ticket with SAP Global Support to check but I think you'll be waiting a long time before they make any changes. You...
I don't really think this is an SAP Business One issue. Crystal Reports does not have a black & white setting that can be accessed via the UI as far as I know. It can be setup in the Crystal Reports code but the SBO runtime does not seem to include t...