Sage 100

Hi Forum, Is there a function to Delete records from IM_ItemCost table ?. I cannot find anything to do that. Browse for examples and nothing comes up. Regards, Manuel Roman

Getting this error among all 3 companies when we try to access Customer Maintenance\Items. Also get this error from Item Maintenance\History\Customer Sales History. Have tried renaming links folder, *esc, rebuilding all AR and IM tables. Not sure where…

We've gathered a collection of a few dozen salesperson records that essentially "dead" - meaning there are no open orders/invoices, there are no assigned customers or shipto records, no sales activity at all for years..... and they are starting to get…

A SAGE100 Premium VS. 2020 has occasional missing S/O order header records. The order lines are still there. The order is completely there in order history. The order has NOT been invoiced. Anyone seen this?

Hi I do have a concern with sage 100 V 6.10.2, My inventory item shows 0 item no transactions in there, but when I run the Inventory Stock status report it show a quantity on hand of 384 any idea how to clear that or if there is any program to run…

We have recently upgraded to Sage 100 2020 and one of our companies is noticing a weird issue in Work Order Inquiry. When attempting to open certain work orders, the Work Order Inquiry window closes. However, if we open a different work order and go to…

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

Hi guys We seem to be having an issue with auto reorder. We have ran a rebuild on the modules PO, SO and IM and it didn't seem to solve the issue. See picture below. Any ideas on what my have caused this? Thanks Guys

I am assuming I have a client experiencing this, since they have large negative numbers showing up on certain items which should have On PO qtys of 2,3, etc. The client did have a PO blow up during entry and the items appear to be related, but I can…

After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…

Recently updated Sage 2017 from v5.40.3 to v5.40.4 along with Jobops to resolve an issue that caused us to have to run sort files daily to fix inventory. Does anyone have any inkling as to how to resolve this issue?

A client on 2015.2 Advanced has numerous POs that have status = Backordered, but all lines have qty ordered = qty received = qty invoiced with qty b/o = 0. Somehow, the last transaction didn't cause the PO status to change to Complete. Does anyone know…

Tested in a clean v2018.3 system with ABC data. ' SO header pre-total script retVal = 0 sItemCode = "" Set oLines = oSession.AsObject(oBusObj.Lines) retVal = oLines.MoveFirst() do until oLines.EoF retVal = oLines.GetValue("ItemCode$", sItemCode) if…

We have an odd issue going on with pricing. We have certain customers set up with price levels for specific product lines; most of them are at a price discount or cost markup percentage. A few have special pricing for specific items. When running a report…

Client has been noticing instances where a miscellaneous charge has been appearing in invoice history that were not on the original invoice. The updated invoice appears in paperless office without the extra lines. In invoice history inquiry, the extra…

There is a SO that shows up when the customer runs 'auto-generate' Sales Orders that is a deleted order. It is marked as such in the table, doesn't show up on reports or lookup or anywhere else. The customer doesn't want to invoice it. Ever. But it fails…

Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…

Last night I was doing some maintenance on one of our warehouse (zeroing out product), and noticed a problem I'm not quite sure how to solve for. I found that we have an item in our SQL database (Running Sage 2014 premium) that says we have .014400…

Customer getting this error today when posting one batch - they have not tried to post others as a result. They're running Sage 100 v2014 Premium. I'm guessing it is a corruption of some sort but not sure how to proceed. What is the best way to troubleshoot…

Somehow I have a corrupt Ship/Expire date in the SO_SalesOrderHeader table. I am trying to figure out how to find the bad record but I can't use Crystal to find it because it crashes Crystal and I can't connect via Access either. Any ideas on how to find…

Using Sage 100 2016 (version 5.30.1.0 )Standard. The quantity on Sales Order in inventory is not correct. I tried rebuilding the sort files for Sales Order, but it is not correctly recalculating the quantity on sales order in Inventory Inquiry. Suggestions…

Hello there, I apologize if I am a bit confusing in regards to asking this question. I need to clear out erroneous records related to inventory. I am not sure how to do it. The users noticed an incorrect entry here it is the first record shown, and…

I enter invoices in Sales Order. I entered 50 yesterday and when I looked at them this morning the line detail had disappeared on 24. This happens often.

Computer was interrupted when the purge item history inventory utility was running. Received this error message when attempting to restart the process. Don't see this file in the rebuild key files list. Could someone please point us in the right direction…

My inventory trial balance has items with quantities and values listed for a certain warehouse, but in im_itemwarehouse the quantity for these items is 0. I'm unable to do adjustments, as the report balance is positive, and I cannot enter a value which…