• Disable Segmented Inventory

    I'd like to disable segmented inventory in our sage 200 evolution installation. Does anyone have a guide for disabling, and removing the tables?
  • How to merge inventory items in Sage 200 evolution

    Hi there, I trust you are well. I am facing an inventory issue, whereby multiple entries of the same item have been added to inventory, with differing simple codes, but are the same item in the real world. I need to merge these items under one simple…
  • SPE07 & SPE01 ERROR: PROCESSING PURCHASE ORDER INVOICE

    I already tried changing region date, decimal sign and date format, yet it's still not working as it should, please assist.
  • SQL Query to find what Group a Stock Item belongs to

    Hi there, I was wondering if someone could point me in the right direction perhaps please? so I am trying to find out what group a stock item (inventory item) belongs. SELECT * FROM StkItem WHERE Code = <code> SELECT * FROM _btblInvoiceLineDetails…
  • Warehouse Inventory not showing up in WhseStk table Evo 10.1.3.005

    When I create a new item in Inventory warehouse items it doesn't show up in the WhseStk table. The item shows in the GUI when I create it but when I exit the Inventory Warehouse Items screen and go back it is not there anymore
  • Entering of Opening Balances

    Hello House, Please what is the procedure to enter opening balances for the followings after creating a new company in Sage 200 Evolution. General Ledger Accounts Inventories Customers Suppliers Bank Accounts Any assistance will be…
  • Update Inventory Item Costs

    Hi There, Slight Background: We currently operate on an Average Cost Valuation Method within SAGE 200, With that being said, we are also within the manufacturing industry and thus, once a manufacturing Process Order is closed, A finished product …
  • SAGE 200 Diagnostic Tool

    Hi all, SAGE Evolution Version 10. There is a small issue with the diagnostic tool, Inventory, Transactional Quantities. The script does not provide for warehouse quantities. If you need to run the script, use the on below directly in MS SQL Management…
  • Set a Pricelist order for all Inventory Items

    Hi there, I just wanted to find out if it possible to set the pricing of all inventory items to be in a specific order. Looking at the screenshots below, we are using three pricelists, however the pricing order for the items are not the same. I'd like…
  • Valuation by date

    Good day, I am failing to find the Valuation by date Enquiry under the Inventory, and this is only on one backup/client, the rest of the backups are fine and can run the Valuation By Date. I also check the dll file in the directory and it is there…
  • Sage 200 lot tracking

    Goeie more julle, Ek wil graag julle verneem wie gebruik lot tracking om workflow te bespreek. Ek ondervind dit as uitdagend. Ons vloei tans: Purchase orders word gegenereers. Bv 10 000 units Sodra voorraad arriveer word PO gelink met GRV…
  • Stock Cost Variance Posting

    Good day everyone. I have a client on Version 7.10.0.86. The issue they are faced with is incorrect postings to the Stock Cost Variance GL Account. This only occurs when an RTS is posted, for local or import suppliers. I have checked Transaction…
  • Inventory optimization not pulling re-order template

    I am trying to process a re-order process but every time I open the template within the re-order transaction process the template doesn't open and there is no error message. what could be the course and what solutions can I apply? Thanks. Regards…
  • Sync Sage Evolution to Shopify for stock control

    Hi, if anyone can assist I would be truly grateful! I represent a Digital Ad Agency (OMMO Digital) and we're in the process of launching a Shopify online store for one of our Food Manufacturing clients. My question is, can one sync the stock control between…
  • Inventory Issue V10.1.3 and Job Costing

    When you link inventory issue to a JOB Card, the system is throwing an error (the conversion of a datetime data type to a smalldatetime data typeresulted in an out of range value. The statement has been terminated) . I have tested all Versions of V10…
  • User Access Rights - Cost Price

    Could someone please assist me with setting the correct User Rights so that general employees may not see the Cost Price of items. I have disabled the Display Inventory Cost, however the Item Cost is still displaying under the price lists. Thank you…
  • Cost Price

    How can set cost price automatically in a purchase order in order entry Module?
  • Items Group - Override Transaction Type GL Accounts

    Hi I am creating a Group of service items in order to override Transaction Type IN (invoice) default general accounts for Debit/Credit. I did the following: - created the Group "Service CEB Utility" - created a service item "ELEC001" - Put ELEC001…
  • Inventory SO Qty issue (Sage Evo 100)

    Good Day All So firstly I do not know what section to post my question in so here I go We linked our Sage Evo 100 with our new website that was developed so it will show available stock for sale, but we are having an issue currently Say I…
  • Imported Inventory Journal Batch does not post

    Hi I am having a challenge with Inventory Journal Batches on Sage Evolution. If a batch is imported and you try to post the Batch, it validates without any errors, but it does not post. If you do the same batch manually, it will post. I also exported…
  • How to generate a report showing sales orders not processed yet?

    Hi there We are trying to correct stock levels on our system but before we do that, we need to remove old Sales orders (which we used to generate pro-forma invoices using a design template we created). There are a lot that was never processed to an…
  • Inventory listing report vs slow movers report

    Hello again I am trying to pull a report of dead stock in our warehouse as we want to move those out to another physical warehouse to make space in our headoffice one. As I understand it, I can pull a report of Slow Movers. I set the setting to show…
  • Sage Evo 100 Inventory Issue

    Good Day Everyone We started using Sage 100 end March for our company and it been a wild ride to set up everything. We have managed to get the system in full working order, but I have run into a problem. We wanted to start running sales reports…