web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Transaction Import - Voucher and Adjustment Import

(0) ShareShare
ReportReport
Posted on by 71

How to modify the Voucher and Adjustment CTL file so that it can import Document-level notes for a batch when using Transaction import. Currently, the CTL file only imports the default after generating it from Microsoft Dynamics SL. So, I was wondering if there is an easy way to alter the CTL file to make the transaction import start importing notes.

I have over a hundred batches and within those batches maybe 10 or 20 Documents all containing notes at the Document-level. So, having to write/copy all those notes back to the individual documents is time consuming, and slows up the work environment.

I have the same question (0)
  • Suggested answer
    Mark E Profile Picture
    6,451 on at

    TK112407_5F00_tinotesv5.zip

    Review the attached file on how to incorporate notes in your TI CTL files.

  • REW Profile Picture
    51 on at

    Thanks for this sample code!

    Are any changes need to run as a VBA Component?  I no longer have BSL in SL2018.

    My file now starts with:

    'ControlMacroType: VBAComplete

    Yours truly,

    Ruth

  • Community Member Profile Picture
    on at

    Ruth, you can run the TI control files as generated from the SL Admin menu. If, for some reason, you do need the BSA components, they are an optional install found in the installation files.

  • REW Profile Picture
    51 on at

    Hello StuartNot,

    Thanks for responding to me post. Yes I generated a new control file for 4010000 which is working 99% using VBA in SL2018.  Only issue is the line item notes which are important in our billing since they contain a long URL related to the items being invoiced that cannot be placed into a user field. I used the sample code from customer source for adding notes in TI.  This looks the same as what we used in SL2011. Result: the line item note record is created in snote with all the correct values except a null value for snotetext, not the expected import value. The note ID is inserted into the sales order line correctly as well.  I have been testing on and off with this for many weeks but as I'm the CFO I have lots of competing priorities.  If there is someone you know who will to do a paid case for this with me, I would really appreciate it. Our reseller does not have anyone who works with TI.  Ruth

  • MARC_ Profile Picture
    626 on at

    And you are sure that the value you are mapping in the NoteStr1 = ImportField(?) is the correct excel column with the note? 

    Marc

  • REW Profile Picture
    51 on at

    Thanks Marc,

    I'm using ImportField(33) which is the  next field after 32 which inserts correctly.  This is a customized screen with fields from MaxQ technology so there is a checkbox possible in the 33 position, so I tried it with 34 and it was still null.  I feel like I tried every permutation at this point. The forum editor won't let me upload the control but here is the single instance file and what is getting inserted if that helps illustrate. We just pasted the note text in manually today.

    [View:/cfs-file/__key/communityserver-discussions-components-files/35/2102_5F00_acstran_5F00_onerecord.txt]Notes_5F00_Inserted.JPG

  • MARC_ Profile Picture
    626 on at

    I'm not sure if i'll be able to figure it out or not, but try saving the .ctl file as .txt and uploading it. see if that works.  

  • REW Profile Picture
    51 on at

    4010000_5F00_notes.txt

    You are wonderful.  Thanks for your time.

  • MARC_ Profile Picture
    626 on at

    Just to confirm, have you tried running it where the http site (on your test data file) does not have quotes around it?  

  • REW Profile Picture
    51 on at

    Yes that was just my last "hail Mary".  Normally the field doesn't have quotation marks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans