E-COMM TOP-UP MECHANISM

A2000 ONLINE SUPPORT DEPARTMENT

KNOWLEDGE BASE

DESCRIPTION          We need to introduce a Membership Pre-payment System in our e-commerce and integrate with ERP system. How to implement this?

1. SCENARIO

We want to have customers making prepayment that comes with bonus. As we sell consumable items, this will encourage “stickiness” so the customer will keep coming back to re-order more from us.

he stock balances displayed in Stock Status Query, Warehouse Stock and in the drop-downs when entering any sales/purchase transactions, are picked up from a static Quantity Balance field in the system. This is referred to as “quick-reference quantities”.

The Stock Ledger (or Stock Card) quantities are derived from the stock transaction table. When reporting the final stock balance, it computes the Opening Stock, Incoming and Outgoing transactions and the final balances are the most accurate values in the system. 

NOTE: The Stock Ledger quantities and stock valuations can be reported as on any date (even in back-dated report), whereas the quick-reference ones can only report as-on-current date. As a rule of thumb, the stock ledger is always the most accurate report.

2.  WHY NEED TO USE QUICK REFERENCE QUANTITIES?

In a typical transaction, the system needs to show user the available quantity to sell very quickly. The system cannot afford to perform detailed queries (like Stock Ledger) at every transaction line. It will be too slow when entering new transactions. 

As such, the system uses a compromise and uses the “quick reference quantities”, which is a field constantly updated (in & out) whenever an item is transacted. This quantity balance shown is always “as at-today” as it is a static field updated in real-time. It is unsuitable to check stock balances on a back-dated basis, as it will always show current date’s status.

3.  ISSUES WITH QUICK REFERENCE QUANTITIES?

As explained, the system updates the Stock Balance field when the transaction closes at the SAVE button. It updates instantaneously the balances, and in the next second, someone else looking at the product will see a revised quantity balance.

However there are instances users do not complete the transactions; i.e. they create and/or edit a transaction but did not save, or the close the transaction screen (web browser) before the update is done to the stock balance field. These become un-updated balances that skew the quick reference quantities.

REMEDY  This is easily fixed by running the Recalculate Product Cost or Product Quantity function, and it will refresh the static balance for the items you recalculate.

*END*
Disclaimer: The information provided here is provided on an as-is basis without warranty of any kind, either expressed or implied, including warranties of merchantability and fitness for a particular purpose. In no events shall A2000 Solutions Pte Ltd or its agents, distributors and suppliers (collectively known as A2000) be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if A2000 have been advised of the possibility of such damages. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. All third party trademarks are the property of their respective owners.