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

• Rounding 5 Cents

Import Program

• Version (5.0.0.5) - 12 Dec 2016
• Evaluation Limit : 100 Records & Unable to Multi Filtering (3 dot Button)
• http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChangeV5-setup.exe (For Version 737 & above)
• MD5 :
• http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChange-setup.exe (For Version 736 & below)
• MD5 : 8C73130765BFA98A5BB59EF069422BBC

History New/Updates/Changes

--Build 5--

• Upgrade to Version 5.
• Add 5 Cents Rounding Option.
• Enable support SQLAccV5.

--Build 4--

• Fix Unable Compare Long Address in Register Form
• Extended trial limit to 100 records.

--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

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

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

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

See also

• Others Customisation