Finance | Project Operations, Human Resources, ...

when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

(0) Share

Report

Posted on by @rp@n

5,901

Hi all,

Can you please let me know when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

I found some reference fields in PurchTable,PurchLine,SalesTable SalesLibe,TaxUncommitted etc...

What is the use of SouerceDocumentHeader and SourceDocumentLine?

Please give me more shed on this

Thanks!

All responses (11)

Answers (0)

Suggested answer

MhaU on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Dear Arpan

I do not have more information aside from what I have provided so far.

Also check the documentation available:

docs.microsoft.com/.../accounting-distributions

cloudblogs.microsoft.com/.../

Hope this clarifies
@rp@n 5,901 on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Thanks for your response.

Plesse let me know what is the use of SourceDicumentLine, SourcedocumentHeader etc... tables for Sales order or Purchase order.

Please give me more shed on this
Suggested answer

MhaU on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

I cannot see the field accountingevent, is there such in accountingdistribution for this sourcedocumetline?
Suggested answer

MhaU on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Dear Arpan

Apologies for the delay.

At first glance it is a good approach however for any doubts for corrupted data, please consult with Support team :-)

You might want to have in mind also TSTIMESHEETTABLE which also has references for SourceDocumentHeader.

Let us know if you need any other information and I will be more than happy to assist further or else please mark this thread as answered.
@rp@n 5,901 on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

can anyone pls help me on this
@rp@n 5,901 on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Can anyone pls help me on this ?

It's very urgent
@rp@n 5,901 on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Hi Mihaela,

Pls reply on this once you are available.

thanks!
@rp@n 5,901 on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Hi Mihaela,

pls clear my doubts and give me proper solution.

thanks!
@rp@n 5,901 on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Hi Mihaela,

Thanks for responding...

Actually I faced one issue during invoice in Vendor Pending Invoice in particular invoice only. When i do the posting, got error " The state of the source document or Source document line could not be updated ".

So,after much debugging I found particular one recId from SourceDocumentLine which having no references in PurchTable, PurchLine, TaxUncomitted,VendInvoiceInfoTable, VendInvoiceInfoLine those tables. Which caused the issue.

SourceDocumentLine REC ID - 5690628756

Field - SourceDocumentHeader - 5642832004

Table - SourceDocumentLine

Table - Purch Line

No record found

PurchTable -

A ). Search with SourceDocumentLine

No record found.

B). Search with SourceDocumentHeader

No record found.

Table - TaxUncomitted

Table - VendInvoiceInfoLine

No record found

Table - VendInvoiceInfoTable

Search with SourceDocumentHeader - Record Found but the Source DocumentLine is different.

Table - AccountingDistribution

No record found

Table - AccountingEvent

No record found

@ So, what I have done, I deleted that particular RECID = 5690628756 from SourceDicumentLine only and then trying to invoice . Now this error is not coming more.

1. Is it right approach? If NO, then please advice me what to do?

2. How much it is safe to delete record from SourceDicumentLine?

Please give me more shed on this.

Thanks!
Suggested answer

MhaU on at

Like (0)

Report

RE: when data get inserted or updated on SouerceDocumentHeader and SourceDocumentLine?

Dear @rp@n

Thank you for posting this issue on our community.

This is the source document datamodel and in those tables you capture all the actions made on that particular document.

Below you find the diagram for SourceDocumentHeader

And for SourceDocumentLine

In addition you have tables AccountingDistribution and AccountingEvent.

Is there a specific issue you would like to address?