Formation of route sheets. Logistics. Distribution of routes How to enter data into a 1s route sheet
A waybill is a document on the basis of which the costs of fuels and lubricants (fuel and lubricants) are taken into account. The printed form (form according to OKUD No. 0345001) is not mandatory for all organizations, except for transport companies. In typical 1C 8.3 configurations, there is no waybill printed form (it can be added as an external one), but several methods are implemented:
- According to advance reports
- By coupons
- By fuel cards
Consider step by step instructions and some features of each of them.
The accounting scheme looks like this:
- Issuance of cash to an accountant
- Preparing an advance report
- Return of cash to the cashier
- Write-off of expenses for fuel and lubricants on fuel cards
Figure 1 shows an advance report, which reflects several operations at once: a report on the advance payment issued, posting of gasoline to the warehouse, data on the invoice (if any).
In Figure 2, you can see the postings of the document. In order for accounting accounts for the nomenclature "Gasoline AI-92" to be filled in automatically, it is necessary to add a line for the group "Petroleum and lubricants" in the information register "" (see Fig. 3)
The printed form of the waybill can be connected as an external report or processing to the "Additional reports and processing" directory (see Fig. 4). The report itself will have to be ordered from specialists or purchased at Infostart.
The return of money according to the advance report (in our example it is 8 rubles) is issued by the document "", which is filled in automatically in the "Enter based on" mode from the document "".
Write-off of fuel and lubricants on fuel cards
Unlike coupons, fuel cards are not recorded as, but as strict reporting forms on off-balance account 006.
In general, the accounting scheme consists of the following items:
- Posting a fuel card
- Posting of gasoline received on a fuel card
- Writing off costs.
The crediting of the cost of a fuel card can be registered as a service receipt - see Fig. 11 and Fig. 12. And the card itself should be taken into account on account 006 by a manual operation (Fig. 13)
The receipt of fuel is documented by the document "" (see Fig. 14, Fig. 15).
According to production orders, route sheets are formed, according to which production is dispatched at the local level. Formation of route sheets is not available if the schedule is not calculated for the order:
And if the schedule is calculated, then route sheets become possible to form:
Dispatching of route sheets created in subdivisions with operational management is carried out in the workplace - Production scheduling (MES):
Dispatching of route sheets created in subdivisions with the production management method - BBW / BBW - is carried out in the workplace Production scheduling (BBS):
At the same time, in the case of BBW, in addition to dispatching route sheets, dispatching of work centers is also available:
Question 11.7 of exam 1C: Professional in ERP Enterprise Management 2.0. Route sheets are created based on:
- Generated production schedule
- Scheduled production
- During the execution of the production schedule
Checked. The correct answer is the first one, see the analysis above.
Question 11.39 of exam 1C: Professional in ERP Enterprise Management 2.0. The "Production scheduling" workplace allows you to dispatch route sheets and work centers of departments for which the following methodology is used:
- Operational planning
- Options 1 or 2
- Options 1 or 2 or 3
Checked. The correct answer is the fourth. In the case of operational planning, the work center is dispatched from a separate workplace.
Question 11.40 of exam 1C: Professional in ERP Enterprise Management 2.0. When using the operational planning methodology, route sheets are formed from:
- production order
- Workplace "Scheduling of production"
- Workplace "Procedural planning"
- Options 1 or 2
- Options 1 or 3
- Options 1 or 2 or 3
Checked. The correct answer is the fourth. From production order route sheet can be formed:
From operational planning - in any case. ( Moment - in release 2.1, the workplace is called not Operational Planning, but Production Scheduling (MES))
Question 11.46 of exam 1C: Professional in ERP Enterprise Management 2.0. After generating route sheets (status "Created"), you can work with them in the workplace:
- Production scheduling
- Execution of route sheets
- Route sheets of production
- Options 1 and 3
- Options 1 and 2 and 3
Checked. The correct answer is the fourth. You can work with them in the Workplace Dispatching route sheets.
Many businesses have a problem operational delivery planning products. Forming machines, optimizing shipping costs.
I propose a solution that is quite suitable for small organizations.
For example, let's take the configuration "Integrated Automation edition 1.1".
Initial data and tasks
1. We have some quantity overhead(document "Sales of goods and services"), which must be delivered to customers. Clients are located in various parts of the city.
2. We have some quantity in stock cars with the given parameters - carrying capacity, volume. Cars can be both own and hired.
Tasks to be solved:
1. Distribute invoices available vehicles in such a way as to minimize the distance traveled by each vehicle.
3. Create a mechanism fast printing accompanying and other documents.
4. Under all other conditions, add to the configuration minimum change.
Logistic solution and an example of its implementation.
The main idea is to break the entire delivery area into separate areas and assign a district to each counterparty or outlet.
How to organize the districts is the business of the logistician. For example, you can simply divide the map into sectors - Center, Zavolzhsky district, Zheleznodorozhny district, etc. You can organize districts radially, by sectors. You can take into account the load on specific areas and create "sub-districts" (for example, Center-North, Center-Lenin, etc.). In any case, this is a matter of logistics.
For this purpose, we are creating a new directory "Regions".
Directory of areas I also implemented backlighting so that in the future the logistician could more clearly see the areas by color.
To account for cars, we create directory "Cars".
We add details, except for the standard ones:
Driver;
Forwarder;
state number;
load capacity;
Capacity;
DistrictDefault
Color coding
Directory of cars Document "Route sheet"
We create a new document that will contain information about each specific flight: car, driver, freight forwarder, area, as well as information about the documents and goods that the driver is carrying.
route sheet document Also, this document contains information about the cost of the flight, it is also possible to implement the calculation of the cost according to some criteria - articles, for example, the number of points (waybills), etc.
Route Sheet Print Console
A route list can include dozens of documents and delivery points. For each point, you need to print various documents - TORG-12, invoices, waybills, registers of certificates, and you never know what printing forms are used in the organization. You also need to print out the freight forwarder's actual itinerary, according to which he will carry the goods.
AT normal mode the operator needs to go into each document, print the necessary forms.
When using the Print Console, you can pre-set which documents you want to print. Once configured, documents can be printed in batches.
That is, the operator, by pressing one button, prints all the configured documents. The operator only needs to stamp the papers with seals, sign and give the entire pack to the forwarding driver.
Print Console 
Setting up the print console In our case, it is possible to independently create the necessary external printing forms and upload them for processing. The mechanism is fully implemented using external printing forms.
Formation of routes
A special external processing has been created, which allows the logistician to analyze what kind of cargo (waybills) needs to be delivered, where to deliver it and by what means to deliver it.
This processing allows the logistician to evaluate the weight, the quantity of goods, the volume that will be loaded into the selected vehicles, and will also help distribute sales among the vehicles.
The result of the processing is the formation of documents "Route sheet".
Formation of routes In this solution, any adjustments at the request of the customer are possible.
If you have any questions or are interested this decision- write.
Question 11.42 - Source of information on materials in the route sheet
AT Question 11.42 it is necessary to indicate the source of information on materials in the route sheet. Data on the materials and semi-finished products used are determined when forming the route sheet:
- according to the resource specification
- according to the route map specified in the resource specification
- according to the route map, specified line order specifications
- Variant combinations
To answer the question, do the following:
1. Let's create a route map.
2. Let's create a resource specification, in which we indicate the route map.
3. Let's create a production order.
4. Let's calculate the production schedule.
5. Let's create a route sheet and analyze what sources of information are involved in determining materials and semi-finished products.
1. Create a route map by copying the product's route map from the demo database SI1000_K_Production 1 top tabletop (Production and repairs - Regulatory and reference information - Route maps). We are changing the division and types of work centers.
Bookmark Materials and works we leave information about the need for the material Sheet 6 St3ps5 .
We save the route map, set the status Active .
2. Create a resource specification of the product (Production and repairs - Reference information - Resource specifications).
Bookmark Manufacturing process specifications, we indicate the unit and the route map we created.
We fill in the specification and types of work centers with the data of the route map.
We make some changes:
- Specify the working hours of the types of work centers
-Plasma cutting machines– 0.2 h,
- Drilling and milling machines– 0.1 h. - Bookmark Materials and works we indicate a different material (after all, it is important for us to understand from which source the information will get into the route map, so the information should be different).
Set specification status Active.
3. Create a production order ( Production and repairs - Scheduling - Orders for production).
In the document, we fix the need for the production of a semi-finished product SI1000.002.000 Top tabletop in quantity 1 PC according to resource specification SI1000.002.000_C (11.42).
Push button Change order position go to the order line specification. Here on the bookmark Materials and works required material Sheet 3 St3sp5 in quantity 30 kg (from the resource specification).
We change it to Sheet 2.5 St3ps5 in quantity 25 kg.
Make sure that the order line specification contains information about the route map. Go to bookmark Manufacturing process.
Push button Edit Stage
As you can see, the route map SI1000_K_Production 1 top tabletop (11.42) indicated here.
We save information. Set the status of a production order To production and we carry out the document.
4. Calculate the production schedule.
Opening a workplace Production and repairs - Formation of the schedule - Production schedule).
We find our order. Double click on the field State we start the process of calculating the production schedule.
After the calculation is completed, we save the information. Open the production schedule diagnostic form.
As you can see, at this stage, information about the requirements for materials and semi-finished products is determined according to the specifications of the production order line.
5. Create a route sheet. Let us analyze what sources of information are involved in the determination of materials and semi-finished products.
Go to RM Production scheduling (Production and repairs - Schedule fulfillment - Production scheduling).
Open it and go to bookmark Materials and works.
Here it is - the moment of truth! The route sheet has received information about the requirements for materials recorded in the route map specified in the specification of the order line.
Now let's return to the production order, open the specification of the order line, remove the information about the route map on the tab Manufacturing process.
Push button Edit Stage open the production stage form.
We save information.
Make sure the bookmark Materials and works required material Sheet 2.5 St3ps5.
We save information. Let's translate the document.
Let's go to the workplace Production Schedule Dispatch.
We are re-calculating the production schedule. Open the production schedule diagnostic form.
As before, here is information about the requirement for the material, which is specified in the specification of the order line.
Go to RM Production scheduling and create an itinerary. Open it and go to bookmark Materials and works.
As you can see, now, when the route map is not specified in the specification of the production order line, information from the specification of the production order line gets into the route sheet.
Based on the results of our experiment, we can conclude the following:
When forming the route sheet, the materials and semi-finished products used are determined by:
- from the production order line specification
- according to the route map specified in the order specification line.
Background:
Launched a trading system in a large food distributor. Initially, the project started in a branch in St. Petersburg. And after a successful launch, it was already planned to launch in Moscow. And just before the launch, the logistician informed me that the proposed routing option did not suit him at all, it was inconvenient to work with the system. At that time, in St. Petersburg, it was necessary to route about 200 points and 15 cars per day, in Moscow - 500 points and 40 cars. The most interesting thing is that the idea of using maps was immediately rejected by the logistician. He proposed his own version, especially since he used to work in a similar way, but in a different program (not 1C). I had to create processing for visual routing (and it turned out better than in the old logistic program). And now processing is used in 4 countries in our branches: Russia, Ukraine, Kazakhstan and Belarus.
Tested on release:
1C 7.7.27, 1C++ 2.0.3.7, Windows XP (on Windows 7 there are problems with line coloring in the 1C++ library).
What processing does:
Allows you to divide shipping documents into non-routed and routed, as well as group documents by sectors and delivery points. The result of the processing work is the created documents "Route sheet" with the completed tabular part from the documents of shipment and receipts.
Who benefits from the treatment:
A programmer who needs a local cargo delivery routing function in 1C 7.7 and if he is ready to make changes to the configuration.
Details:
The configuration and processing will have to be changed. Processing works with configuration objects:
- Directory "Delivery Points"- to indicate the points of delivery of the goods and I do not like the idea of using Counterparties for this function (those who worked in trading companies know that one legal entity can have several outlets. For example, the largest retail chain in Russia has more than 3 thousand points) .
- Directory "Sectors of delivery"- allows you to group delivery points into sectors to simplify routing (now in my company Moscow and the region are divided into 200 sectors).
- Directory " Delivery blocks" - allows you to group one or more points into a block to issue a task to storekeepers to collect cargo. Each block means a separate task. In my case, the directory was created to synchronize with the WMS "Warehouse Management".
- Document "Itinerary sheet"- stores information about the car, the driver and the list of shipping documents (separate route sheets are created every day, there can be several route sheets for one car if the driver performs several trips).
- Directory "Carriers"- to store information about motor transport organizations
- Directory "Cars"- information about cars, subordinated to Carriers
- Directory "Drivers"- information about drivers, subordinated to Carriers
- In documents "Realization", "Return from buyer", "Receipt from the buyer", "Decommission" added props " Driver".
How processing works:
The logistician selects the day of routing and displays a list of documents (Implementation, Return, etc.) in the table of non-routed documents. Documents are grouped by dot so that multiple dot documents appear on the same line. You can view the list of documents by point by clicking on the triangle icon. The transfer between the tables of unrouted and routed claims is done by double-clicking the mouse or pressing Enter.
To make it convenient to work with a large number of points, the logistician needs to install a monitor with a diagonal of 20 inches or more.
