# Multiple sales into one invoice

**URL:** <https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575>\
**Category:** Developer Forum\
**Created:** [June 17, 2013, 2:00pm UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575 "2013-06-17T14:00:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vytautas](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@Vytautas](https://www.dynamicsuser.net/u/Vytautas)\
**Post date:** [June 17, 2013, 2:00pm UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575/1 "2013-06-17T14:00:10Z")

</div>

Hello guys,

I really really need your help… I have for example 2 Sales orders and I need to print one invoice for them, no for each other… Maybe anyone did it in x++ ? I found smth like that : salesparmupdate.sumby, but I don’t know how to use this… Please help me.

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [June 17, 2013, 9:37pm UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575/2 "2013-06-17T21:37:18Z")

</div>

Use the summary update on the periodic invoice routine and it will combine them without any coding.

---

<div class="post-metadata">

**Author:** ![Vytautas](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@Vytautas](https://www.dynamicsuser.net/u/Vytautas)\
**Post date:** [June 18, 2013, 5:40am UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575/3 "2013-06-18T05:40:18Z")

</div>

I need to write a code, because I’m doin auto invoicing, I did invoicing for selected for each, so I need to join invoices…

---

<div class="post-metadata">

**Author:** ![Vytautas](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@Vytautas](https://www.dynamicsuser.net/u/Vytautas)\
**Post date:** [June 18, 2013, 7:21am UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575/4 "2013-06-18T07:21:33Z")

</div>

I did it 🙂

void SFjoin()

{

SalesFormLetter letter=SalesFormLetter::construct(DocumentStatus::Invoice);

SalesParmLine parmLine;

salesLine \_salesLine;

SalesParmTable SalesParmTable;

salesParmUpdate salesParmUpdate;

SalesTable SalesTableMarked;

;

ttsBegin;

letter.transDate(systemDateGet());

letter.multiForm(true);

letter.specQty(SalesUpdate::All);

letter.printFormLetter (true);

letter.createParmUpdate();

select forupdate firstonly salesParmUpdate where

salesParmUpdate.RecId == letter.salesParmUpdate().RecId;

salesParmUpdate.SumBy = AccountOrder::Account;

salesParmUpdate.update();

letter.salesParmUpdate(salesParmUpdate);

letter.initParameters(letter.salesParmUpdate(),

PrintOut::Current);

if (SalesTable\_ds.anyMarked())

{

SalesTableMarked = SalesTable\_ds.getFirst(1,false);

while(SalesTableMarked)

{

letter.createParmTable(SalesParmTable, SalesTable::find(SalesTableMarked.SalesId));

SalesParmTable.DocumentDate = SalesTable::find(SalesTableMarked.SalesId).DeliveryDate;

SalesParmTable.Transdate = SalesTable::find(SalesTableMarked.SalesId).DeliveryDate;

SalesParmTable.DocNumberingCode\_LT = “P\_SF1”;

SalesParmTable.insert();

SalesParmTable.clear();

while select \_salesLine where \_salesLine.SalesId == SalesTableMarked.SalesId

letter.createParmLine(\_salesLine);

SalesTableMarked = SalesTable\_ds.getNext();

}

}

letter.run();

ttscommit;

}

---

<div class="post-metadata">

**Author:** ![AshokDAX](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@AshokDAX](https://www.dynamicsuser.net/u/AshokDAX)\
**Post date:** [January 4, 2014, 11:33am UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575/5 "2014-01-04T11:33:00Z")

</div>

Hi ,

Could any one tell the above code in Ax2012.

Thanks a lot…!!

Daxing

---

<div class="post-metadata">

**Author:** ![AshokDAX](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@AshokDAX](https://www.dynamicsuser.net/u/AshokDAX)\
**Post date:** [January 6, 2014, 7:21am UTC](https://www.dynamicsuser.net/t/multiple-sales-into-one-invoice/46575/6 "2014-01-06T07:21:17Z")

</div>

Hi ,

Any help kindly.!!!