SQL Acc Global Price Change

Introduction

Is an External Shareware Program which able to update the Stock Item Price On

• Reference Cost
• Reference Price
• Minimum Price
• Maximum Price
• Minimum Cost
• Maximum Cost
• Customer Price
• Supplier Price

Todo

1. Rounding 5 Cents

Import Program

• Version (4.0.0.3) - 26 Nov 2015
• http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChange-setup.exe

History New/Updates/Changes

--Build 3--

• Fix memory leaking on large records
• Reduce the exe size.

--Build 2--

• Fix Unable to Filter by Stock Group.
• Remove the Stock Menu.

Steps

01. Click Maintain Stock Item...

02. Select data to be update.

03. Click Get Stock Items List button

04. Enter the Value to change. It can be in Value and/or Percentage (%) except for Fixed Value only Value

Option	Description
Rounding Method	Assuming Round Decimal is 2 Normal : Example : 0.1234 => 0.12 Round Up : Example : 0.1234 => 0.13 Round Down : Example : 0.1274 => 0.12
Input Value	Sample Value
Output Result	Sample Result
Round Decimal	No. of Decimal Point
Output Value	Action to taken Increase Value : Will add up the value base on Option selected Reduce Value : Will Deduct the value base on Option selected Fixed Value : Will replace base on Value Set at Step 4 (only amount)

05. Select field to be update.

06. Click Change button.

07. Click Post To A/c button to update the data

Tips

----------------------------------------------------------------------------------------------------------------------------------------------------

Select Record Change History option if you wanted to Keep Changes History in the Note Fields for each itemcode

----------------------------------------------------------------------------------------------------------------------------------------------------

See also

• Others Customisation