Create free text invoice by code

(0) Share

Report

Posted on by Community Member

Hello,

I have to create new button that will call a RunBase class that will create a Free text invoice. I have list page with records. This button will allow multi select of different records but will be grouped per customer. This means if the user selects 3 records for which 2 of them belong to customer 001 and 1 belong to customer 003 than the function should create 2 different free text invoices. The class should show dialog with Invoice date and Post parameters.

The question is how to create this. I know i must populate this 2 tables:

a. CustInvoiceTable
b. CustInvoiceLine

what i need to write in mu run method and what in my main method???

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

you can group current records using query or whatever way. Then you can keep this information which is grouped by customer-id into a temp table. You can give this temp table to your class method and your class method can act on that temp data. you can find on search engine how to create free text invoice in x++. if you fail to find this, on search engine, tell us, so we can do it for you or we can provide you code to create free text invoice.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I cant insert new Line

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

1) you are not passing reference of Header in lines, while creating line. That makes your lines orphan, as they don't belong to any header. You can pass header reference in lines by following code

CustInvoiceLine.ParentRecId = custInvoiceTable.RecId

2) group your data by taking selected lines into new buffer, if you will group in same data source, it will effect current form query. You can loop over all selected lines and throw those into a temp table. then ready data using groupby from temp table

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

ok thank you for the first. It now works.

But for the second can you send me some code how to do it? I can't find anything similar and i have no idea how to do grouping and how to use temp table.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

Do you know how to loop through selected records? You may, have a look at next post

You can also make use of MultiSelectionHelper

Get selected records and insert those into temp table. Inserting a record in temp table is almost same as doing for regular table. You may, have a look at next URL.

Next when your TmpTable is ready, send it to class and let your Class work on it. Grouping data, which you collected in temp table, is same, as you do grouping in select statement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have created temp table and fill it with records. But when i do this

while select * from axmTempTable

group by axmTempTable.CustAccount

where axmTempTable.IsPayed == NoYes::No

{

ttsBegin;

custInvoiceTable.OrderAccount = axmTempTable.CustAccount;

custInvoiceTable.InvoiceAccount = axmTempTable.CustAccount;

custInvoiceTable.InvoiceDate = invoiceDate;

custInvoiceTable.CurrencyCode = custTable.Currency;

custInvoiceTable.insert();

ttsCommit;

}

gives me empty buffer and i can't use selected records . Why i can't use data from temp table. What is the problem? How i can solve this???

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hy EmiliJaN

I had created a job to create free text invoice through code in x++ ax 2012. Following is the code

static void CreateFreeTextInvoice(Args _args)
{
CustInvoiceTable custInvoiceTable;

custInvoiceTable.OrderAccount ="DE-001";
custInvoiceTable.InvoiceAccount = "DE-001";
custInvoiceTable.CurrencyCode = "USD";
custInvoiceTable.InvoiceDate = systemDateGet();
custInvoiceTable.insert();
info ("Inserted");
}

Was this reply helpful? Yes No

Community site session details

Create free text invoice by code

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Create free text invoice by code

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates