SQL Acc Global Price Change: Difference between revisions

From eStream Software
 
(26 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Introduction==
==Introduction==
Is an External Shareware Program which able to update the Stock Item Price On
Is an External Freeware Program which able to update the Stock Item Price On
* Reference Cost
* Reference Cost
* Reference Price
* Reference Price
Line 10: Line 10:
* Supplier Price
* Supplier Price


==Todo==
==Todo & Know Bugs==
* Log for Changes Discount, DateFrom & DateTo for Customer/Supplier Price Tag
* Item Description for Item by Company
* Allow batch change Disc, Date From & Date To for Customer/Supplier Price Tag


==Import Program==
==Import Program==
* Version (5.2.0.10) - 08 May 2017
* Version (5.2.0.22) - 20 Aug 2022
* Evaluation Limit : Unlimited
* Evaluation Limit : Unlimited
(For Version 737 & above)
(For Version 737 & above)
* http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChangeV5-setup.exe  
* [https://download.sql.com.my/customer/Fairy/SQLAccGlbPriceChangeV5-setup.exe SQLAccGlbPriceChangeV5-setup]
* MD5 : 60EBB6729E80A978DF5A94E485FEEEFE
* MD5 : 033E0F7AD958E8BC9966A0DE38333BF7




(For Version 736 & below)
(For Version 736 & below)
* http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChange-setup.exe
* [https://www.sql.com.my/downloadfile/Fairy/SQLAccGlbPriceChange-setup.exe SQLAccGlbPriceChange-setup]
* MD5 : 8C73130765BFA98A5BB59EF069422BBC
* MD5 : 8C73130765BFA98A5BB59EF069422BBC


===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 22--
* Fixed Error which Amount too big.
--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--
--Build 10--
* Upgrade to 5.2.
* Upgrade to 5.2.
Line 100: Line 143:
* Reduce Value : Will Deduct 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)
* 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.
:05. Select field to be update.
Line 115: Line 159:
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>


==Steps - By Company==
==Steps - By Company Price==
:01. Click '''Maintain Stock Item - By Company...'''
:01. Click '''Maintain Stock Item - By Company...'''
[[File:GlbPrice-03.jpg|800px|center]]
[[File:GlbPrice-03.jpg|800px|center]]
Line 125: Line 169:
:06. Click '''Change''' button.
:06. Click '''Change''' button.
:07. Click '''Post To A/c''' button to update the data
:07. Click '''Post To A/c''' button to update the data
{| style="margin: 1em auto 1em auto;"
|-
|
----------------------------------------------------------------------------------------------------------------------------------------------------
{|
|-
| [[File:Template.Tips-01.jpg|60px]]||
It use Customer/Supplier Price Tag (Company Column)
|}
----------------------------------------------------------------------------------------------------------------------------------------------------
|}
<div style="float: right;">  [[#top|[top]]]</div>


==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)
[[File:GlbPrice-05.jpg|800px|center]]
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>


==See also==
==See also==
* Others [[Customisation]]
* Others [[Customisation]]

Latest revision as of 00:53, 20 August 2022

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.22) - 20 Aug 2022
  • Evaluation Limit : Unlimited

(For Version 737 & above)


(For Version 736 & below)

History New/Updates/Changes

--Build 22--

  • Fixed Error which Amount too big.

--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...
GlbPrice-01.jpg
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
GlbPrice-02.jpg
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
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg
Select Record Change History option if you wanted to Keep Changes History in the
Note Fields for each itemcode
----------------------------------------------------------------------------------------------------------------------------------------------------

Steps - By Company Price

01. Click Maintain Stock Item - By Company...
GlbPrice-03.jpg
02. Select data/parameter to be update in the Steps 1 section
03. Select Company Type
04. Click Get Stock Items List button
GlbPrice-04.jpg
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

Template.Tips-01.jpg

It use Customer/Supplier Price Tag (Company Column)


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)
GlbPrice-05.jpg

See also