Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
duplicate order lines when items has several BOMs
04-30-2018, 01:30 AM
Post: #1
duplicate order lines when items has several BOMs
Hi Folks

Issue: an order line is printed n times (instead of once) if a SKU has n BOMs

To recreate the issue:

1)
create an item "item1"(UOM each, controlled)

2)
create a item '"kit1" (UOM case, KIT)
create a BOM for an "kit1" with component "item1" quantity 12

3)
create a item '"kit2" (UOM case, KIT)
create a BOM for an "kit2" with component "item1" quantity 18

4)
enter a sale order by ordering 3 x kit2
the order HTML page shows the correct quantity

BUT: the PDFs show two lines (and even n lines if there were n BOMs using the same item component)
However, the invoice total is correct

please confirm you see the same

thanks!
Find all posts by this user
Quote this message in a reply
04-30-2018, 04:03 AM
Post: #2
RE: duplicate order lines when items has several BOMs
...so are you saying that duplicate lines are only with the PDF?
Find all posts by this user
Quote this message in a reply
04-30-2018, 04:42 AM
Post: #3
RE: duplicate order lines when items has several BOMs
(04-30-2018 04:03 AM)TurboPT Wrote:  ...so are you saying that duplicate lines are only with the PDF?

Correct. The order in HTML displays correctly
Only the PDFs have this issue (quotation and invoice) but the totals are correctly displayed in the PDFs
Find all posts by this user
Quote this message in a reply
04-30-2018, 06:58 AM (This post was last modified: 04-30-2018 06:59 AM by HDeriauFF.)
Post: #4
RE: duplicate order lines when items has several BOMs
(04-30-2018 04:42 AM)HDeriauFF Wrote:  
(04-30-2018 04:03 AM)TurboPT Wrote:  ...so are you saying that duplicate lines are only with the PDF?

Correct. The order in HTML displays correctly
Only the PDFs have this issue (quotation and invoice) but the totals are correctly displayed in the PDFs
**** UPDATE ****
I think the problem is not weberp related, the reason being I altered the query in printcustrans with a LEFT JOIN in order to display in my PDFs the bom.quantity. But there is no way to determine that 150 units displayed on the invoice come from 3 kits of 50 or 2 kits of 75.
I think we can close the case.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: