As an anti-fraud measure, we need to provide the bank a file containing information (payee name, date, amount, check number) for every check issued each day. Also, we need to provide the same data for checks voided or stopped. Being a rank novice, I’m not quite sure were/how to obtain the information required. Which table(s) need to be queried? Any suggestions? Thanks and kind regards, Lee
Not a lot of people paid attention to this topic when first posted. Anyone done something similar to what Lee is looking for. Soren Nielsen, moderator Integration/Developer NOLUG
quote:
Originally posted by SNielsen: Not a lot of people paid attention to this topic when first posted. Anyone done something similar to what Lee is looking for. Soren NielsenIntegrationDeveloper, moderator / NOLUG
There is a standard report in Navision which shows a list of checks issued. You might be able to get by with simply capturing the output of that report— or you might have to tweak it. The data you need is in the Check Ledger Entry table. ------- Tim Horrigan horrigan@aol.com