How records are inserted in purchparmtable and purchparmline from purchtable

(0) Share

Report

Posted on by Community Member

Hi Guys,

When I am creating PO, records are getting created in purchtable.

PurchParmTable and PurchParmLine contains detailed information regarding posting Purchase headers and Lines.

So actually at what stage it is creating record in purchparmtable and purchparmline, Where it is written to insert records in these parm tables.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

Look at PurchFormletterParmData class, its children and its parern class. For example, check out PurchFormletterParmData.createParmTable() and FormletterParmData.insertParmTable().

When these records are created depends on whether you use Late selection or not. If not, you'll see records already in the posting dialog. If you choose late selection, they will be generated before actual posting (which is what you want if you want to run periodic posting on schedule).

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Once you build your cross-references in a developer workspace, it actually takes 5 seconds to use the tool to identify all places which calls a write operation for PurchParm*:

msdn.microsoft.com/.../aa626961.aspx

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

Like (0)

Report

That was my first thought too, but practical tests don't support this theory. The problem is that there are no direct calls to insert these records (in the main scenario); it's done through RecordInsertList objects.

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

I have checked and you are right, this is one of the rare exceptions when it does not apply, in cases when you are using a Map, RecordInsertList, UnitOfWork and similar constructs. Luckily in majority of the cases you could get out useful information from xRef, so it does not hurt to learn about it for Mayur.

Only on the PurchParmLine table you are able to see the above mentioned class/method within the cross-reference list.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin & Vilmos,

Thanks for your reply.

When I am creating PO , records are not at all inserting in my purchparmtable and purchparmline. From where i can start my investigation.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

FormLetter classes are involved in posting+printing. Those values are getting populated when you try to post a Confirmation for your PO, did you try that?

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

Like (0)

Report

Please explain what exactly you're doing. But if you expect the records to be created immediately when create an order, the solution is changing your expectations. These parm tables are created for posting, so if you don't do anything regarding postings, they're not needed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guys,

In AX09 when we open PO Confirmation form,

we can see overview,setup and lines tab . (table behind is purchparmlines)

but ax in ax 2012, it is not standard. even parm lines are creating form purchformletterparmdata class.

whereas in ax09 puchformletter class was directly having method of createparmline and crateparmtable .

It needs to be customized but i m not sure exactly where should i be done.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Even you have the same methods on PurchFormletterParmData class.

What you are trying to customize and what is stopping you to do that?

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

Like (0)

Report

Yes, the framework has been refactor to smaller, better-defined components. You can learn about these changes in Using the Refactored Formletter Framework.

Was this reply helpful? Yes No