• How To Export a Single Transfer in Inventory Control and Re-Import Using different Items

    I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…
  • Issue with Importing Simple Data

    I am reaching out because I have diligently followed the installation document step by step for importing simple data. However, I encountered an error, as indicated in the attached screenshots.
  • Unable to complete Database Load - Error 59104

    Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.
  • Bank Entry excel file import issue

    When I upload excel file in bank entry module, the file row is broken. All row is not inserted to the bank entry at a same time, some rows are missing when uploading. how can I solve it, can anyone help me.
  • Sage 300 Order entry CSV file import

    Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.
  • import csv order entry

    Can someone please help me build a csv for order entry import? I've tried to export an OE Order but it's too large and keep failing. If anyone has a template or a resource or any other guidance I'd really appreciate it. Thanks!
  • Sage ERP Accpac 6.0A export of PO data

    Hello. I'm working on a project where I need to extract the purchase history from the company's Sage Sql database. According to the documentation located at https://sageaom.kcsvar.com/AOM60/POHSTL.xml the TRANSTYPE of 2 is a Purchase Order. I know…
  • Adding a large amount of new inventory

    We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…
  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • ASERRRPT Error Code

    While uploading a CSV of employees to sage, I got an error code 3.3978.0 I have attached the error report here. I cannot find anything under that error code and the report does not give any direction to fix the issue.
  • Delete unused accounts through an import

    I was wondering if there is a quick way to delete over 1000 accounts quickly, rather than one by one. I am pretty familiar using the import and export feature, however that only allows me to update the accounts, not delete them. Or maybe it does allow…
  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…
  • Ic item pricing discount by

    What field in IC item pricing table determines discount by percentage or by amount?
  • POR Optional Fields

    Good day, I am integrating my data into sage accpac. How ever I get the below error " Purchase Order Line Attempt to change read-only field 'Optional Fields'. " My Question is how do I change Optional Fields to be not read only? Regar…
  • Updating price list item descriptions from inventory item descriptions

    Hi, I would like to update the item descriptions on all price lists to match the item descriptions in the regular I/C Items file. If I were comfortable in MS SQL I'm sure it's not difficult to do there. But I believe it can also be done by exporting…
  • BKENTD LINE field keep updating every update

    Hi all, I am doing customization on Bank Entry Screen using ISV module called Extender. But that is not the problem. I notice that, on the Bank entry grid, every time I add new line, the LINE value will auto decrement -1,-2,-3. if I remove -2, and…
  • Document in customer inquiry that needs deletion

    Hello, we have an old invoice that shows in the documents tab. This invoice was originally imported when we switched to 300. We are not been able to credit it. In which table is this information stored? The invoice does not show on OE invoices, only…
  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    Good day, I am trying to export data from my local sql DB in sage. I am new to sage integration, so i have narrow knowledge on this subject matter. When i inserting InsertInvoiceDetailSoftCols() i get an exception "Error HRESULT E_FAIL has been…
  • PORCP1headerFields.FieldByName("RCPHSEQ").SetValue("0", false) || Returns "Object reference not set to an instance of an object"

    Good day, Please assist, I have C# code to export data from my local DB to Sage. When inserting invoice headers I get "Object reference not set to an instance of an object" I am fairly new to project and Never worked on sage before. I have a very…
  • BOMs

    Hi, we use Autosimply for production processing. We need to export all BOMs to review the configurations. Which table do we need to access for that information? Thanks.
  • Bank Import File

    This is the file I am using to Import bank statements to reconcile our postings on Sage. The entry does not reconcile, I have tried everything please help and let me know what I am missing on this Excel sheet to complete the reconcilition. This file…
  • Bank Import Error

    Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?
  • Importing Bank Statements to Reconcile Bank Account

    Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…
  • GL import into Sage error

    Hi, I have attached 2 excel files - poextract & A_PO_Receipt_Template Both files have the same data but one does not import into sage and the other imports fine. poextract - does not import - sage gives an error saying "Table_headers not recognised…
  • Best forum for posting database table questions?

    Hello, I am using tableau to visualise our Sage 300 data. As I have had (and will have) quote a couple of questions around database tables, and how they fit together, I'd like to be sure of the fourm I should be posting to. Out of the list here ,…