Browse By Tags

  • exporting invoice detail lines

    is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…
  • BWAccess APV city state import

    I am importing an Accounts Payable Vendor to BusinessWorks. The file is a comma delimited file. The definition says to send city and state abbreviation a City, ST for example Hastings, MN. When importing, this adds the city as "Hastings" and the Zip code…
  • SDK invoice 0 $

    Hi, I import invoices with a c# program that I made using the SDK. It's working fine, but time to time I need to create an invoice with 0$ total. I'm able to create a sales order and manually transform the sales order to an invoice. Is there a way to…
  • Exporting Sales Invoices to create a csv file

    Hello, is there a 3rd party "app" or anything that would work to be able to export sales invoices in Sage50? For example, if we want to export sales invoices that were entered for the past 3 days, is there a way to do that to create a .csv file? Thank…
  • Importing Sales Invoices and updating dimensions

    For a Customer we import Sales Invoices using a template based on the SIH import template. Importing new, multiline invoices works fine. But when trying to update an invoice but adding an extra line, the error below occurs. A work around, is to…
  • Import Invoice With Multiple Line Items

    I see how to create a CSV file to import invoices, but it seems to only import a total value. Is it possible to import an invoice with multiple line items?
  • Importing invoices data from Chargebee in Sage 50 CA

    We are using Chargebee to generate our invoices for all recurring customers and we want to import the invoices’ data from Chargebee into Sage 50CA. Any suggestion on how to execute this basic accounting process? Thanks in advance
  • Import batch of similar invoices via Visual Integrator for A/P Invoice Data Entry?

    For context, I tried searching these forums for at least an hour to find an answer on this, but the only active discussions that popped up were 8+ years old. Either I was using the wrong search terms, or this is an uncommon issue. Apologies in advance…
  • Import SIH using Web Services

    Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…
  • Importing Invoices with comments

    I am working on automating invoice generation with Sage, when i create a invoice with .imp file how can i add a comment on the invoice? for example if i sell a perticular item, we often add on a seperate line in the description field a comment like…
  • Using Visual integrator to export invoices, the tax amount field is always empty.

    I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…
  • INVOICING PROGRESSIVE BILLING

    Is there a way to keep track of materials used and labour for a project on excel and export it into sage as a sales invoice? I have been weeks trying to figure out the easiest way to keep track. I could use time slips to keep track of labour but it doesn…
  • All lines have not been distributed - Invoice Import using Interop DLLs

    Hi All, I got the issue while trying to import the Invoice into Sage. I am using BOI Interface with the C# code. I am getting this "All lines have not been distributed." error while importing, Can anyone suggest me to solve this problem? Thanks…
  • Visual Integrator Sales Invoice Import

    We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…
  • Import journal entries

    Based on KB10186 9found on this forum) I made a txt file with the following data: 07-03-15,"338", "Lowland Brewery Inc." 27794,105.00 23100,-5.00 50200,-100.00 I tried to import this file into a trial version of Sage50 (standard sample databasebut…
  • Add payments to invoices added through the SalesJournal?

    I am using the .NET SDK (C#) to export invoices and payments of those invoices from my own database into Sage50. I managed to create invoices (payment type = pay later) in the Sage50 db using the SalesJournal class. I now need to add payments for…
  • .sfm file format

    Does anyone know the file format for Simply's .sfm template files? I need to load it in my solution to make a PDF of an invoice.