Browse By Tags

  • Looking to Export AP Payment Transaction History-System Limiting Export

    When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

  • VI Invoice Counter on export of AP_CheckDetail

    Hi Everyone,

    I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices.

    There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice listed…

  • Data import export?

    Is it possible to export\import data from Sage50 CA to 3rd party app?

    Like export Vendor once it's created?

  • Automatic/Periodic Export of Reports to a folder

    Sage 200 reports can be exported to CSV manually and saved to a folder.
    Is it possible to automate this process say once a day?
    As we have another piece of software that consumes the CSVs from Sage.

  • export Sage Fixed Asset Data into excel in order to create a pivot table

    create an export option where the data can be exported into excel in a format that can easily create pivot tables

    Thanks

  • Anyone know how to setup an Export template so that it's output is split into multiple files?

    Hello, 

    We are still using version 7. We have an export template we use to export invoices to be sent through EDI. Currently the export template creates a single text document with information from every invoice that needs to be sent. Is there a way to…

  • Import Excel in SageX3 v12

    Bonjour,

     Nous utilisons dans la  grande entreprise où je travaille Sage X3 comme ERP, dans lequel nous stockons un nombre incalculable d’informations que nous générons d’abord dans Excel.

    Je cherche un plug in ou quelque…

  • How can I export a report as a live Excel file or .csv?

    I want to take different reports and export them as live updating .csv file or other Excel compatible format. For example, there is a report at IC > Reports > On Hand Detail Report. I would like to be able to save a copy of the file locally to open with…

  • Failed to convert to PDF

    Over the past week we have had issues exporting anything out of HandiTax Cloud.  The consistent error that we get is "Failed to convert to PDF".  This prevents us from finalising any work for our clients until we can rectify the issue.

    If anyone…

  • Comment exporter l'ensemble de la liste article (articles contenus dans les gammes compris) ?

    Bonjour,

    je voudrais exporter vers un fichier texte ou excel l'ensemble de ma liste d'article, incluant les différents articles contenus dans les gammes sur la dernière version de sage 100 ou 100c.

    Pour le moment je n'ai réussit qu…

  • Sage 100 Standard 2020: How do I import a bank statement to Sage 100?

    Hi all, 

    I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…

  • Export data from Sage 50 CA using SDK

    Hi all,

    Is there anyone has an idea to export the data from Sage 50 CA? I was looking at the method w the class "CustomerLedger" but it has only the Save method it does not have the get method, Please let me know if you have any idea of hints to solve…

  • Export files

    I am setting up a batch job to export some stock information to send out through my EDI program.  We've done this several times in the past and accounted for the name of the file being the same by timing of the various scheduled jobs needed to do this…

  • Account for SME Brexit Support Fund income

    The SME Brexit Support Fund gives eligible small and medium-size businesses up to £2,000 to help with training or professional advice on things like completing custom declarations and managing customs processes and import and export requirements.…

  • Accounting for SME Brexit Support Fund income

    The SME Brexit Support Fund gives eligible small and medium-size businesses up to £2,000 to help with training or professional advice on things like completing custom declarations and managing customs processes and import and export requirements.…

  • Batch update of customer account contact details using export-import

    Currently, you cannot batch update the contact details for customer accounts using the export and import process. Contact details must be edited individually, which is a time-consuming process.

    It would be a good idea to support updating the customer account…

  • Crystal Report export to Excel - date formatting issue

    I need some help here.  I have a Crystal report that contains a sub-report with a date field.  My goal is to export the report from X3, go to Excel then to a pivot table and use this date field as a major sorting point.  My issue is the date field (from…

  • Product Country of Origin - Allow the option to set a default country

    Currently

    Default country of origin is United Kingdom (GB)

    Problem

    1. Some companies may only sell products from 1 country which is not GB. This means changing it for every product input rather than setting the default of their chosing.

    2. Some users…

  • Erreur en export excel des impressions de facture

    Bonjour, 

    Depuis peu je rencontre une erreur en édition externe Excel de devis Batigest. Je vous joins la capture de l'erreur. Quelqu'un aurai t-il une idée ? 

  • Sending a SO to an ftp site from within Sage X3

    I've worked with web-service and imports a lot, but not too much with exports. The requirement here is I need to export the SO whenever it is created in X3 to a particular 'ftp' location & also I need to know how to define that ftp location in x3. Is…

  • Illustrated guide to tracing Imports and Exports

    NOTE: The Engine Tracing functionality changed significantly in 2021 R3 (Version 12 Patch 27). See the PDFs attached to KB article "How to run an Engine trace in Sage X3?" for more details on both the pre-V12P27 and V12P27+ methods of setting up…

  • Export EU

    Good afternoon, 

    I have the following question. 

    We sell goods to EU consumers B2C. We have been charging VAT on our invoices. However, we send the goods through DPD and we receive an invoice for the cost of transport and another invoice for the VAT charges…

  • Export EU B2C - Brexit

    Good afternoon, 

    I have the following question. 

    We sell goods to EU consumers B2C. We have been charging VAT on our invoices. However, we send the goods through DPD and we receive an invoice for the cost of transport and another invoice for the VAT charges…

  • Report Designer exporting Data to excel query

    Hi

    When I export a bespoke report to 'Data to excel' the data columns are not in the correct order:

    IE.

    Column G - PaymentAnalysis.Desc2

    Column H - PaymentAnalysis.Desc4

    Column I - PaymentAnalysis.Desc6

    Column J - PaymentAnalysis.Desc10

    Column k …

  • Exporting sales invoices to .IMP file

    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…