SQL Acc Global Price Change: Difference between revisions

From eStream Software
Line 31: Line 31:
:02. Select data to be update.
:02. Select data to be update.
:03. Click '''Get Stock Items List''' button
:03. Click '''Get Stock Items List''' button
[[File:GlbPrice-02.jpg|800px|center]]
:04. Enter the Value to change. It can be in Value and/or Percentage (%) except for Fixed Value only Value
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! Option !! Description
|-
| Rounding Method || Example
|-
| 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


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

Revision as of 07:29, 10 December 2015

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

  1. Rounding 5 Cents

Import Program

History New/Updates/Changes

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

01. Click Maintain Stock Item...
GlbPrice-01.jpg
02. Select data to be update.
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 Example
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

See also