on 05-02-2013 12:24 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Daniele,
Please raise ticket to SAP and share the outcome with us.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
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
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 ...!!
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi,
If you want to have one line for one item monthly, it is easily doable through a simple query.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
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:
| ||||||||
|
Content: Summary | Header Data | Validity
I think it is a current sap b1 system definition.
Hope Helpful
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!
User | Count |
---|---|
106 | |
12 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.