Menu
▾
▴
Forums
- Language-Serbian 15
- Language-Romanian 9
- Language-Hebrew 2
- Language-Farsi 3
- Language-Bosanski 4
- Language-Slovak and Czech language 9
- Language-Arabic 14
- Functional-Posterita 99
- Language-Turkish 14
- Language-Hungarian 7
- Functional-Human Resource 65
- Localization Brazil 64
- Language-Greek 1
- Language-Filipino 16
- Language-India 36
- Language-Thai-Siamese 47
- Functional-Manufacturing 290
- Language-Chinese 98
- Language-Finnish 5
- Language-Nusantara 56
- Language-Italian 81
- Language-Japanese 33
- Language-Portuguese 82
- Language-French 55
- Language-Bulgarian 7
- Language-German 223
- Language-Russian 15
- Language-Spanish 1180
- Functional-ERP 866
- Content & Documentation 128
- Functional-Financials 503
- Bazaar Projects 136
- Specifications Requests 16
- Developers 3195
- Community Process 327
- Business & Marketing 122
- Functional-Web-based Modules 103
- Help 1700
- Bazaar Open Discussion 2058
Dear All,
How we can map accounting transactions in fact_acct table for a particular document number(document# of invoice_vendor, invoice_customer, GL_Journal etc)?
When we post a document with, system save a separate ID#(c_invoice_id, gl_journal_id etc) in the relevant table and the same # is also save in fact_acct.record_id with both debit credict transaction. But there we don't find reference of document# with these accounting transactions.
How we can map?
thanks
Rizwan Anwar
Sorry I have post my question in a wrong forum and don't know how to edict the forum . . . .
Hi Rizwan,
Can you please explain more if I have misunderstood your question,
the factacct records contains the table, record id and line id which maps directly to (say) c_invoice table, c_invoice_id and, where appropriate, c_invoiceline_id.
it also contains the fact_acct_id which will get you to the 'accounting fact details' window at the correct record and lets you click on the 'record id' button to get to the underlying document.
steven