Error Upgrading SI Metabase

If you have recently upgraded to Sage Partner or Sage Xpress Version 14,  with Sage Intelligence  and you keep receiving the message “Error Upgrading SI Metabase” I have the solution.

Error Upgrading SI Metabase

Error Upgrading SI Metabase

Here is the solution to correct the “Error Upgrading SI Metabase” issue:

It is a registry setting that needs to change.  See below.  The server “Path” needs to change from C:Pastel14 to P:,  or the Mapped drive letter that is being used to map to your Pastel14 folder on the server.

You will find this key in the following location:

Click START – RUN and type in regedit
Browse to: Computer HKEY_LOCAL_MACHINESoftwareWow6432NodeSoftlinePastel Partner 14

Registry Entry

Registry Key Entry

“Right Click” on Path,  and select Modify 

Modify Registry Entry

Modify Registry Entry

In the “Value data:” field,  change the path.  Select the mapped drive that has been used on your workstation.

Modify Value Data

Modify Value Data

 

NB!  If you are not comfortable with editing registry keys, ask your IT Administrator to assist with this.

Until next time..

Steve

 

 

Server is out of Date

Version 12 Users. Have you recently downloaded the Partner/Xpress update 12.1.6, and received the following error: The Pastel Version on the Server is out of Date

One of my clients recently experienced this, after installing on a brand new machine.  After a lot of troubleshooting, uninstalling, reinstalling, and a lot back and forth with Pastel Support, I have finally received a couple of solutions. I would like to share the first one with you.  Should this not work, I have a second solution (which entails emailing an attachment).

Please follow the below steps if you receive the message that The Pastel Version on the Server is out of Date:

• Go to ‘Start – All Programs – Accessories – Run’.
• Type (or copy and paste) the below in the window provided, you may refer to the screen shot below.

Msiexec /i {02788CFF-51EF-493C-A2ED-5C6636257C26} REINSTALL=ALL REINSTALLMODE=vomus

• Select the ‘OK’ option, the error message should be cleared.

Should this not work, as mentioned, please contact me by posting a reply to this blog  and I’ll email you an attachment with further instructions.

Remember, if you’re not the person responsible for your Pastel/Network environment, be sure to check with the powers that be before you do anything.  And always, always backup first.  When in doubt, call Sage Pastel Customer Care or your Sage Pastel Consultant before doing anything you’re unsure of.

Good Luck!!

Steve

Our suite of Sage Pastel Accounting related Professional Services include:
Business Consulting
Sage Pastel Partner Payroll Sales & Support
Sage Pastel Partner Payroll SARS Submission assistance
Sage Pastel Partner Payroll Outsourcing
Sage Pastel Accounting Software Sales & Support
Sage Pastel Accounting Software Implementation & Project Management
Sage Pastel Accounting Troubleshooting & Data fixing
Excel Reporting
Onsite End User and Advanced Training
3rd Party Application Development

e2e logo and name

End 2 End Business Solutions

Stock re-ordering, get it right

Have you ever prepared for a seasonal turnover spike only to run short of stock exactly when you least want to?  Or spotted a turnover spike too late to stock up for it?  Or simply missed the boat completely?  Knowing when to order stock is a bit of a calculated gamble, and, the more relevant information you have the better you can manage your stock re-ordering.  I say ‘relevant’ specifically because some people simply go with the prior months sales information as an indication of the following months orders. Obviously, in most instances, this won’t be the most effective ordering method to use. Obvious reasons why not include: what if the previous month was one of your exceptions? (i.e.: very high, or, very low), or, if a sales person made an ‘out of the ordinary’ sale, then basing your next months re-order on that exception will clearly skew your stock and negatively impact your Cash Flow.

I know that not all companies using Inventory will carry stock, some will only place orders as and when they receive customer orders. However, those that do carry stock will be well aware of the stock re-ordering pitfalls: “ordered too much”, “ordered to few”,”ordered the wrong items”, etc, etc. Having a few simple indicators handy when calculating one’s stock order, can often, and, sometimes quite easily assist your ordering clerk with ensuring the accuracy of the stock re-ordering process.

Some useful stock re-ordering indicators:

Prior Year sales for same period
Prior Month sales
Stock On Hand
Customer Orders
Outstanding Purchase Orders (and lead time of these orders)
Slow moving stock
Fast moving stock
Lead times (eg: if at the end of January your ordering clerk orders stock for Valentines day, but, your lead time is 21 days, then you’re stuffed aren’t you?)
Industry specific events
Local/National/International events (school holidays, Olympics, etc)
National & International Holidays (imagine a chocolate company not catering for Valentines Day or Easter)

Some of these indicators are obvious and easily obtained. For the more precise ones (Inventory Trend Analysis), there are various reporting options available. This is, of course, a very general overview of the stock ordering process as there are many, many more factors that will impact industry specific companies eg: Manufacturing, Lot Items, FMCG, etc, etc.

Essentially what I’m trying say is: “Setup your environment to give you as much information regarding your stock movement as you can”, and, “don’t order your stock without taking in as many factors as your environment allows you too”.

Here’s to fast-moving, and, profitable stock rotation 🙂

Brian