In this section, please take note that the GL Account, Batch, Debtor and Creditor Maintenance has already been maintained.
This section only shows user how to create a product with foumula and apply during purchase and sales invoices. Million allow user to set quantity formula calculation and price formula calculation. Please note that system only allow user to maintain 1 general formula and all products shall apply the same formula. User only need enable the formula option in product maintenance. Once a product is being activated with the formula, system apply formula calculation accordingly whichever user select the product during Sales and Purchase invoices.
Below are the overall contents for this topic:
Step 1: Maintain formula in General Setup
Step 2: Apply formula in Product Maintenance
Step 3: Apply formula in Sales/Purchases Invoice
Step 4: View Stock Report
Step 1: Maintain formula in General Setup
Example: User need to enter 3 variable into formula in order to calculate quantity. As for pricing, user set the condition if quantity is more than 300, the selling price 1 is entitled for 10% discount else if quantity is less than 300, system show original price 1 without any discount.
Table 1: Maintain input format
Table 2: Maintain formula setting
1. Go to System and select General Setup
2. Click Stock Tab
3. Make sure default quantity input format is 999,999.999
4. Click on Formula button
5. Enter input format based on the Table 1
6. Set the formula according to Table 2
7. Click on Save button
Step 2: Apply formula in Product Maintenance
Table 3: Create a product with formula
1. Go to Stock and select Product
2. Click on Add button
3. Enter product information based on the Table 3
4. Ensure that all 9 Control Accounts are filled
5. Mark the check box for Use Quantity Formula and Use Price Formula
6. Click on Settings
7. In Formula Setting, ensure the formula is entered
8. Click on Save button to save and close Formula Setting screen
9. Click on Save button to save the product
Step 3: Apply formula in Sales/Purchases Invoice
Table 4: Select product and enter quantity accordingly
1. Go to Sales and select Invoice
2. Click on Add button
3. In Header, select a customer code
4. Click on Body button
5. Select product code and enter quantity details accordingly to Table 4
6. For PROD-01, click on the arrow down button of Quantity
7. Enter the Qty#1, Qty#2, Qty#3 based on Table 4
8. Click on OK button
9. Place cursor on Price and ensure the figure in Gross Amount reflect the latest amount
10. Click on Save Product
11. Continue to select PROD-02 and enter quantity accordingly
12. Click on the arrow down button of Price
13. Make sure system display calculated price correctly
14. Click on OK button
15. Place cursor on Price and press ENTER ensure the figure in Gross Amount reflect the latest amount
16. Click on Save Product
17. Continue to select PROD-03
18. Click on the arrow down button of Quantity
19. Enter the Qty#1, Qty#2, Qty#3 based on Table 4
20. Click on OK button
21. Click on the arrow down button of Price
22. Make sure system display calculated price correctly
23. Click on OK button
24. Place cursor on Price and press ENTER ensure the figure in Gross Amount reflect the latest amount.
25. Click on Save Product
26. Click in Save button
Step 4: View Stock Report
1. Go to Stock and select Stock Reports
2. Select the Stock Balance
3. Click on OK button
4. Select From Product To Product
5. Click on Print then Preview
The outcome of the report is as follows:
