Tips for using inventory commodity purchase, sales and inventory details list
What is the detailed account of inventory goods purchase, sale and inventory?
The purchase, sale and inventory detailed account is the warehouse custody account, which is registered and kept by the enterprise's warehouse management personnel. It is equivalent to the inventory running account. This is used to verify the actual inventory quantity of the enterprise, and it must be equal to the actual inventory and the enterprise's inventory commodity detailed account.
Registration requires one registration for each product. The warehouse custody account does not need to reflect the amount of the product, so a quantitative account page can be used (but it is difficult to buy this kind of account page in the market now).
Detailed list of inventory goods purchase, sale and inventoryHow to fill it out?
1. Including functional modules such as transfer, inventory, scrapping, losses and overflows, gifts, assembly/disassembly, and cost price adjustment orders, to realize the management of common warehouse affairs, and to monitor inventory details and the specific circulation of goods.
2. Generate profit and loss quantities and amounts based on historical data and existing data in inventory, and support the automatic generation of corresponding loss reports.
3. The entry and exit of goods must be audited to improve the operational security of the system and data.
4. Realize automatic calculation of changes in inventory quantity and amount, and reflect them in "Inventory Summary", "Inventory Detailed List", and "Inbound and Outbound Summary".
5. Supports the setting of upper and lower limits of product inventory, and automatically alarms products that are out of stock or higher than the upper limit of inventory.
6. The data can be traced from the inventory summary table to the inventory detail table, and then to each inbound and outbound document. This makes it easier to trace the origin of the data.
2: Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, and select "First Row". After the settings are completed, open the name box in the upper left corner, and click the corresponding list to jump to the specified column.
3: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
4: Fill every other row with color to make the table more cool
Ctrl + T
First, use the shortcut keys Ctrl+shift+right arrow+down arrow to select all the table, and then hold down Ctrl + T to achieve it.
The Ctrl + T method is very fast and can quickly fill the table with color, but it cannot achieve self-selected colors.
How to fill in the color of your choice
First, use the shortcut keys Ctrl+shift+right arrow+down arrow to select all the tables. Then select Conditional Formatting - New Rule in the Start menu
Choose to use a formula to determine the cells to be formatted, and then enter =MOD(ROW(),2)=0 in the format *0 means even-numbered rows are filled, 1 means odd-numbered rows are filled
Then select the Format button, open the Fill tab, and choose your favorite color to fill.
Inventory goods purchase, sale and inventory details listIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the purchase, sale and inventory detailed list of inventory goods, please download it quickly. also,Fiscal Budget Credit Rating Application Assessment Form,Community elevator maintenance scheduleIt is also a good form template. You are welcome to click to download and experience it.
it works
it works
it works