Hi,
I am a new user for JetExpress tool. I am using this tool to create the report for Dynamics NAV 2015. But I have faced an issue with Sales Invoice and Sales Credit Memo.
In my report, I would like to remove two rows contains Sales Invoice and Sales Credit Memo.(Please see attached image).
But I didn't find any option for this.
Any suggestions are much appreciable.
Kind Regards
Ahsan
Hi Ahsan,
It looks like you are trying to remove the correcting entries. Is that true? Unfortunately, there isn't a way (as far as I know) to tell Jet to not include them - but I might be not understanding exactly what you need. Depending on what you are trying to list out, you might be able to handle this with some filters. Could you get around this by filtering out all documents that are completely invoiced? Or where the record is Not Open?
SLK
Thanks Sarah for your reply.
I don't want to show these records which are just neutralized one another. Example
Sales Invoice: -5 | price: 40.35
Sales Credit Demo: +5 | price: -40.35
In my report, I found lots of records are same just +/- neutralize.
Is this possible to filtering out by documents that are completed invoiced?
As I am very new to Nav and JetExpress so can't able to explain clearly. Sorry.
It all depends on what table you are pulling the information from. What is your base table for this report? It looks like it might be the Item Ledger Entry but I am not sure.
Hi Sarah,
My base table is "value entry" table. You already got my table relationship in another thread.
FYI,
Kind Regards
Ahsan