SBOnotes.com - Tips and Tricks

Looking for a SAP Business One Job?

admin — Tue, 12 Jan 2010 08:33:39 PST

Now on www.SBOnotes.com, place your resume on your profile and it will automatically appear on the website. If you are looking for a Business One job, where better than the place where companies and consultants use as a reference?

Also, we have consolidated job postings (US) from various differe job sites for Business One Jobs!

As always SBOnotes.com is free of charge, but many of the service require you setup an account.

Thank you for your continued support!

Ed Monk

SAP Business One Jobs Consolidated From around the Web

admin — Wed, 30 Dec 2009 08:15:47 PST

Now for registered users on SBOnotes.com...

SAP Business One jobs from several job boards around the Internet are consolidated onto one page on SBOnotes.com.

Look for "SBO Jobs" in the navigation bar at the top of the screen.

http://sbonotes.com/jobs

Year End Closing Tips from the Orchestra Team

admin — Tue, 29 Dec 2009 11:15:54 PST

"jm" from The Orchestra Team published a nice, in-depth article on closing out the year on SBO.

SAP Business One Year End Closing Tips

Formatted Search: Retreive Current Username

admin — Tue, 29 Dec 2009 10:32:39 PST

If you need to get the user name of the person currently signed in for a document field use this query:

SELECT T0.U_NAME FROM OUSR T0 Where internal_k = $[user]

No Link Arrows in Your Query?

admin — Tue, 29 Dec 2009 10:31:42 PST

If you are missing a link to arrow next to a field you would normally expect to see an arrow, you must have forgotten to put...

Maximum Number of Fields for Print Layout Designer (PLD)

admin — Tue, 29 Dec 2009 10:30:42 PST

While creating a report in Print Layout Designer (PLD) from a query I noted that the maximum number of fields that the PLD would import was 100.

No Field Names in your Print Layout Designer (PLD)?

admin — Tue, 29 Dec 2009 10:29:42 PST

If you do not use FOR BROWSE in your query and you attempt to create a Print Layout Designer (PLD) report from that query, you may find that there will be no field descriptions for the fields.

High Quantity on a Sales Order

admin — Tue, 29 Dec 2009 10:28:42 PST

Use this query to check for high order quantities on a Sales Orders.

If you make an alert out of this query, then you can be notified when potential keying errors occur.

Query to Show Open Balances by Customer (or Vendor)

admin — Tue, 29 Dec 2009 10:27:27 PST

Use this query to show you a list of open balances by customer group. If you would like to see

open balances by vendor, then change the Where clause to cs.cardtype = 'S'.

Query to Show Customers Without Sales Employees Assigned

admin — Tue, 29 Dec 2009 10:26:12 PST

Use the query to show all of the customers that do not have sales employees assigned. You can use this as an alert as well.

SELECT CardCode as BP, CardName as 'Customer Name' FROM OCRD Where SLPCODE = -1 and CardType = 'C' FOR BROWSE