Unlock the Power of MEDITECH with MEDITECH KE

1

I am trying to get a report to show the invoices for each check written (accomplished). Problem is the txn.gl.account doesn't show up on the report. DPM/Segment is AP.CHECK.invoices. This is the macro code:

DO{@First(AP.INV.urn), @AP.INV.po.num^/PONUM, ""^@AP.INV.txn.urn, DO{@Next(AP.INV.txn.urn), DO{@Next(AP.INV.txn.gl.account), @AP.INV.txn.gl.account^/GLACCT}}}

flag

1 Answer

0

alt text

If the report's detail segment is AP.INV.transactions[AP.INV.urn, AP.INV.txn.urn], might want to report on your GL accounts this way. This approach would allow for up to 5 GL accounts being reported. All depends on how your report is structured.

xx.gl.acct.1
DAT=FREE
LEN=15
VAL=""^txn.gl.account,@Next(txn.gl.account,txn.distribution)

xx.gl.acct.2
DAT=FREE
LEN=15
VAL=IF{txn.gl.account @Next(txn.gl.account,txn.distribution);""}

xx.gl.acct.3
DAT=FREE
LEN=15
VAL=IF{txn.gl.account @Next(txn.gl.account,txn.distribution);""}

xx.gl.acct.4
DAT=FREE
LEN=15
VAL=IF{txn.gl.account @Next(txn.gl.account,txn.distribution);""}

xx.gl.acct.5
DAT=FREE
LEN=15
VAL=IF{txn.gl.account @Next(txn.gl.account,txn.distribution);""}

If this helps, let me know by voting up or down using the ARROWS.

Merry Christmas!

link|flag
Hi John, This solution work's however it prevents me from getting the check number from AP.CHECK. – Chuck Dec 22 at 18:01
Email me a screen shot of your report; where you are calling this information. My secure email is: tools.comstock-software.com/Vendors/…. – John Sharpe♦ Dec 22 at 19:27
Just wanted to verify you received my email with the screen shot yesterday. Thanks, Chuck – Chuck Dec 23 at 15:22
I did - haven't looked at it yet, will report back soon. – John Sharpe♦ Dec 23 at 18:44
Just reviewed your report and screenshot. Is there any reason not to use AP.INV.txn.distributions as your report's segment? Would using this segment leave data out of your report? If not, that looks like the simplest solution. If all else fails, an MV array populated by a DETAIL macro would work too. – John Sharpe♦ Dec 29 at 22:55

Your Answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.