View original (French)

[Sage] Import invoice file in txt format

Tippex_66 -  
 chris -
Hello everyone

Here, I would like to import invoice, quote... files into the Sage commercial management software 100, but I only see the import function available for client, supplier, item files...

So I would like to know how to import my invoice files... into Sage, or where these files are located to integrate them directly into the software folder.

Thank you for your responses!

12 answers

  1.
    ppa Posted messages 258 Status Contributor 65
     
    Hello Yves,

    This is the file you can rename with a PNM extension. Naming it .pnm allows, when importing, to trigger specific controls for the format in accounting.

    Format 105 characters.
    Format 112 characters.
    Format 138 characters.
    Format 141 characters.
    Format 164 characters.
    Format 199 characters.

    Below is an example of a .pnm file in 199 characters containing all the examples:

    http://segs.free.fr/Fichiers/ecritures_sage.pnm

    As for my email, you can click on the envelope to the left of my response window.

    Phil
    4
  3. Tippex_66
     
    Thank you, but I’ve already posted on this forum as well.
    0
  4. ppa Posted messages 258 Status Contributor 65
     
    Hi Tippex_66,

    The import function can be found in:

    - File
    - Import
    - Format L100 and 30

    The text file must meet a specific format, either one line per field with specific flags for each line of info.

    I can send you the format if needed.

    Cheers,

    Phil
    0
    1. Yves de Paris
       
      Hello,

      I am looking for the import format for SAGEcompta, whether in txt or xls. I was given a format with fields but no details on the length; however, for the txt file, the length and the separator are very important. If you have this format, thank you very much for passing it on to me, I can do the tests.
      0
    2. Yves de Paris
       
      Hello,

      thank you very much for sending it to me, the format was perfect, I don't have the Sage software, that's why I couldn't get the information. The 112 character format is more commonly used.

      I think the file is in txt, is it enough to change *.txt to *.pnm? I am familiar with the formats but I haven't tried the versions yet.

      THANK YOU SO MUCH.

      YVES
      0
      1. ppa Posted messages 258 Status Contributor 65 > Yves de Paris
         
        Hello Yves,

        The import file for entries is indeed a text file in ASCII mode. It can be created by another application with a TXT extension, then renamed to PMN as long as it adheres to the fixed-length format design.

        The import/export file in TXT mode has a specific structure and cannot simply be renamed:

        #FLG 000
        #VER 12
        #DEV EUR
        #MECG
        ACH
        060106
        260106
        JB001
        21820
        4040000
        BLANC
        Invoice Jean Blanc Renault Express
        0
        0.000000
        0.00
        63960.70
        0.00
        #MECG
        ACH
        060106
        260106
        JB001
        4456219
        21820
        Invoice Jean Blanc Renault Express
        0
        0.000000
        0.00
        12536.30
        0
        ...
        #FIN
        (WARNING, do not take the truncated format above as the exact model)

        Upon reading it, it becomes evident that this format (.txt) is nothing like the format (.pnm)

        I hope I have answered your question and shed a little light on the subject.

        See you later

        Phil
        0
      2. Yves de Paris > ppa Posted messages 258 Status Contributor
         
        Hello,

        I'm very happy that you replied to me so quickly. I cannot send you a file (I don't have your email). I have put part of the text at the bottom; the lengths are a bit distorted but it is scrupulously respected. If I rename this file to .pnm, do you think that will work?
        Thank you for giving me an answer or telling me where I can send you the entire file. Indeed, the text format file is a bit odd; maybe it needs to be constructed in width??

        Yve from Paris
        04/11/07


        hotel kyab
        ACH010105FF401110 156 OPTIMS C 313.02S
        ACH010105FF606110 156 OPTIMS D 261.72S
        ACH010105FF445661 156 OPTIMS D 51.30S
        ACH030105FF401110 151 EWH C 25.20S
        ACH030105FF606110 151 EWH D 21.07S
        ACH030105FF445661 151 EWH D 4.13S
        ACH030105FF401110 152 EURL FA QUO DIFF C 80.40S
        ACH030105FF606110 152 EURL FA QUO DIFF D 78.75S
        ACH030105FF445661 152 EURL FA QUO DIFF D 1.65S
        ACH030105FF401110 154 AKM C 1231.60S
        ACH030105FF606110 154 AKM D 1029.77S
        ACH030105FF445661 154 AKM D 201.83S
        ACH030105FF401110 173 DE VALK FLEURS C 161.58S
        ACH030105FF606110 173 DE VALK FLEURS D 135.10S
        ACH030105FF445661 173 DE VALK FLEURS D 26.48S
        ACH040105FF401110 150 EDF C 2517.55S
        ACH040105FF606110 150 EDF D 2104.97S
        ACH040105FF445661 150 EDF D 412.58S
        ACH040105FF401110 158 CHEMDRY C 828.07S
        ACH040105FF606110 158 CHEMDRY D 692.37S
        ACH040105FF445661 158 CHEMDRY D 135.70S
        ACH050105FF401110 153 DIVERSEY C 262.83S
        ACH050105FF602220 153 DIVERSEY D 219.76S
        ACH050105FF445661 153 DIVERSEY D 43.07S
        0
  6. FG
     
    Since version 14 of Sage commercial management, it is possible to import and export documents (sales, purchases, stocks) in .txt format using configurable formats (file menu). There are more than a hundred messages on this subject posted on https://zoom.us/?utm_source=zoom.fr
    FGC
    0
  8. foutz
     
    Hello, I need to export (daily an Excel file)
    File format

    CLIENT NAME OR CODE | DATE | ITEM CODE | FREE TEST BLABLABLABLA| QUANTITY | PRICE |

    to Sage Gestion Com 100

    The result should produce:

    A NEW DELIVERY NOTE:
    (With the generation of the document number (n +1) if possible)
    How can I do this?
    0
  9. ppa Posted messages 258 Status Contributor 65
     
    Good evening,

    In any case, it is a specific development.

    2 methods to generate documents in commercial management:
    . - generation from an external document (.XLS) of a structured text file with one line per data area
    . - direct writing into the database through a specific Sage ODBC driver

    1st method: the information is in the appendices of the file at the end of the link below:
    . http://segs.free.fr/Fichiers/sommaigc.pdf

    2nd method: the information is in the appendices of the file at the end of the link below:
    . http://segs.free.fr/Fichiers/stucfic.pdf

    Be careful, this is a development that will take several days.

    See you and good luck,

    Phil
    0
  10. foutz
     
    Thank you, Phil.
    Following up on your message.
    Is there an ODBC to write to the Sage database?
    Our competence center claims that the ODBC is read-only.
    Thank you in advance for your response.
    0
  11. ppa Posted messages 258 Status Contributor 65
     
    Hello foutz,

    A long time ago, this statement was true. However, since at least 2002, the Sage ODBC driver has been functioning for both reading and writing. I use it almost daily for peripheral developments related to the Sage Ligne 100 modules.

    Beyond these reading/writing functions, the ODBC driver integrates an impressive amount of controls and functions (procedures and triggers), such as the ability to retrieve the N+1 of the commercial document number for the INSERT.

    See you later

    Phil
    0
  12. chris
     
    Hello,

    I also have a problem with Sage.
    I am using Sage Intégrale 5.00.0.50 at work, and I’ve been asked to send the data from a work order in Excel to this database to avoid double entry.
    In my research, I found that this is possible through an ODBC bridge in a specific format.
    Could someone provide me with more details?

    Thank you in advance.
    0
  13. ADM.SERVEUR Posted messages 2 Status Member
     
    I have practically the same problem, but regarding analytical lines.

    My configurable import format works very well, I use ACCESS to access a third-party business billing software and after processing, ACCESS gives me a TXT file with ";" as the separator.
    I extract:
    the journal code, the date, the due date, the piece number, the general account, the counterparty account, the description of the entry, credit amount, debit amount.
    All of this in a minimum of two lines, or even 3 or 4 lines depending on certain allocations (VAT for example).

    But now, for this year, I need to add the analytical information and there, despite all the attempts made, there's no way to enter the analytical information.

    I added:
    Analytical field where I place A
    Analytical section (7000)
    I use the credit and debit amount

    No way that this works, no error message from SAGE, SAGE indicates Completed as usual, but nothing has been entered into the accounting.

    Our support is unresponsive and I don’t understand why it isn’t working!!

    If I could have a small example of a txt file with the analytical information, that would be great.

    I asked the accountant to export to a txt file, but apparently, she can't do it or doesn't have the time or doesn't understand anything.....

    Thank you for shedding some light on the problem.

    --

    ----------------------
    Christian
    -1
    1. ppa Posted messages 258 Status Contributor 65
       
      Hello Christian,

      Send me your txt file so that I can take a look at it and, if possible, do a diagnosis.

      The email is the envelope on the left of the post when you're logged in.

      See you soon

      Phil
      0
      1. ADM.SERVEUR Posted messages 2 Status Member > ppa Posted messages 258 Status Contributor
         
        Here we go!!!!

        Thank you for looking into the issue.
        --

        ----------------------
        Christian
        0
    2. NPGY
       
      Hello,

      I have just read your request.
      I think you need to double your lines.
      One normal and one with the analytical information right after the account number.

      Keep me posted.

      A+

      Yaz
      0