Find Solutions to Common Issues Related to inventory-reports - stock status
To check the stock status in BUSY, follow these steps:
Step 1: Go to display section then click on stock status.
Step 2: Choose closing stock alphabetical option then select balance only.
Step 3: Choose all material center then all item master.
Step 4: Specify the date range then enable show value of items and open the report.
To resolve the negative stock issue in BUSY, you can adjust stock by post stock journal voucher in BUSY. You can follow these steps to post stock journal voucher:
Step 1: Go to transaction section then click on stock journal voucher.
Step 2: Click on add tab then mention the voucher series, date and material center in from and to tab.
Step 3: Now, mention item in item generate window to generate stock of such item and in item consume to consume stock then save the voucher.
If all your stock is showing as a minus, it means that you have sold more than available quantity of items. To bring it in plus, you need to purchase more stock. You can also generate stock by using these steps:
Step 1: Open your company then go to transactions menu.
Step 2: Select stock journal and click on add.
Step 3: Enter all the necessary details such as date, material centre and your items with required quantity in item generated section then save.
Step 4: You can also use the physical stock voucher and click on add.
Step 5: Enter all the necessary details such as vch no. , date, material centre, etc then click on down arrow.
Step 6: Click on load items and enter the required quantity in physical quantity column to generate stock then save.
If the stock display negative value, check the below possible reasons:
1.If you have only entered sales transactions and not the purchase records, it can result in a negative stock. Make sure to input both sales and purchase transactions to maintain accurate stock levels.
2.When updating transactions, select the specific material center appropriately. While checking the stock report, ensure you are viewing the stock of the relevant material center which is selected in transactions.
If the stock display negative value in BUSY, you can either post physical stock voucher or stock journal voucher in order to made stock adjustment. To create stock journal or physical stock voucher, follow these steps:
Step 1: Go to transaction then click on stock journal or physical stock
Step 2: Click on add and create the voucher with required item details.
To configure inventory management in BUSY you can follow the steps
1 Go to inventory feature and tag stock account with material centre
2 Enable multi godown inventory in inventory feature
3 while create item master set material centre wise critical level
4 enter opening stock if any as per material centre wise
5 enter voucher entries as per requirements
6 to check the stock status go to display menu click on stock status
and click on balance only or detailed as per material centre wise
7 to check the minimum maximum level or reorder leven with its actual stock and deficiency , go to display manu and click on inventory summary then click on item critical level
by following these steps you will be able to track your Inventory and stock levels
The pricing valuation be determined for an item in stock.In BUSY , multiple valuation methods are available for this purpose.These methods include FIFO, LIFO, Last Purchase, Last Quantity In, Last Sale, Self Evaluation, Weighted Average, Average Price (Quantity In), Average Price (Invoice), and more. You can select the valuation as per the requirement.Please Follow the Below Steps :
Step 1: Administration
Step 2: Configuration
Step 3: Features and options
Step 4: Inventory tab
Step 5: Select method for Stock Val. Method or can search the option throygh F3 shortcut key.
We have another option for maintain stock valuation according to the each item in Item Master.
Step 1: Administration
Step 2: Configuration
Step 3: Features and options
Step 4: Inventory tab
Step 5: Enable the Seperate Stock Valution Method for Items.
Step 6: Open the Item Master and Select the Stock Valuation Method.
By default you check stock Report with Item name or Item alias.
For check stock Report with both Item name and Item alias follow these steps:
step 1: Go in display then go in stock status
step 2: Go in closing stock alphabetical click on balance only
step 3: Click on all item and open Report with item name
step 4: Click on custom columns and mention format name and press enter
step 5: Click on add new column and Type Item alias in heading
step 6: Mention position and take text in data type
step 7: Go in data field and take Item master in category
step 8: Mention F1 in item name column and click on field
step 9: Choose field Item alias and save format
step10: Reopen list in new format
If some items are not reflecting in the ledger even though they are purchased in BUSY, you should
check your item master and check then option of dont maintain stock balance that should be disable
if it is enable then item will not be show in stock status. To check the status of item you need to follow steps:
Step 1: Go to the Administration and then click on Masters.
Step 2: Now select the Item option and click on Modify option.
Step 3: Now select the item that is not showing in stock status and check the option of Dont maintain stock Balance that should be disable.
Step 4: If Dont maintain stock balance is enable then disable it by specify N and save the master.
If stock status is not showing correct balance then you need to follow below steps:
Step 1: Take a backup of your data then open your company in BUSY
Step 2: Go to house keeping menu then run update master balances
Step 3: Now press ok button then run the process
Step 4: After completion of this process check the stock status report
Step 5: If same issue persist make sure you have selected correct date range for the report
Step 6: Make sure you have selected correct material centre along with other details while opening the report
Step 7: If still same issue persist check the report in short range and try to found the date from it is start showing incorrect balance and solve it
If stock value not calculated as per weighted average method then you need to check the stock valuation method selected in company.
To calculate your stock value on the basis of weighted average valuation method in BUSY, follow these steps:
Step 1: Open your company then go to administration menu then click on configuration tab.
Step 2: Select features and options then click on inventory tab.
Step 3: On right side first option is stock valution method if there already select weighted average then no need to change.
Step 4: If any other method is selected then choose the weighted average from the dropdown menu then save.
Step 5: After that go to housekeeping menu then run update master balance process and check the stock report.
If you want to track inventory then you can monitor your inventory and stock levels by using various report options available under the Display menu. You can view the stock status report, inventory books, and inventory summaries for any item, group, or category.
To create Purchase Order in BUSY, you can follow these steps:
Step 1: Go to Administration and click on Configuration.
Step 2: Select Features / Options and click on Inventory tab.
Step 3: Here, you will find an option called "Enable Order Processingclick on the check box to turn it on and save.
Step 4: Now, go to the Transaction menu and select Purchase Order.
Step 5: Click on Add and fill all the required details such as Date, Voucher no. Items, etc.