1b.app
Link copied -

Grouping of identical goods in documents

Answers:

Сусяк Ігор
Integrator.com.ua
Personal license
Igor, good day

it would be good to understand the business requirement for what exactly you need it for.

Templates are made in order to logically output data from the process. I assume that we are talking about the same products in different rows in the same product table, which can be combined by ID.

"Combine order products with the same product codes" action may be suitable for this purpose"

Accordingly, after merging in the process, the box will display the actual result in the template.
02.03.2023, 15:25
Original comment available on version: ua



Dydyk Ihor wrote:

As a document template, you can group the same products according to the additional product field of the process



Good afternoon. Now you can only group by category using variables:

row:categorytree_categorymain_name

row:categorytree_product_*

Those. in the document you will get something like this structure: . If you need the same thing, only that instead of a category there is an additional. process field - can be modified to display such a tree, it will take 2 hours of refinement.

If this option is not suitable, then most likely you want to show grouped products in one line and summarize the values of their fields, as far as I know, this cannot be done in the document now, but you can estimate the cost of revision. Describe in more detail, I can evaluate.
02.03.2023, 17:17
Original comment available on version: ru

Dydyk Ihor
ПП
Leave a message in this thread and the user's contacts will be shown to you
The essence of the problem:

There are three types of goods in stock: 2 pcs with VAT 7%, 2 pcs with VAT 20% and 5 pcs with VAT 20%

It is necessary to issue an invoice (invoice) to the client with two items with VAT 7% and VAT 20%.

Accordingly, removing these three positions from the composition.
02.03.2023, 20:13
Original comment available on version: ua

1. Why are the second and third positions not combined into one?
2. Why is it necessary to write out exactly 2 positions on the invoice and not 3?
3. Is it important for you that there are 2 products in the invoice and 3 in the order? Or you can combine items in the order with the same VAT in one line
02.03.2023, 20:50
Original comment available on version: ru

Dydyk Ihor
ПП

.dev
OneBox production wrote:
1. Why are the second and third positions not combined into one?
2. Why do you need to write exactly 2 items in the invoice, and not 3?
3. Is it important for you that there are 2 products in the invoice and 3 in the order? Or you can combine items on the order with the same VAT in one line

---------------------
1. Added goods according to arrival, taking into account the VAT rate
2. And if there are more positions?
3. When merging, how will delisting from the warehouse take place?
02.03.2023, 21:05
Original comment available on version: ua

1. clear
2. The document will increase proportionally - not very convenient
3. The write-off from the warehouse is not affected by the number of goods in one line, i.e. warehouse operation no difference, 7pcs in one line or 7 lines of 1 piece. All this naturally works only if you have the same values of additional fields associated with the warehouse, serial numbers, etc. But I suspect that you don’t have serial numbers and additional fields with warehouses are either the same or not used at all.
The action that was written to you above "Combine products with the same product codes" will help in your case. What should be done:
1. Copy the ELV value in the additional field (as a result, in the additional field of the process product you will have: 7 in the first product and 20 in the second and third)
2. The next step is to put the merge action and select the additional field in which the VAT rate from point 1 is located (as a result, the first product will remain as it is, and the second and third will be combined into one).
Also in the same action, we can finalize so that you can select the MPE in the drop-down list so that you can not copy it to additional fields (skip the first paragraph), it will take about an hour of refinement.
02.03.2023, 22:35
Original comment available on version: ru

Dydyk Ihor
ПП

Dydyk Ihor wrote:

.dev
OneBox production wrote:
1. Why are the second and third positions not combined into one?
2. Why do you need to write exactly 2 items in the invoice, and not 3?
3. Is it important for you that there are 2 products in the invoice and 3 in the order? Or you can combine items on the order with the same VAT in one line

---------------------
1. Added goods according to arrival, taking into account the VAT rate
2. And if there are more positions?
3. When merging, how will delisting from the warehouse take place?

The best option, in my opinion, is to go through the "Merge order products with the same product codes" action, but it would be nice to also have the opposite action with restoring the number of merged products.
28.03.2023, 10:10
Original comment available on version: ua

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment