Browse By Tags

  • How do you import items into a database?

    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…

  • What is the template I need to use for uploading a bunch of assets from excel to Sage?

    Group, is there a specific upload template I need to use to get my excel spreadsheet assets into Sage? Thanks Sam

  • Permit CSV import files to include purchase invoice transactions with tax code T18 (Postponed VAT Accounting)

    I wish Sage would release an update so that the import of transactions from CSV text file does not fail if it includes non-UK Purchase Invoices under postponed vat accounting (code T18) . The transactions should successfully be imported from the CSV…

  • Allow Negative values when importing a budget .csv

    It seems counter-intuitive that you're not able to import negative values in a Budget .csv file. The workaround (import positive values then manually change them in the front-end) allows for many user errors. This could easily be changed, and would save…

  • P11D v26- issues with data import - skipping records PAYEREF ?

    Just doing P11D data upload and keep encountering same error. Invalid CSV record '1': The mandatory field 'PAYEREF' is missing or has an invalid data type, skipping record... It recognizes the data but SAGE P11D skips all records and doesn't import…

  • Sage 50cloud - Importing a file to pay external workers

    Hello, I am new to sage and our external payroll process is extremely manual and time consuming with room for lots of human error. our process is once our invoices have been transferred to Sage we would move the the invoices and credit, filtering…

  • Importing timesheet information

    Is there any way one can import employee hours into the Cloud Payroll? In the old VIP days, one could capture or import a batch when updating say hours etc? Thanks Blaise Walker

  • PaymentMethod enumeration is not Valid selection error when trying to import CSV bank statement

    Good afternoon Keep getting PaymentMethod enumeration is not Valid selection error when trying to import CSV bank statement. Have redone file, checked that formats and spelling is correct and even used sample file. Still same error

  • Save time by importing data in Sage 50cloud Accounts

    If you have a large amount of data to enter into Sage 50cloud Accounts or you want to make changes to multiple records you can save lots of time by importing the information. This brings all the data into your software in one go, rather than manually…

  • Importing Customers/ Vendors from CSV

    We are returning to Sage 50 after not using the program for a couple years. We had a lot of corruption in our old Company file so we started from scratch on the new one. My question is if I have customers and vendors lists in CVS format, if those lists…

  • A report which can be imported to Barclays.net?

    We have a number of clients who pay us by Direct Debit. Once a month we would input the collection amounts in to Barclays BIB manually and have continued to do this in Barclays.net but a the quantity of customers paying by Direct Debit increases the time…

  • Resolved accidental V/I item import that resulted in hundreds of corrupt records

    Hi, Thought I would post this as an FYI that can hopefully be found if someone searches with a similar issue in future. A client accidentally imported the XLSX version of their spreadsheet into CI_Item instead of their CSV. Normally V/I and the business…

  • Importing in AR Receipts using single line items

    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…

  • Easy way to enter data

    So we usually get orders in a excel spreadsheet and an order might have 40 or 50 items. So to add to an invoice or quote you have to type in each number then quantity. Is there an easier way? The best would be if Sage 50 worked like the rest of windows…

  • I imported all my inventory, but now how to I import opening balances

    Hey Everyone, I'm sure this was answered in the past but I can't find the post, maybe someone can help me out. I have Sage 50 2015 Canadian edition, I imported over 16,000 items (yes, 16,000) as we are moving from DacEasy 9.0 to Sage. All my items are…

  • 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

  • General journal import w/ multiple dates

    can I import a je with multiple dates? or said another way can I import multiple je's (with different dates) in a single csv file? currently it appears that when I try this sage picks up the date from the last line of the csv file and uses that for…

  • Importing Purchase Order Information into MAS90.... almost there

    Trying to import a CSV file into Mas90. Looking to bring in the following.... PO# PO Date Vendor# WarehouseCode ItemCode ItemCodeDesc QtyOrdered UnitCost ExtensionAmt What I have is working perfectly if I import a PO# that has already been entered…

*Community Hub is the new name for Sage City