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

Import Program

• Version (5.0.0.7) - 04 Jan 2017
• Evaluation Limit : 100 Records & Unable to Multi Filtering (3 dot Button)

(For Version 737 & above)

• http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChangeV5-setup.exe
• MD5 : CA450356735CD6ADCC50536F8B3EB701

(For Version 736 & below)

• http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChange-setup.exe
• MD5 : 8C73130765BFA98A5BB59EF069422BBC

History New/Updates/Changes

--Build 7--

• Fix unable filter by Stock Category.

--Build 6--

• Fix No Caption for Maintain Stock Item.
• Fix missing file when build setup file.

--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/parameter to be update in the Steps 1 section

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