SAP Business One | my quick notes: 2014

Friday, 31 January 2014

How does Google make you an IT guru?

If you have an IT problem like what I had this afternoon what do you do? Imagine I wanted to insert the name of my excel file into one of the cell of the same excel file.

What I did? I just opened my friend Google, typed in my problem, submit it and bang. In most of the cases I can find the ready to use, cut and paste solution. I can do programming but in this way it is just so easy. Nowadays you don't even need to know how to write functions in Excel, Cut and Paste, that's it.

Inserting the current Excel file name in a cell. Enter the following formula as an array formula to display the current file name and active worksheet name:

=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH("\",CELL("filename"),ROW(1:255)))))

Source: http://office.microsoft.com/en-gb/excel-help/inserting-the-current-excel-file-name-in-a-cell-HA001034627.aspx

I just wondering how lucky we are.

Friday, 10 January 2014

Multi level drill-down in SAP Crystal Reports

Creating a new report with drill-down is fun and easy with Crystal reports. I've just finished a full drill-down Profit and Loss report with multi level drill-down. The first level of drill-down displays the details, with the second level you can go directly to the transaction in SAP.

Drill down to SAP was easy, only small challenges:
- I had to find a golden arrow picture. I just cut it one from my screen, and paste it to my report.
- Drill Down to SAP Business One from the report requires a link. Remember: when you add the link, click on the button next to the field of the link, and add the link. It was not enough just to fill in the field.

This is the syntax what I used for linking:
'http://$b1$/link?table=OJDT&key='+CStr({Command.TransID}, 0)

If you use this sample, you will be able to drill down to the Journal Entry in SAP B1.

Note: you will need the TransID to add to your report before you do the linking.

Easy?

Tuesday, 7 January 2014

SAP Business One Demo Resources

Random Name Generator
The Random Name Generator is a simple fiction writing tool to create character names. The generator contains English first and last names.

http://random-name-generator.info/

QR Code generator