Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Brian_IL Profile Picture
    Brian_IL 715 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 Microsoft Employee 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,240 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 Microsoft Employee 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans