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…
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…
I am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?
What is the best way to export then import Quotes, Invoices, and PO's? I looked in the Import/Export menu but could not find anything corresponding to these three categories.
I want to import items into an O/E quotation.
I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in…
Hi all,
I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…
Hi all and glad to be here.
I am using Sage50 to keep track of accounting that needs to be imported using QB CSV files. I don't know if there is an easier way but I finally resorted to exporting Sage files to then populate using the QB data (hopefully…
Hi everyone,
I'm using Sage 100 ERP 2013 and I'd like to remove the price overrides for about 10 specific customers. The customers have customer numbers that aren't sequential, but are scattered, in case that matters.
I want to do this in a safe,…
I need to clean up our vendor database and would like to run an export, make my changes and then import those changes back into BW. I have looked at the articles available for vendor import, but they do not address any changes in status. I have over 500…
I am trying to update a journal entry, that has wrong date to the right dates. When I export the information and change the information and re import the file, its giving me an error that the record already exist.
I am using the JAS2 Template, I am…
I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…
Even when the code are ok it ask for confirmation (the correct item is selected) for each detail line. Is there anyway to avoid this confirmation and import the invoice without confirmation ? Thank you
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…
Can someone please advise on the best method to import a sales invoice. Is the .imp specification the only way to import into Sage 50 - 2017 Canadian? Is there an excel template that I can map my excel data to and then save as a .CSV for importing into…
We have been importing Journal Entries for year through the GL Import, however we decided to begin to import more Journal Entries to save time. Currently when we are importing the system will assign a Journal Number to it but it there a way for us to…
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…
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…
I'm trying to import sales invoices using the .imp format but I'm confused about how I should be importing the tax.
The sales invoices I'm trying to import are for a shipping order so my information is as follows:
Order No: 6000
Invoice No:6000…
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.
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…
How do i export sales /purchase order out of sage 50 US edition? I have done this with sage 100 using visual integrator and i am in need to do that with sage 50.
Does anyone have any recent experience with this. Bill.Com's synch tool is going dark 8/15/16. Fortunately Bill.Com's export functionality is a lot more flexible - but we know we need it to align properly/be set-up properly to import to Sage 50.
I know how to import into AR Receipts in Sage 300.
Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…
Hi,
I am having a hard time importing transaction on AR module, this notif. keeps on prompting while i keep on trying. I have searched some trouble shoot for this but still I can't proceed to what I am doing.
Any help? Please!
Thanks,
B…
