web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Invoice and memo/Trans...
Microsoft Dynamics SL (Archived)

Invoice and memo/Transaction import

(0) ShareShare
ReportReport
Posted on by nischwartze 115

I'm very new to Dynamics SL and was looking for a way to import multiple invoices at once using transaction import.  I created my control file easily enough, but I'm looking for help creating a data file.  Isn't there a way to just create a .csv file with specific columns and headers that will import into excel using transaction import? 

The internet is not very forthcoming with templates etc... It's like there's a conspiracy among consulting firms and solution providers to make free info on this topic hard to come by.

I've already looked at the user guide that comes with Excel.  The trouble is, I don't have a degree in computer science.  I was really just hoping I could create a spreadsheet and just import the info into Solomon.  Is this possible, or am I stuck with paying someone to code/program a solution for me?

Thanks for your help in advance!

Nick

*This post is locked for comments

I have the same question (0)
  • Brian_IL Profile Picture
    Brian_IL 719 on at
    RE: Invoice and memo/Transaction import

    Which screen is to receive the import data? You create a control macro for a screen from the Admin Tools menu, then you create a data file that matches the import level  and column number specified in the TI control macro. For example, the GL Journal Transactions screen has 2 levels: Batch and Detail. Each level will differ in the number of fields and type of data contained. An import file for that screen with a non-customized control macro would look like the following, with actual values substituted for the fields listed. Not all fields need to be included in an import, but the sequence of fields in the control macro and data file must match.

    BATCH,,,,,,,,,,,,,,,,,,

    DETAIL,CpnyID,Account#,Project,Task,SubAcct#,Ref#,TranDate,EmpID,Laborclass,Billable,Qty,DebitAmount,CreditAmount,Description,,,,

    The System Manager User Guide has a section on using Transaction Import. You may want to look at the discussion and example there.

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice and memo/Transaction import

    Hi John,

     I am replying to an old post but I would love to get a copy of the import file in excel.  Would you be able to send it to me at sasithideth@gmail.com?

  • kcruse Profile Picture
    kcruse 60 on at
    RE: Invoice and memo/Transaction import

    Will this import work with multiple vendors? Or do all the invoices in the import have to be from the same vendor?

  • karmar Profile Picture
    karmar 195 on at
    RE: Invoice and memo/Transaction import

    Hi Ajit, thanks for posting the answer (and Nischwartze for asking =)

    I oversee a Dymamics SL7  application, and I have a need (love them over holidays =) of massively close a very large amount of POs, so they can do their year end process.

    Normally, this involves  Receipt/Invoice entry process, which is a 2 steps, 3 screens (Receipt Invoice for a PO, enter detail, click Invoice button, enter vendor invoice detail), then save and release the batches.

    Do you happen to have an SQL script I can try for this? (It can be a two step, just receiving all of them and create a large batch), then releasing the batch (ideally, another script, plan B, via application?)

    Thanks!

  • Suggested answer
    Ajit Kannan Profile Picture
    Ajit Kannan 1,246 on at
    RE: Invoice and memo/Transaction import

    Hi  Nischwartze,

    Refer the  Invoice & Memo Templete.

    Control File (.CTL)

    Batch,cbatnbr,cperpost,cbathandling,cctrltot
    Invoice,cdoctype,crefnbr,ccustid,cdocdate,corigdocamt,cdocdesc,cterms,cProjectId_Hdr,cslsperid,cdiscdate,cduedate,cdiscbal,cCpnyID01,caracct,carsub,Tx_cdoctaxid,Tx_cdoctaxable,Tx_cdoctax,Tx_cdoctaxid,Tx_cdoctaxable,Tx_cdoctax,Tx_cdoctaxid,Tx_cdoctaxable,Tx_cdoctax,Tx_cdoctaxid,Tx_cdoctaxable,Tx_cdoctax
    Transaction,cCpnyIDTran,cacct,cprojectid,ctaskid,csub,cqty,cunitdesc,cunitprice,ctranamt,ctrandesc,cextrefnbr,ctaxcat,ctaxiddflt,Tx_cdettaxid,Tx_cdettaxable,Tx_cdettax,Tx_cdettaxid,Tx_cdettaxable,Tx_cdettax,Tx_cdettaxid,Tx_cdettaxable,Tx_cdettax,Tx_cdettaxid,Tx_cdettaxable,Tx_cdettax
    DocTerms,cinstallmnttot,cnbrdays,cinstalldate,cinstallamt

    Data File (.CSV)

    Batch (Invoice Entry)

      LEVEL0,,,R,250

    Document (Invoice Entry)

    LEVEL1,IN,,C300,,250,,01,CO123000,,,,0,,,,

    Detail (Invoice Entry)
    LEVEL4,,,,AD00001,CO,,2,,100,200,,,,,
    LEVEL4,,,,AD00002,01,,1,,50,50,,,,,

    Thanks,

    Ajit Kannan

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice and memo/Transaction import

    Hi Nick, I can send you a sample invoice import file in Excel. Send me an email to JJoyce1215(at)gmail(dot)com

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans