SQL Acc Global Price Change: Difference between revisions

Revision as of 03:10, 31 March 2017

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

Import Program

Version (5.1.0.9) - 31 Mar 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 : C131EF35B383DCCC7567C356E879E3B4

(For Version 736 & below)

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

History New/Updates/Changes

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

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

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