Clients First USA
Clients First knows their software, but they are also astute business people, and they really understand manufacturing and distribution in particular.
Jimmy Witcher, COO, Merrick
Read More
About UsService OfferingsProduct OfferingsIndustries ServedDownloadsBlogTestimonials

Subscribe to our mailing list

* indicates required
    Interested in    
Hot Topics

Posts Tagged ‘Tips’

Last Used History

Thursday, August 15th, 2013

Getting to recently used records

Some Epicor screens keep track of the data you have been using.   This history is found on the File menu. It’s a fairly common feature in most modern Windows applications like Microsoft Word or Excel.

The first time you open a screen like Customer maintenance the File menu looks like this:            


Look up Addison, Boeing and Dalton.   Close the Customer Maintenance screen.

Reopen the Customer Maintenance screen and look at then File menu.  Notice the three customers listed below the Exit.


Click on the Addison line and Epicor will load the Addison information into Customer Maintenance.


Create a Unique Look & Feel for each Sage ERP 100 (MAS 90, MAS 200) Company Code

Wednesday, April 10th, 2013


Make is easy to keep track of which company you are in.

Have you ever accidentally started entering live information in a historical or backup company because you forgot to switch companies?

Sage 100 ERP (MAS 90/200) version 4.4 and newer allows you to control the background color for each company. This Sage 100 ERP (MAS 90/200) tip will provide you the steps to change the background color for a company.

  • Go to Library Master > Main > Company Maintenance
  • Select your company code (I’ve used company XYZ)
  • Click on Tab #2 Preferences
  • Towards the bottom of the screen look for Background Color and check the box for “Enable Company Specific Background Color”
  • Then click on the Select Color”



·     A color pallet window will appear where you can select a background color.

o  Tip: You may want to select a somewhat muted color Very Dark or very bright colors can make it difficult to read the text on the screens.





·     You can select a color from the choices on the Color window, or you can click on “Define Custom Colors to get a larger range of colors






·     Click on OK when you have a color you like

·     Note that when you go back into Sage 100 ERP the main screen and any Library master screens do not change because they are global to all companies in Sage 100 ERP; however any screens that you launch within other modules will have your company specific background color displayed

*Note, we are not responsible for poor taste in color coordination as you can see below Smile






We hope you found this tip useful.  Hit the chat button below if you need our assistance with anything.

SAP Business One Tip – How to determine the next available FIFO layer and its remaining quantity?

Wednesday, April 10th, 2013

Have you ever wanted to know what FIFO layer in your on-hand inventory is going to be used next, its unit cost and how much of it remains on hand?

When an item is managed by FIFO (First in First Out), layers are created in the system as stock receipts are posted in the OITM or OITW tables. Information relating to the subsequent issuances of these FIFO layers is also stored in OINM. Likewise, an A/P Invoice created for this item will create new layers in OINM. These records however, do not carry information as to the open quantities and the current costs per open layer. In order to determine the next available FIFO layer, its remaining quantity and cost, the user needs to run a report on OINM using this query.


/* Unlike items managed by Moving Average and Standard valuation methods, the item cost of items managed by FIFO are only accessible through OINM. This query will enable the user to find the next item cost for a given item numbermanaged by FIFO. */

Select Top 1 T0.HTransSeq, /* The highest transaction number represent the highest revaluation line for a given layer. Selecting the top 1 when order desc will enable to select the last revaluation of the layer */

T0.Transtype, /*Provide the information on the origin of the layer*/

T0.Base_REF, /* Provide the document number when exists */

T0.ItemCode, /* Item number */

T0.calcprice, /* Cost price */

T0.openqty, /* available qty for the layer */

T0.BaseCurr, /* currency of the transaction */

T0.TransSeq, /* Layer number */

T0.HTransSeq /* Highest revaluation of a given layer */



Inner Join

OITM T1 on

T0.Itemcode = T1.Itemcode

Where T1.Evalsystem =’F’ and /* check only the item manage by FIFO */

T0.openqty > 0 and /* exclude the layers where the open quantity is null */

T0.itemCode = ‘FIFO3’ and /* Select Specific item number */

T0.Warehouse = ‘[%0]’

Order by

T0.HTransSeq desc /*Order desc enable to select the last layer revaluated */

SAP Business One – Open Receivables balance by Customer Query

Tuesday, April 2nd, 2013



SAP Business One Support and Tips

Here’s a quick tip.  Use the query below to get a nice report of one line per Group, per Business Partner of their current open Balance.  You can sign up for many tips like this at our new SAP Support Site at:

If you need help with the Query Generator, click the Chat button at the bottom of the page.


Query Generator – Summary of Business Partner Balance by BP Group Code

SELECT T0.[GroupCode], T1.[GroupName], SUM(T0.[Balance]) AS ‘Balance’
FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode
WHERE T0.[CardType] =[%0]
GROUP BY T0.[GroupCode], T1.[GroupName]
ORDER BY T1.[GroupName]

Our new Clients First SAP Business One website

Wednesday, March 27th, 2013
sap business one site

A screenshot of our all new SAP Business One Support Site


One stop for everything SAP Business One from Clients First Business Solutions

We are proud to announce the roll out of our brand new SAP Business One specific website.  This site contains all the information about our world class SAP Business One software practice.  It also includes a sign up for 50 weeks worth of valuable tips & tricks including queries, reports and other valuable information.  You can sign up right on the home page and can unsubscribe at any time.  This content previously would have required an expensive paid subscription but through our exclusive arrangement, we can bring it to you at no charge.

The site will be expanding rapidly with new content including information about our add-ons and vertical solutions offered as well as a full free demonstration and video training library coming soon.

If you sign up for the tips & tricks, you’ll also receive our once per month newsletter containing all our new tips & blog post content related to SAP Business One.

If there is other Business One Related content you would like to see, drop us a line in the chat below here or on the new site and we’ll do what we can to provide you with what you would like.

Check it out now.