Share
ReportGL table GL20000 (Open Year Transactions-YEAR 2019 ) has a column ORCTRNUM which is not storing the Payable Invoice # for few PAYABLE INVOICES (PAYABLE TRANSACTION ENTRY I am just wondering that why it is happening for few Payable Invoices (Sourcdoc =PMTRX).Let me explain my question in detail. suppose a user enter a Payable transaction (Transaction >> Purchase >> Transaction Entry) with 3 GL accounts and then post this transaction in GL. AFTER THAT GL20000 Table shows the Payable Invoice # in 2 rows but the 3rd row does not store Payable Invoice # for few transactions.
I have to develop a report but because of this issue . I am thinking that may be the Link Broke at the time when user posted this Payable Invoice . Note that Transactions are posted through GL. cAN ANYBODY HELP ME THAT WHY IT IS HAPPENING WITH FEW Payable Invoices and the most amazing thing is that when i open these Transactions by using the Journal Entry Inquiry screen , it opens and allow me to drill down to see the Actual Payable Invoice.
Note that The report I am working on use other tables too. But since I need all Payable Transactions posted in 2019 in GL ALONG WITH THE ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3,ACTNUMBR_4 SO I WANT TO USE account Index which GL20000 Table stores. Can any body tell me that why GL20000 Table not storing the Payable Invoice Numbers for all rows who have the same Journal Entry Number?? and what is the solution
*This post is locked for comments
All responses (
Answers (
291,269
