How to Void a Check in Sage ERP X3

Voiding an Accounts Payable check in X3 is a simple process, but unfortunately the option is not conspicuous and is therefore the steps are sometimes forgotten.  The steps for voiding a check are as follows:

1. Go to the task A/P-A/R accounting>Payments>Payment/receipt Entry.

2. Select the transaction type.   In this example, I am using the transaction "PAYAT Automatic Check Issue" because the check that I wish to void was printed in a batch.

3. Below is a screen shot of my payment.   The key information that I am looking for is the status and whether there is a check number.   This information will determine the next step the process.

4. There are many different status that a payment record can have.   In this blog, we are only discussing the 2 most common statuses,  "Entered" and "In the Bank".
  
       a.  Entered Status - If a payment has a check number and has the "Entered" status, then a check has been printed, but it has not yet been posted.   In this case, the check can be voided from the Option menu by selecting "Check Void".   This feature removes check number from the payment record. 

     b. "In the Bank" Status - If a payment has this status, then it has been posted and ledger entries exist for this check.   In this case, you would select "Accounting cancellation" from the Options menu.   This feature will first reverse the ledger entries for the check and then remove the check form the payment record.

How to Create Cost Plus Pricing in Sage ERP X3

Sage ERP X3 defines several pricing models out-of-the-box and X3 gives you flexible tools to allow you to define your own custom rules.  Cost Plus pricing is not one of the base pricing models that comes in Sage X3 ERP Standard Edition.   However, Cost Plus pricing can be easily added by following the steps below (instructions are for X3 V6.5):

1.       In X3, you must first define the “Cost Plus” pricing model.   To do this, navigate to the task at Setup>Sales>Price Lists>Setup.   

2.       In the left list, click on the Price List Code “CUST”.   We will be copying this record.

3.       In the Price List Code field on the right screen, change the value “CUST” to “CSTPLS” and the description to “Cost Plus”.   Change the Reason to 16 for "Cost Plus Price".

4.       On the Criteria tab in the Criteria grid, right click and delete the SPRICLINK file.

5.       On the Price/free tab, change the “Price Processing” field to “Factor”  (this is sometimes called coefficient).

6.       In the base price field, enter the cost that you want to use for the markup.   For average cost, enter the value “[F:ITV]AVC”.   For standard cost, enter the value "[F:ITC]VLTTOT".   Note that you can also right click on this field and select the cost using the formula wizard.   The cost fields are stored in the ITMMVT table.    When you have completed this step, your end result should look something like the following:

 Next, you can define which products that you want to price with Cost Plus pricing.   This is done by clicking on the menu Sales>Price lists>Price List Entry.    Use the following steps to create the price.

1.       In the Transaction Selection screen, select the “CSTPLS” pricing model that you created earlier.

2.       Click on the New Button.

3.       Enter a validity date range.

4.       Enter a product and a qty range.

5.       In the coefficient field, enter the markup factor as a decimal.    For instance, if you want a markup of 5%, enter  “1.05” as the coefficient.   

 Note: If you sale unit is different from your stock unit, then your coefficient should start with the unit conversion factor.   For instance, if you stock in EA, but the sale unit is CASE (of 12), then your coefficient would start at 12.  This is because the cost is stored in the stock unit of measure.   Therefore, you need the coefficient convert this cost to the SAL unit in addition to any markup.   For this example, for a 5% markup on each case, the coefficient would be 12.6000.

 

Once you have completed these steps, your Cost-Plus price is ready to use.

How to add a phone extension in Sage ERP X3

The following are instructions for formatting phone numbers in Sage ERP X3 to allow phone extensions:

1. In the Country task under Common Data>Common Tables, select the country code.  In my case, this would be the US.
2. Edit the default telephone format.  This can be found on the details tab.  By default, the US format is 10 digits represented by the "#" sign.   The "[-]" formatting symbols indicate that a dash will be added to the phone numbers when displayed.

In the US, there is no standard on which extension prefix to use.   Below are 3 common formats:

555-555-5555 ext 555      format:   ###[-]###[-]####[ ext ]###
555-555-5555 x55555      format:   ###[-]###[-]####[ x]###
555-555-5555  55555       format:   ###[-]###[-]####[ ]###

The problem with the first 2 formats above are that the extension prefix character (ie. "ext","x") will always show regardless of whether the number you have entered has an extension.  

Example:    555-555-5555 ext

That is why the format show below is preferable:


Once you save you change above, the phone extension will be immediately available throughout the system.





David Padgett
President
Golden Lab Software, Inc.
http://www.goldenlabsoftware.com

Is your business running on outdated systems? Is it time to upgrade to a state-of-the-art ERP solution?

Is your business running on outdated systems? Find out if it's time to upgrade to a state-of-the-art ERP solution, today!

Ensuring you have the right IT solution is critical when it comes to building and growing your business. Periodically performing a gap analysis can help determine whether the legacy systems you have in place are still working for you or whether it's time to upgrade. Where do I start? Download this free Sage ERP Solutions white paper that will guide you through the gap analysis process. It just may help you uncover inefficient and manual systems that are ultimately impeding productivity and business growth. In today's dynamic and highly competitive business environment, a state-of-the-art ERP solution may be the answer to: Meeting regulatory requirements. Streamlining operations. Scalability now and for the future. Global business growth. Everything you need to get started in one free white paper. This Sage ERP Solutions white paper is the first step in moving towards a more detailed evaluation. Is a state-of-the-art ERP solution the right move for you? Help get the answers by downloading the free white paper, today! About Sage Sage is a leading provider of business management solutions for start-up, small, and midsized businesses. We help our customers run their organizations more effectively by emboldening them to gain greater insight into their business activities and automate their business processes. With you every step of the way. When you invest in a business solution you have the right to expect that it will be implemented with the greatest skill and knowledge. Golden Lab Software, Inc. offers the local expertise and proven methodologies you need to maximize your investment. With our help, you can be confident it will be done right the first time.

Finally, a business management solution designed specifically for the food and beverage industry

Being in the food and beverage industry, your organization needs a proven business management solution that will improve quality assurance, help you make faster and better informed strategic and tactical decisions, and grow your business more effectively.
Get the right ingredients for success.
From food safety and regulatory compliance to quality management and in-depth trace-ability, you need a solution that will equip you to better serve your customers while keeping costs low.
Managing Business Risk in the Food and Beverage Industry
Download this free guide that tells you how you can easily manage FDA regulatory compliance, improve food safety and planning, and make a difference to your bottom line.
Learn about the three greatest risks to producers in the food and beverage industry, and strategies to avoid the pitfalls. Plus you'll learn what a good business management system should provide, giving you the ability to:

• Get total forward and backward trace-ability on product for more accurate, immediate recalls
• Follow each ingredient through to the store shelf to give you more control and visibility in protecting your company's reputation
• Leverage a powerful formula and recipe management engine to ensure quality and cost control
• More effectively manage product and process costs, labeling and nutritional value, and order fulfillment

Download our free guide or, give me a call and we'll arrange for a personal consultation. Golden Lab Software, Inc. has over 14 years' experience in implementing a business management system in your industry.

Increasing Efficiencies in the Chemical Industry

If you are in the chemical industry, discover how improving chemistry between departments increases efficiencies while dramatically reducing costs.  Follow the link below for the white paper.

oal.lu/l5CEF 

Webpage Redesign

The GLS website has recently undergone major renovations.    These renovations were made to enable us to better serve our clients and provide better access to our information library.   This is just one of the many exciting changes and events that we have planned for 2013 as we continue to add to our product offerings and as we grow as a company.     We will announce events and new offerings in the GLS Blog Feed section as the information becomes available.   You can also follow us on LinkedIn, Facebook and Twitter.