why order repeated in database and it invoiced one time

ahmedba

Hi guys i make report to sales invoices this report take data from sales invoice line table i see same order two time but with different quantity why how i solve this problem.our employee make sales order then ship then invoice it display in database as two lines but he make invoicing one time as following in sales invoice line table

document no sell to customer line no quantity order no

12 005 100 90 20

13 005 100 200 20

are this true

i think it must display as one order as following

12 005 100 290 20

what i want to display this line in database as

12 005 100 290 20

what i make to solve this problem

ppavuk

When you post a partial invoice (let's say original quantity was 2, and you invoiced 1 and 1 later) system will create sales invoice document for each partial invoice (and shipment too). So, you'll got 2 documents for, and two lines with different quantity invoiced. This is how standard system works.

I believe in your case this items wasn't invoiced on same time. Another reason - you might have some customization on system, which follow to create several documents per order line.