SQL Acc Global Price Change

Introduction

Is an External Freeware 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 & Know Bugs

Import Program

Version (5.2.0.21) - 28 Jun 2022
Evaluation Limit : Unlimited

(For Version 737 & above)

SQLAccGlbPriceChangeV5-setup
MD5 : 87C6E60FEE893B5E8B106B713043E121

(For Version 736 & below)

SQLAccGlbPriceChange-setup
MD5 : 8C73130765BFA98A5BB59EF069422BBC

History New/Updates/Changes

--Build 21--

Enable support Unicode.
No record Shown when filter by Customer/Supplier for Maintain Stock Item - By Company.

--Build 20--

Fixed System will hang very long when filter Category with lot of itemcode

--Build 19--

Fixed the date filter not fully shown.
Maintain Stock Item - By Company item not filter by category.
Add Get User Guide Shortcut.

--Build 18--

Fixed Note unable to get Original Note data before append History.

--Build 17--

Fixed Note still update even not selected.

--Build 16--

Change New Icon with support 256*256 size.
Add Update by UOM/Rate option.
Add Base on Ref Cost option.

--Build 15--

Add Filter Tax Option.
Add Output Tax & Input Tax Column.
Fix Prompt Error on Click Change When in Grid Mode.

--Build 14--

Add Inclusive Rate Formula.
Move Price Calculator to Main Menu.
Increase menu button size.

--Build 13--

Fixed By Company for Supplier not working

--Build 12--

Fixed redundancy box.

--Build 11--

Add change Disc, DateFrom and DateTo log & batch update all.
Add Item Description for Item Code by Company.

--Build 10--

Upgrade to 5.2.
Allow update Disc, DateFrom and DateTo but no log & no batch update all.
Remove Import Limit.

--Build 9--

Enable Re-Get File without had to close windows.
Fix Error cdsUOM: Cannot perform this operation on a closed dataset.

--Build 8--

Upgrade to Version 5.1.
Add Grid Mode Option.
Add By Company Price Change.
Add Orig Price Column.
Add Orig Price For History.

--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 - By Item Code

01. Click Maintain Stock Item...

02. Select data/parameter to be update in the Steps 1 section

Option	Description
Grid Mode	Select this if your item list is more then 10,000 record to speed up the loading data

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) Inclusive Rate : Eg Amount 106 & user enter as 6% will become 100