SQL Acc Global Price Change

From eStream Software
Revision as of 00:53, 20 August 2022 by Twfaung (talk | contribs) (→‎Import Program)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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