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 ...
Have you imported this into the SAP Client?Try making the DocKey@ parameter with no tables and then drag it onto the report, save it and load it into a document layout then do a print preview. You will see that it passes the DocEntry not into Crystal...
My B1UP customization currently does not do multiple invoices.They do landed costs for landed costs, this is just for carrier costs for transport from 3PL to production. They roll their other costs into production. I work with a ton of customers, thi...
You just need to use an aggregate with COUNT() and then a WHERE with NOT LIKE and a wildcard.SO, I don't see your query but something like:SELECT "BinNumber" AS "Bin Number",COUNT("ItemCode") AS "Items"FROM X (whatever your specific query is)WHERE "B...
I just did this for a customer using B1UP, they use a lot of 3PLs and they want to track cost like this.I added a field for a carrier invoice to the transfer and then made an automated mechanism that divides the cost between the quantity and does an ...
If you are working with the Crystal Reports runtime within the SAP Client you need to use the tokens that SAP uses. IE, look at the default CR layouts and you will see:DocKey@ is a static numeric parameter that SAP replaces with the DocEntry of the ...