Browse By Tags

  • Needing to correct an error made in previous year after entering 2 months of data in our new year

    FormerMember
    FormerMember
    We have completed our year end, moved our systems forward, entered about 2 1/2 months of data into our new year. After this we found we had an error at the end of our previous year that has to be corrected. We went back and corrected the error in the…

  • OE import error "Negative Inventory Levels"

    Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…

  • The values of "Category" in timecard import sheets

    Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

  • Is it possible to import employee pay into Sage using the SDK?

    Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    Hi, I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…

  • What is the process to create Purchase Orders or Sales Orders via uploading a .csv file?

    I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.

  • Import data into Sage 300 using ACCPAC .Net APIs.

    Hi All, I am new for ACCPAC .Net APIs, I want to import customer data into Sage 300 using APIs, can anyone help or give me some hint for this? Or share some sample code and data dictionary, please? Thanks for your help

  • loading data error

    Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

  • Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

    I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…

  • How can I export any/all the email addresses in paperless office?

    I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

  • How to enter search criteria for Blank Fields

    Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

  • Product numbers

    Hello! Our legacy data includes special characters and odd formatting for part numbers that I guess we made up along the way and I want to standardise them. Is there a way to wholesale change part numbers where, for example: export part numbers…

  • Timeslips could not find the expected record when using transport.xfr

    Timeslips 2012 When using transport.xfr I get the following error message. I tried a DATA VERIFICATION on both machines and have NO errors. I can exchange clients and professionals but NOT tasks or expenses - tried each separately. Any help would…

  • Mass change of inventory item numbers, while keeping old number for reference?

    Hi, My company is looking to completely overhaul its inventory numbering system, meaning that 1000+ inventory items are going to be receiving brand new numbers in our system. We want to still have the old part numbers on record as we will have to be…

  • Vendor Price Lists

    Hello, Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory? Thanks, Dave

  • Vendor Selling Price Upload Question

    Hello, would like some help/advice. We uploaded a vendor selling price file into BV and there were about 8000 parts. We later found out we only use 1000 of the parts therefore the system updated 7000 additional parts. Is there an easy way to delete…

  • Error Message During Delete Process

    Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

  • Identify the real cost of a FIFO item

    We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…

  • Still Having VI Importing Issue

    Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…

*Community Hub is the new name for Sage City