Stone inventory management, use EXCEL to make an account, there must be details, there is also a sum

Jianyi can use the purchase, sale and inventory management software It is a set of purchases, sales, inventory, financial management in one, usually only need to simply enter the warehousing list of goods, the outbound order can automatically count the number of real-time inventory, cost, inventory amount, the receivables and payables of customers are also automatically counted according to the documents, the monthly reconciliation is clear at a glance, how much customers owe, how much they owe the best business are clear at a glance, directly in the summary table can be seen, scrape a variety of detailed reports, summary reports are automatic statistics of the systemIt is very convenient to import and export customer information, product information, employee files, etc. from excel.

Settle the customer's receivables by order, which can ensure that there will be no missed orders and no collection.

You can set whether each column of ** is displayed or not.

You can see the stock quantity of each item at any time when you make or put it in stock.

It can be assigned to achieve perfect operation authority management, division of labor and collaborative operation.

You can design the format of the document by yourself, save the document information, set up automatic backup, and restore data without fear of loss.

Genuine users use it forever, free upgrades, no restrictions.

It's a bit vague, so I can't answer it.

I hope to help you Thank you o( o

Send a set of templates for your reference. Please check.

I've sent a copy, you take a look at it first, don't understand it and then q me.

If your company pays you, we can make one for you as required.

What products are sold, what are the characteristics of the products, and what fields are needed in **?

I can be a substitute, or I can teach, and I can also learn. Interested in learning can hi me.

Stone slabs, especially imported stone slabs, need a case, management parameters are many, not a very large stone manufacturers, will keep inventory for a long time tens of thousands, hundreds of thousands of square meters, plus cut or sold (you can't delete it), just inventory account, it is very large, excel is difficult to do.

Search: Stone engineering processing management and slab purchase, sale and inventory management system.

Mailbox has been sent, welcome to customize!

You can try WPS, **do it yourself.**

I rarely use Excel, I always use software. Kingdee free software - "Wisdom Notes", I am using it, recommend one.

Warehouse management, mainly is warehousing, outbound, return, unit price, quantity, amount indication, this table is very simple.

Date, Summary, Incoming, Outgoing, Balance.

I think it's better for you to do it, you know the name, type the word in, the number in the unit price is in the format cell, the amount is indicated in the format cell, and the date is filled horizontally, and it's okay.

Hello, give me an email address or QQ or something.

I can send it to you.

The landlord uses excel to do what ERP does, and the spirit is commendable, but you have to take your time, I believe you will be able to become a master.

It is best to have a set of purchase, sale and inventory software, and Shengcai Bao is more suitable for the sales industry.

The myexcel platform is completely achievable.

I have a clothing purchase, sale and inventory management, if I want an email?

Only then can the warehousing management software be a professional warehousing and warehousing registration management software, instead of the traditional excel entry method.

Just simply enter the warehousing list, and the outbound order can automatically count the inventory quantity and the detailed report of the outbound flushing and inbound.

Multiple can be assigned to achieve perfect operation authority management.

You can set whether or not each column of ** is displayed or displayed.

It's very simple, otherwise, you tell me an email address, I'll make one for you, I want to get on a **, I can't get on.

I don't know if the landlord wants to make such a ** by himself. If you do it yourself, the technical requirements are relatively high. Generally speaking, the purchase, sale and inventory tool contains the following basic functions, procurement warehousing, sales outbound, inventory (automatically calculated according to inbound and outbound warehousing), cost (moving average method accounting), profit (sales amount minus cost price), statistics (** monthly report), query (inbound and outbound) resume.

Other extensions such as product name, specification, weight, volume, unit, etc. are also available. The main difficulty is in the automatic inventory counting. Depending on the industry, the specific items may vary slightly.

The general practice is to use pivot tables, but if the amount of data is large, the speed will be severely affected. It is better to use VBA, and the speed is not affected. If you do it yourself, you don't have considerable programming knowledge, it is estimated that you can't do it, I suggest you go to Beijing Futongville Technology ******, which has Excel tools developed by VBA, many versions, of course, there are also free**.

According to your business, according to the function you need to make is the right management for your use. I provide production services, if you need to know, you can hi or q me, click on my username to see my contact information.

It has been sent to your mailbox, I don't know if it is applicable.