Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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.
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.
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.
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!
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…
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…
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…
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.
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…
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)
------…
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…
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…
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…
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…
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…
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…
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.
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…
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 ?
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…
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…
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 ,…