Browse By Tags

  • Importing Sales Orders - Unit Price and Amount are coming in as negative values rather than positive values, and what is the Number of Distributions value used for on a Sales Order?

    I am new to Sage 50 and trying to help this small business to import sales order information. I started by identifying the fields that I thought we needed and then I exported that so that I had everything in the right sequence. I don't see a place when…
  • Importing purchase requistion details from an external csv file into the grid field

    Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…
  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Sage X3 Import Template Processing / Script for Header and Detail

    Hi I am trying to import a sales order using an import template, in the processing I can run some validations and stop the import by setting OK=0 if the validation fails, however it is my requirement that we just drop the one line of the import that…
  • Import journal entries

    Based on KB10186 9found on this forum) I made a txt file with the following data: 07-03-15,"338", "Lowland Brewery Inc." 27794,105.00 23100,-5.00 50200,-100.00 I tried to import this file into a trial version of Sage50 (standard sample databasebut…
  • Export sales order out of sage 50 US Edition?

    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.
  • I want to import inventory item values for the inventory valuation report

    I want to import more than 3,000 inventory item values for the inventory valuation report, that agrees to the G/L. This is a new startup business, therefore the slate is clean at this point. I have entered items with Item.csv and on hand with Adjus.csv…
  • Excel Import additional Account Segments

    Hi, We're using Sage 300 ERP 2012.1 and our chart of accounts includes accounts with one segment, three segments, or four. Currently using the excel import for journal entries, we are only able to import three segments, then if we need the fourth segment…
  • Looking Import specifications for a new MRP software.

    We currently use Sage 300 ERP for financials. Our MRP (Seradex OrderStream) will export daily AR/AP information and we import it into Sage via the appropriate forms Import. Our China facility is also using Sage 300 ERP for financials but they currently…
  • Budget import

    I am trying to import some Analytical budget on my PU8 using the BUD import template. I have an issue with the ACODNUM sequence number table. It is looking for a sequence number even though this is only used on Operating Budgets. The error I had when…
  • 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