SalesLine Table in Logging Database Changes Wizard

(0) Share

Report

Posted on by Community Member

Does anyone know where I can find the SalesLine within the Logging Database Changes Wizard? We would like to log all updates to the qty field in SalesLine and it seems like I've looked through everything and can't find it. Also, If you know of a good way to find where a table is located in this wizard that would be a tremendous help. It is very difficult to navigate through the wizard blindly looking for a needle in a haystack. Any help is appreciated.

Thank you,

Brian

*This post is locked for comments

I have the same question (1)

All responses (10)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Make sure to click on "Show all tables"

After that, it goes by the tables label. Salesline table is "Order Lines"

So Accounts Receivable > Order Lines.

Kindest regards.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Kent,

Kent I am not showing Accounts Receivable in the list even when I show all tables. I find Sales Order Lines under Trade, but that doesn't have the field QTY. Do you know where the QTY field from SalesLine would be in this log list. I can't find it anywhere.

Thanks again, any help is much appreciated

Brian

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

What domain are you choosing on the previous step? Perhaps that domain doesn't have access to A/R

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am logged into TEST at the Cus layer (AX 2012). I then go to System Administration->Setup->Database->Database Log Setup. Then I click on new, which brings up the Logging Database Changes Wizard. I click next and I get the screen like the image in the previous post. I don't have an option to select domain.

Was this reply helpful? Yes No
Battery Boy 445 on at

Like (0)

Report

I also have this problem. Every single table in the database appears apart from the one that most people will want to add logging to - sales order line.

I have noticed purchase order lines appear under the 'Trade' heading, but not sales lines.

Is there any other way of adding database logging without using this useless wizard?

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

@Battery Boy: brw_ax_developer doesn't have the same problem, he already confirmed that he can see Order lines under Trade (with Show all tables checked). Try it once more.

@brw_ax_developer: There is no Qty field, that's correct - but there is no Qty field in SalesLine table either. You're probably looking for SalesQty field.

1 people found this reply helpful.

Was this reply helpful? Yes No
Battery Boy 445 on at

Like (0)

Report

Yes salesline is called 'order lines' in the list for some reason.

I've found you can add tables and fields to the databaselog table manually, but you need to get the id of the table by using:

static void GetTableId(Args _args)

{

str s;

tableid id;

;

id = tableName2Id("salesline");

info('table name = ' + int2Str(id));

}

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

The reason is that that's the UI name (implemented as a label) of the table. It's the same reason as why ReqCalcTask is displayed as Master planning tasks (for example) - naming conventions (e.g. module prefixes such as Sales), limitations (no spaces) and such implementation details of AOT names are nothing what users should care about when using GUI.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

you have to pick node: Not specified and there is table Order Lines.

Id´s is 359

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

I don't know why Microsoft chose to use the label in the database log wizard. Some of the tables have the same label, which makes telling them apart difficult, and some tables have no label at all.

Save yourself a lot of headache and fix it.

In the form SysDatabaseLogWizard, change the method buildTableTree like this.

Find the line

item = new FormTreeItem(tableid2name(any2int(tableRef.Id)),tableRef.Mode,1);

Change it to

item = new FormTreeItem(tableid2pname(any2int(tableRef.Id)),tableRef.Mode,1);

Basically just change tableid2name to tableid2pname. Now the wizard will show all tables with their raw AOT name which is both unique and always makes sense.

Was this reply helpful? Yes No