Invoice Number sequence for Free Text Invoice

Finance and Operations/AX User Forum
1

Dear All,

I want to have difference Invoice number sequence for Free text Invoice, am mapping Number sequence group in Free text invoice and raising the invoice but in my case the invoice no is not as per the mapped Number sequence group. Am not sure why its not working. Please suggest were am going wrong…its bit urgent :frowning: Thanks in advance.

Regards,

Venugopal

2

In the sales parameters is the follow ticked against teh free text invoice number sequence? Does the customer have a defined specific number sequence or is it just that the parameters are set to the same references.

3

Can you clarify yourself please for the solution ?

4

Hi AdamRoue,

When i try to tick the free text invoice number sequence Follow flag in Sales Parameter am getting infolog message and doesnt allow to tick the flag

“The current reference cannot be set to follow another reference” Not sure how to take it forward… Thanks.

Regards,

Venugopal

5

static void Job6(Args _args)
{
DictTable dictTable,dictTable1;
Form form;
FormBuildDesign design;
FormBuildDataSource ds,ds1;
Query q;
QueryBuildDatasource ds2,ds3;
FormBuildTabControl tab;
FormBuildTabPageControl tp1;
FormBuildTabPageControl tp2;

FormBuildGridControl grid;

Args args;
FormRun formRun;
;
//q = new Query();
//ds2=q.addDataSource(tablenum(OrderDetails));
//ds3=ds2.addDataSource(tablenum(SalesmanDetails));
//ds2.relations(true);
//ds2.joinMode(joinmode::InnerJoin);

dictTable = new DictTable(tablenum(OrderDetails));
dictTable1 = new DictTable(tablenum(SalesmanDetails));

form = new Form();
form.name(“BankTransTypeDynamic”);

ds = form.addDataSource(dictTable.name());
ds1 = form.addDataSource(dictTable1.name());

ds.table(dictTable.id());
ds1.table(dictTable1.id());
ds.joinSource(ds1);
ds.linkType(joinmode::InnerJoin);

design = form.addDesign(‘design’);
design.caption(“Bank transaction type”);
tab = design.addControl(FormControlType::Tab, “Tab”);
tab.widthMode(FormWidth::ColumnWidth);
tab.heightMode(FormHeight::ColumnHeight);
tp1 = tab.addControl(FormControlType::TabPage, “Tp1”);
tp1.caption(“Overview”);

grid = tp1.addControl(FormControlType::Grid, “Grid”);
//grid.dataSource(ds.name());
//rid.dataSource(ds1.name());
grid.widthMode(FormWidth::ColumnWidth);
grid.heightMode(FormHeight::ColumnHeight);
grid.addDataField(ds.id(),fieldnum(OrderDetails, OrderId));
grid.addDataField(ds.id(),fieldnum(OrderDetails, OrderDate));
grid.addDataField(ds.id(),fieldnum(OrderDetails, OrderDueDate));
grid.addDataField(ds1.id(),fieldnum(SalesmanDetails, SalesmanId));
grid.addDataField(ds1.id(),fieldnum(SalesmanDetails, Name));

args = new Args();
args.object(form);
formRun = classfactory.formRunClass(args);
formRun.init();
formRun.run();
formRun.detach();

}

here i wan to join 2 datasource, i have SalesmanDetails and OrderDetails with one common field SalesmanId…i wan to join the datasource and then show the related field of salesmandetails in grid…

6

That is fine I was asking if it was ticked, not for you to tick it, it would override the defined sequence.

Might be it takes it as standard from a posted point of view, I would need to see as it would make sense from a posted perspective.

7

Ok. But when i went thru the help document of AX it says the seqeunce is for raising different sequence… not sure how it will work… is there any hot fix for the same…Thanks.

Regards,

Venu

8

In the AX demo system the free text invoice is set to AR_002 and the invoice AR_026 and raising and positng a free text invoice I get an invoice number from AR_002. It is as simple as that. Can you post a screen shot of your number sequence parameter settings?

9

Hi,

Please try this.

A/R -Parameters-Number sequence tab

Highlight FREE TEXT INVOICE, then click on the GROUP button on the right hand side top

Click New

e.g LOCAL and put any description, click on the REFERENCE tab, you will find FREE TEXT INVOICE there, against this, select the number sequence which you need.

Now assign the Number Sequenc Group LOCAL to any customer - A/R- Customer details–Setup tab–NUMBER SEQUENCE GROUP

Create a Free Text invoice for this customer and post it.

See the result.

Please reply if you don’t get the right solution.

regards

TP