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

Import Program

• Version (5.2.0.19) - 20 Dec 2021
• Evaluation Limit : Unlimited

(For Version 737 & above)

• SQLAccGlbPriceChangeV5-setup
• MD5 : FB4B5F78767E0C20FEE0F46BFAD3D279

(For Version 736 & below)

• SQLAccGlbPriceChange-setup
• MD5 : 8C73130765BFA98A5BB59EF069422BBC

History New/Updates/Changes

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

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

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

[top]

Steps - By Company Price

01. Click Maintain Stock Item - By Company...

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

03. Select Company Type

04. Click Get Stock Items List button

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

06. Click Change button.

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

It use Customer/Supplier Price Tag (Company Column)

[top]

FAQ

Can I self enter/change the price by item code?

Yes, just enter 0 in Step 4 & Change the Value in the grid (Circle in Red)

[top]

See also

• Others Customisation