After we create the grouped item in Doc Item Maintenance applet, user can started to configure it to be updated to the marketplace (Lazada,Shopee).
User need to click on the item in the item listing and the edit item page will be shown.
3. In the main tab , kindly update the GL code (refer guide Chart of Account applet) and currency as it is mandatory field for each item. Click Save.
...
25. The formula for stock balance will be as follow:
3.1.3 System stock balance calculation
The formula will be as follow ;
AUTO (buffer stock)
Stock Availability = Total stock balance from multi-location - buffer stock - sale order (depend on configuration)
AUTO (balance percentage)
Stock Availability = (Total stock balance from multi-location - sale order (depend on configuration)) x balance percentage
MANUAL
Stock Availability = Manual stock balance - sale order (depend on configuration)
Example calculation as below ;
Item A | Item B | |||
Stock balance | Sale Order | Stock balance | Sale Order | |
Location A | 5 | 1 | 5 | 2 |
Location B | 4 | 1 | 8 | 0 |
Location C | 6 | 0 | 2 | 1 |
Total | 15 | 2 | 15 | 3 |
Scenario 1
AUTO with buffer stock ; 3 units and sale order ; ACTIVE
Stock Availability :
Item A = 15 stocks -3 buffer -2 orders= 10 units
Item B = 15 stocks -3 buffer -3 orders = 9 units
Scenario 2
AUTO with stock balance percentage ; 50% and sale order ; ACTIVE
Stock Availability :
Item A = (15 stocks - 2 orders) x 50% = 6 units
Item A = (15 stocks - 3 orders) x 50% = 6 units
Scenario 3
MANUAL with stock balance ; 7 units and sale order ; ACTIVE
Stock Availability :
Item A = 7 stocks - 2 orders = 5 units
Item A = 7 stocks - 3 orders = 4 units