"Type of synthesis" does not work well

[Former Member]

Good morning

I have a problem when i try to "aggregate" the lines of one invoice thanks to the "type (kind) of synthesis". To let you understand my problem, i did 2 screenshoots.

Image 1 --> Starting point: I have 3 lines of the same item.

Image 2 --> When i click of "Item synthesis", the system does not aggregate all the lines into one, but the sistem gives me 2 lines!

The problem is that at the end of a month, when i get my invoice from the "transport documents", i found hundreds of lines repeated! My invoice, that should be composed of 80 - 100 lines abut, are composed of 900 - 1000 lines, and they can not be readen easily from our costumers!

How can i solve the problem?

How can i have 1 only line on my "monthly invoice" for each item bought during the month?

Consider that i have never changed prices (if i changed prioces it is obvious i need to have different lines...), and i tried to put the same "decimal number" in "Administration --> system initialization --> general parameterization (as i show in image 3) !

Please hel me.

[Former Member · Accepted solution]

The factor is very important one to distinguish the item. If they are not the same, the lines can't be grouped. Please check your Packaging option. Factors is not changed on their own.

[kothandaraman_nagarajan]

Hi Daniele,

Please raise ticket to SAP and share the outcome with us.

Thanks & Regards,

Nagarajan

[Former Member]

Hello Rajan. Thanks again for your support.

At the moment I don't know how to raise a ticket... I've never done it. I use SAP from few times.

Can you please help me.

How can I rise a ticket? Can you link me "the place" where I can raise a ticket please?

If I manager to raise the ticket searching here how to do, i will immediately post that i raised the ticket. If you don't find my confirm about it, please send me the links.

Thanks a lot

Daniele

[Former Member]

I have a problem with the authorizazion (permission).

At first: I'm a costumer and i do not work for SAP, but obviously for a society that decided to use SAP B1.

I tryed to go to "Help & Support" --> "Report a product error" ( i find this link serching on the web and my passwords seems to run for entering that web pages).

Fact is that it seems i'm the "SuperAdiministrator" ... so I think i have the power to do everything, and to raise a ticket, too!.

Fact is that I have not the Authorization ... and the system tell me to ask for the authorization to the Superadministration, that is me!

Now ... i thought, ok! I go to Data Administration --> User Administration ... and fact is that i can not understand how to give myself the authorization to raise a ticket without the risk of jeopardizing something.

Can someone tell me how I can authorizate myaelf to raise a ticket please?

Thanks

[kothandaraman_nagarajan]

Hi,

Please refer below thread:

http://scn.sap.com/message/7826541#7826541

Hope helpful.

[Former Member]

In this case, too, my access is denied .

Thanks for your support, even if i can't raise ticket at the moment.

Fortunately the SAP Partners that helped me to introduce SAP B1  will help me to raise the ticket. They will do it for me.

I will update the situation here, hoping that the problem of the synthesis will be solved.

[Former Member]

Only SAP Partner can raise a ticket. Customer has to go through the partner.

Beside, this issue is not the bug that you may raise a ticket through partner.

[Former Member]

Ah, ok. I understand. I hope we manage to have a solution...

About your sentence "Beside, this issue is not the bug that you may raise a ticket through partner." --> Does it mean that to let our partner to raise a ticket is not the right way?

If it is not the right way, what do I have to do, considering that the access to comunicate to SAP through "www.service.sap.com\smb" is denied to me? .

Thanks a lot

[Former Member]

If it is a bug, you can raise ticket by your partner. However, this is not. It is function by design.

[Former Member]

If it is function by designed, it was poorly designed !

I can not work with a system that makes thousands of lines in each summary invoice (monthly - the ones that derives from"everyday Deliveries" ) , when if it had worked correctly, it would have made maximum 50 lines!

I can not think that a sistem that does not manage to sum/group different quantities (because "factor * factor = quantity") is correct!

If this is function by design, where is the function to get decent summary (montly) invoice?

I can not think that who uses SAP B1 can not have "montly invoices" shorter than 50  pages (A4 format) each one !!  ... and we have 50 pages because i managed to tighten up the grill and the printing format, if not we could have 100 pages each invoice ...!!

[Former Member]

Ok, thanks your support.

Now I have understand that what make differet lines is the factor. Fact is that it is wrong. In a invoice I need that "Quantity" is grouped (summed). I need factors while I take orders, but wgen i make an invoice, i need all the "quantities" are summed!

Fact is that "Factor 2 " is the "cell" where we insert the order value, that will be multiplayed for Factor 1. It is obvious that "factor 2" are differents. They are "quantity" that must be "multiplyed" for Factor 1, to get the right quantity that must be ordered and sold. In our market if runs that way (I try to semplify the best):

- One costumer order "3" of item X . It means that he orders 3 "package" of that item, that means 3 x 3,5 kg = 10,5 Kg . So in the line "Factor 2" insered from the employeed while taking the order is  "3" , " Factor 1" is a fixed value for the item, that is 3,5, and the quantity becomes 10,5 . In this way we can order "3" to our supplyer and our costumer must have 10,5 in its invoice. Consider that many "packages are "divided", in the sense that the costumer that ordered 3 package, could not receive 10,5 Kg, but 9 kg for example, or 12 kg for example, so we have to change the quantity on the order or while we create the invoice...

It has not a logical meaning that the system do not "sum / group" lines because they have different factors!!! It is like to say "I don not sum different lines because they have a different quantity!!" because the factor os only a multiplier to get a quantity.

Now, fact is that i need to sum lines, because I can not have thousands of lines each invoice!

Does a solution exist?

I think that "not to sum" different lines because of different factors is a bug (as I said it is the same of "not to sum" different lines because of different quantities!!). In my case it is a heavy bug.

How can I solve the problem, not considering the possibility of deleting the factors, that we are obliged to use?

Thanks for the answers. Please hel me!!

[KennedyT21]

Hi Danele Simeoni ..

If There is no difference between Lines Better you raise a ticked with SAP to find the solution..

They other idea is you can use group by function in th PLD and CR i think which will helpful to you try that

Regards

Kennedy

[Former Member]

Hello T

I have not understand what PLD and CR are.

What are PLD and CR. Please specificated it, because i'm new to SAP.

How can I rise a ticket? Can you link me "the place" where I can raise a ticket please?

If  I manager to raise the ticket searching here how to do, i will  immediately post that i raised the ticket. If you don't find my confirm  about it, please send me the links.

Thanks a lot

Daniele

[Former Member]

Hi,

If you want to have one line for one item monthly, it is easily doable through a simple query.

Thanks,

Gordon

[Former Member]

Yes, it is true and I have already did it, but it is not correct... In this way I put a temporary patch, but I do not solve the problem.

Fact is that in this first month I used SAP B1 I have given our costurmers 45 pages of invoice ... each invoice!  Next to it, I have given a sheet where the result of my query shows the total of quantity and price for each item...

Obviously our costumers and their business consultant needs invoices where apperas the right numbers of lines (about 50 or 70  for example - each line 1 item ) and not 1000 or 2000 lines  like it happen in our invoices with SAP B1.

I would have to create a print of the "Invoice" starting from my query and not starting from the system invoice and it is not correct...

[KennedyT21]

Hi Daniele Simeoni

It not only with Item code and ware house, check with

item number, item description, price,and warehouse. There is no settings for This...

With the Summary Type, SAP Business One gives users the option of summarizing document rows by similar characteristics. The Summary Type field is located in the upper right-hand area of the Contents tab 

This summary function can be used for documents with the Item

document type only, and has two forms:

  By Items

All document rows with the same items are summarized to form a

single document row. However, document rows can be summarized

only if the properties of the item rows are the same. This

applies first and foremost to item number, item description, price,

and warehouse. If all these properties are the same in all item

rows, the individual quantities are totaled, and only a single item

row remains after the summarizing has taken place.

You may check the solution part of this following sap note:

1363163  - Grouping by item in marketing documents

Version   3   Validity: 11.11.2010 - active Language   English

Content:      Summary    |    Header Data    |    Validity 

Symptom

When choosing 'Summary By Items' in marketing documents, some item codes are still displayed in more than 1 row.

 

Cause

Consulting

 

Solution

The 'Summary' functionality in item type marketing documents offers  summarizing the data in the document rows by 'Items'. It is a common  misconception that all rows containing a particular item code would always be summarised into 1 row.

System logic is that the display in a document must be consistent. Rows  having for example different tax codes and/or different unit prices or  are sourced from different warehouses cannot be summarised, even if the item code is the same.
Thus, if more than 1 row is displayed for an item although 'Summary Type  - By Item' is selected, there must be a difference in the row data.

 

Other terms

Collect, collate, summarize, put together, row, line, document, sales,  purchasing, order, delivery, invoice, display, show, window, GUI, illustrate, SAP Business One

   
       

Header Data

Released On	30.11.2010 12:11:05
Release Status	Released for Customer
Component	SBO-SD Sales - A/R
Other Components	SBO-SH-GEN General Functions
Priority	Recommendations/additional info
Category	Consulting

  
      

Validity

SAP BUSINESS ONE

8.8

    

I think it is a current sap b1 system definition.

Hope Helpful

Regards

Kennedy

[Former Member]

Please read the answer I did to the first answer (the one to Naga Rajan) ...

After having read my answer: Where is the difference between the first row and the second row? How can I manage to "sum"- "group" by item them? Please help me, I can not have invoices at the end of the mont with 40 pages of invoice!

[kothandaraman_nagarajan]

Hi Daniele,

Please check item 1- price, warehouse, tax are same with item 2 and item 3.

If different, it will not be grouped and this is standard system behavior.

Hope helpful.

[Former Member]

Hello . Thanks for your help. Fact is that  price, warehouse, tax are  same. I post the outcome of the query where I show 2 lines of the  invoice, that cannot be groupe. ThanKs to the query i attach you can see  that it is all the same in the two lines that can not be grouped. The  only things that seems to be different are the "Factors" that are  changed automatically from the system, but I can't think they can be the  cause of this sort of bug... Here is the simple query

SELECT * FROM INV1 T1

WHERE T1.DOCENTRY = '1741'

This  is the test invoice that can not be "aggregated" - "grouped - "summed"  (I don't know the right term in english... sorry)  by item

I do not manage to attach a file ...I have to "create " a screenshoot where you can see the two lines of the invoice. You have to read the screenshoot like a page of a book, because obviously i had to divide the line. I have deleted the empty values , because it was really too long. For any question, just ask . 

What do I have to do? Please help me, I can not have invoices with thousands of lines!!