Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Positive Pay for Check...

Positive Pay for Check Register in Dynamics SL

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, I am Using Dynamics SL 2015 I am trying to build a text file which contains check details for positive pay.I tried printing
report from check register(03.630.00) and used export options. I am able to export only to excel format. The requirement is that
the output file should be a text file
For example u can consider the below format. I want the text file should come in this order.

RECONCILIATIONHEADER0008081599981 00023044014800007
00000000150007145527071599981 11301999
00000000160203223582071599981 11301999
00000000170007234482071599981 11301999
00000000190004091666071599981 12011999
00000000200004004309071599982 12011999
00000000210004640192071599981 12011777
00000000220000100390071599981 12011888

So how can i create the text file which contains check details? Is there any way to bring the data from the report or excel into
text file?

*This post is locked for comments

All responses (1)

Answers (0)

Jeanne Fischer 205 on at

Like (0)

Report

RE: Positive Pay for Check Register in Dynamics SL

For positive pay, I found the Cash Manager check register report (20.600) works. Export it to excel, make any changes required by your bank for upload and save as .txt or .csv. Not sure if bank rec module has same type of report. It should.