Exporting sales invoices to .IMP file

SUGGESTED

I have been tasked to make an .IMP file from custom made "one of a kind" software, for import of Sales Invoice data into Sage 50, Desktop version 2021.1.1.  As far as I can tell, from reading the import file structure guides, both in .Pdf format and in Sage on-line documentation, this is partly simple, but then gets real complicated with the tax info.  Part of the problem is that the tax info is related to how each user has set up their tax table. The other part of the problem is that Sage 50 does not have the ability to export sales invoices to a sales invoice .IMP file, so that all programmers could just use that as an exact perfect example of how to make a properly formatted .IMP file, for import into the same copy of Sage 50.  At the moment, we programmers only are able to export Accounts, Vendors, Customers, Employees.  None of which solve the problem 

After this many years, and with so many people facing this same issue, I'm wondering why Sage has not addressed this.  We are left to go hunting for forth party software, and more expense, to do what should be a simple task.  Which is:  Export Sales Invoices to .IMP format for import to another Sage 50 system.

Question:   Is there a way to export Sales Invoice data from Sage 50 version 2021.1.1, without having to buy more software  ?

If the answer is "No" then I will recommend to the customer that we switch to a different accounting firm, that uses, QuickBooks which has a much simpler process for importing this data.  My customer cannot live without their custom made software, but they can live with changing accounting software.

Frustration level:  10

Parents
  • 0

    Hi

    you can exports sales invoice in sendind it by email to the client. Client with Sage 50 has to be set up to receive to import invoices, in client module.

    Regards,

    Danielle

  • 0 in reply to Danielle_LPC

    Don't you get a file called purinvce_xxxx.imp when you email a customer invoice that is set up to use Sage 50?

    From a customer perspective, the company emailing the customer invoice is a vendor.  Why would the customer want to import that into the customer sales module in their system?  They would want to import it into the Purchase invoice module and is therefore emailed a "purchaseinvoice".imp file not a sales invoice import file.

  • 0 in reply to Richard S. Ridings

    The customer import the .imp file as a purchase instead of typng the info. 

    BUT, I already create sales invoices with Excel and import them as sales invoices in Sage50. It saves me time and typing  errors . One import and it generates 30 to 31 sales invoices, each with a different date ans amounts.

    here is the beginning of the file created with Excel:

    <Version>
    12001,3
    </Version>
    <SalInvoice>
    Customer A
    1, ,Com_20210101,01/01/2021, 3,CAC,222.12,0.00
    CB,1,193.19, 193.19, TPS/TVH, 0, 1, 5.00, 9.66, TVQ, 0, 1, 9.975, 19.27
    </SalInvoice>
    <SalInvoice>
    Customer A
    1, ,Com_20210102,01/02/2021, 3,CAC,131.31,0.00
    CB,1,114.21, 114.21, TPS/TVH, 0, 1, 5.00, 5.71, TVQ, 0, 1, 9.975, 11.39
    </SalInvoice>

    and so on. CB is the name of the product / service I invoice to Customer A

    CAC is payment type (a "credit card" named CAC

    Just basic tax codes (TPS/TVH and TVQ)

    Well, after reading your post one more time, i realize that will not export sales invoices...

    Regards,

    Danielle

  • 0 in reply to Danielle_LPC

    Thanks for the great syntax example but don't you need all your fields to be in quotes? If so, how do you get Excel to do that without it converting dates into codes?

  • 0 in reply to Robert Laporte

    I dont need them, and import goes fine.

    I created a macro in Excel that creates each line of code (programming).

    PM me for further help if you want. I also speak French

    Regards,

    Danielle

  • 0 in reply to Danielle_LPC

    Bonjour Danielle, quelle syntaxe utilise-t-on pour un Débit préautorisé dans le fichier d'importation de factures ".imp"?

  • 0 in reply to Serge Morel

    This is an example of a .imp file that works well when importing an invoice with a payment by AMEX credit card.

    <Version>
    "12001", "1"
    </Version>
    <SalInvoice>
    "Cavendish, Pierre S."
    "1","","226843","09-30-2024","3","AMEX","6.72","0.00"
    "4710","2.0000","3.3600","6.72","TPS","0","1","0.0000","0.00","TVQ","0","1","0.0000","0.00"
    </SalInvoice>

    I would like to do the same with a Pre-Authorized Debit. So what should I put in place of AMEX?

  • 0 in reply to Serge Morel

    Bonjour Serge

    Il faut définir une carte de crédit acceptée correspondant au débit préautorisé. Utiliser ce code.
    J'ai CAC dans l'exemple que je donnais plus haut. CAC est lié à une carte de crédit acceptée

    Tiens nous au courant!

    Bonne journée!

    Danielle

  • 0 in reply to Robert Laporte

    Hi Robert

    You don't need quotes. I put stuff in each line with a macro, exactly as you see it. ThenvI select and copy all those lines and paste them in a Notepad file with the .imp extension.
    Sage imports this file.

    Regards,

    Danielle

  • 0 in reply to Danielle_LPC

    Bonjour Danielle,

    J'ai créé une nouvelle carte de crédit dans Paramètres, Entreprise, Cartes de crédit que j'ai nommée DPA, et le transfert par fichier imp s'effectue parfaitement, merci! Mais maintenant comment puis-je faire pour créer un fichier de débits pré-autorisés à envoyer à l'institution bancaire? La tâche "Téléverser débits pré-autorisés" semble filtrer exclusivement sur le mode de paiement natif au logiciel, soit "Débit préautorisé (DPA)".

    Merci d'avance!

    Serge

Reply
  • 0 in reply to Danielle_LPC

    Bonjour Danielle,

    J'ai créé une nouvelle carte de crédit dans Paramètres, Entreprise, Cartes de crédit que j'ai nommée DPA, et le transfert par fichier imp s'effectue parfaitement, merci! Mais maintenant comment puis-je faire pour créer un fichier de débits pré-autorisés à envoyer à l'institution bancaire? La tâche "Téléverser débits pré-autorisés" semble filtrer exclusivement sur le mode de paiement natif au logiciel, soit "Débit préautorisé (DPA)".

    Merci d'avance!

    Serge

Children