Stock Balance
This function will export stock levels for every Item in the system or in a specified Location. If you import the resulting file into a new database at the start of a financial year, a new Goods Receipt will be created to contain the stock levels.
- No. of first record
- When you import the exported file into a new database, a new Goods Receipt will be created, containing the stock levels. Specify here the Goods Receipt Number that you want to be used in the new Goods Receipt.
- Location
- Paste Special
Locations setting, Stock module
- Range Reporting Alpha
- If you need to export stock levels from a specific Location, specify that Location here. If you specify a range of Locations, create an export file and import it to a new database, separate Goods Receipts will be created in the new database for each Location. However, if you leave this field empty, a single Goods Receipt will be created in the new database, containing stock levels for every Location added together.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- If you need to export stock levels of Items belonging to a specific Item Group, specify that Item Group here.
- Balance Date
- Paste Special
Choose date
- Enter a date to export stock levels as they were on that date. If you leave the field blank, the current date will be used.
- G. Receipt's Date
- Paste Special
Choose date
- Enter the date that you want to be used in the Goods Receipts in the new database.