• Import Inventory Items and Prices

    We have inventory sku and price data that is provided from our vendors everyday in excel format. I would like this fresh inventory data to be imported into Sage. What is the best way to have this imported? Should we update the database tables directly…
  • Period Processing

    Hi All, Have you tried doing clear history in OE Screen, does it delete the Orders or only the Shipment & Invoices only? I tried clearing the history using the transaction history option as of 12/31/2014, invoice are remove but the order is still…
  • Order Confirmation Status

    Hi All, Does anyone know what is the meaning of this Status: When does this status happen? Order Completed List: 5 entries 1 = Incomplete/Not Included 2 = Incomplete/Included 3 = Complete/Not Included …
  • Expiry Date in Lot

    I have large number of lot records which does not have the expiry date entered . and as there is no import function in IC Lot Number screen, is it safe to alter data bases ICXLOT to update the Expiry Date EXPIRYDATE Field through SQL or export and…
  • Item Description not coming

    Hi, In a new company we have loaded all the masters, opening balances, price list etc., In OE module any transaction I open like Order, Shipment Item description is not coming automatically. This looks very strange issue. Only in this company database…
  • Cannot access database (error=49153)

    Only from one workstation getting this error message " Cannot access database (error=49153)". ERP Database setup is server not ODBC. All other machines are connecting without any issue. Only one system is giving this error. And this system has Sage Peachtree…