SQL Acc Global Price Change: Difference between revisions

From eStream Software
Line 14: Line 14:


==Import Program==
==Import Program==
* Version (5.1.0.9) - 31 Mar 2017
* Version (5.2.0.10) - 08 May 2017
* Evaluation Limit : 100 Records & Unable to Multi Filtering (3 dot Button)
* Evaluation Limit : Unlimited
(For Version 737 & above)
(For Version 737 & above)
* http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChangeV5-setup.exe  
* http://www.estream.com.my/downloadfile/Fairy/SQLAccGlbPriceChangeV5-setup.exe  
* MD5 : C131EF35B383DCCC7567C356E879E3B4
* MD5 : 60EBB6729E80A978DF5A94E485FEEEFE




Line 26: Line 26:


===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 10--
* Upgrade to 5.2.
* Allow update Disc, DateFrom and DateTo but no log & no batch update all.
* Remove Import Limit.
--Build 9--
--Build 9--
* Enable Re-Get File without had to close windows.
* Enable Re-Get File without had to close windows.

Revision as of 04:40, 8 May 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.2.0.10) - 08 May 2017
  • Evaluation Limit : Unlimited

(For Version 737 & above)


(For Version 736 & below)

History New/Updates/Changes

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

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

See also