Browse By Tags

It takes longer than I consider normal to run the GLDR, print to PDF, and export to .xls. Does everyone have a slow export? I miss my last job's accounting software that had instant GL downloads (smart lists in Great Plains). Is there a way to speed it…

How do I obtain BWGAccess? Does it come standard as part of the BusinessWorks kit or is it a separate paid for application?

Hello, I need some help with importing and exporting data from Sage 50 using PowerShell. I received an email from a service consultant from Sage that contained a PowerShell script that runs an import or export state with a command line launch. The script…

Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but I can not find out where you can import them. I was trying to merge 2 databases with the database editor, but they have different…

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

Bonjour, J'utilise dans X3 une requête SQL qui va notamment chercher des données dans un menu local (3101 : plan d'amortissement). Ce menu local est paramétré avec une largeur max de 25 caractères : Lorsque je génère la requête, à l'écran, le résultat…

We have several individual companies in SAGE. I would like to export the general ledger detail from each company, at once, into one large excel file. Currently, I go into each company and export the data manually and it is very time consuming. Is…

Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…

Hello, I have been asked to copy the Report Setting that a specific employee that is no longer with the company had created and to bring it to the main company's account. The reason for this being is that the company's account, for some reason, is printing…

Is Creating a Budget in General Ledger a useful tool or is it better to create the budgets in Excel and export the data from GL?

Can't find this having been discussed anywhere, although I thought I had. I am assuming I can use a Temp field and either assign "<CompanyCode>" or Calculate it somehow. So far, nothing that I have tried has worked.

Hi All, Have a multi-user site on a network setup and one user in particular is having a constant issue when trying to export a Quote or invoice or anything for that matter. When you preview on screen and click "export" then you get the "Save As" window…

Hi everyone, I am new to Sage 50c, indeed, I do not use it, but I am assisting a client with migration to Sage Cloud Accounting. As they are not a UK company, the existing documentation and method are not applicable Migrate your data from Sage 50…

Hello, Is there away to export all the books at one time for a company rather than selecting one at a time under the export utility? Thank you, Kyle

I'm working on a custom import and I am having trouble with the beginning accumulated for assets with 100% Bonus depreciation. The field will not accept "0" but it also won't let me leave it blank or enter a value higher than "0" because it will then…

Group, is there a specific upload template I need to use to get my excel spreadsheet assets into Sage? Thanks Sam

As I said in the discussion prompt, I am trying to build a custom import map file for my company, and when I click "Save Map" no pop-up appears for me to actually save the map. It did, however, let me print the map to PDF. If someone could go in and create…

Is there a way to run a smart list and download to Excel a Asset grouping by Class? if so can someone tell me exactly how to do that? thank you.

I'm looking into purchasing the FAS Framework from FAS Professional Services and would like to hear who is currently using it. Our ERP system is MRI Software and really could use some incite on anyone that is currently using this process.

How do I activate this option? We have excel on workstations, but not on server where BV runs, and cannot export data files to excel (see "grayed" Excel option in pic). Thanks for any help.

I suppose this could be for almost any table with a DateCreated or DateUpdated field, but in this case I'm trying to create an export for CI_Item what includes only those records with a DateUpldated of today. Based on 3 different posts here on Sage City…

Hello SageCity, I am struggling to get to the bottom of a strange issue. It happens in SAGE 300 version 2019 when printing reports. The details are: 1) A user starts a report from SAGE, 2) The report program prompts for parameters, 3) User fills…

bonjour, je suis bénévole dans une asso qui utilise Sage 100 V0.02 et récupère les relevés de 900 comptes bancaires BNP sur Sage direct -> savez vous comment exporter les relevés bancaires ? -> sous quel format ? merci CP