I am having an issue with inventory reports not matching, and showing false negative quantities. The inventory quantity report will sometimes show negative Pending Sales Order quantities, and currently I am seeing negative quantities for some items only…
Hello Sage Community,
Todays question is how to find order(s) in shipping that I cant find! In the image below, I have the part in Shipping and cannot find it!! I've reviewed numerous orders and shipping batches that are not updated yet, they are nowhere…
We are on the updated Sage Businessvision 2023 edition, but we have been experiencing an unusual problem in the past few months.
Random items will show items as "back-ordered" despite there being no outstanding sales orders. That, or the back-ordered…
I am trying to apply the Sage 2020.1 update. During the update, when it scans for corruption it says that PL_JournalPDFLog.M4T has an ambiguous "file discrepancy" in it. The instructions say to simply Rebuild Key Files for any discrepancies, but alas…
Hello,
I was wondering if anyone else ran across this issue and if so, how it was resolved.
We have identical item numbers that appear when we search for an item in item inquiry and item maintenance. Selecting one of the item numbers results in…
Has anyone found a company that can dig deep into a Sage 50 data file to uncover and repair issues. Our file has countless issues now e.g. different inventory numbers for the same item in the same location depending on what report you run and who runs…
We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog:
When I click More…
Hi,
Inventory count on some items have gone to zero, like they disappeared from the database. There haven't been any activity on these items to explain this. I attached a inventory unit activity reports on one these items as an example.
Has anybody…
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…
Am gettingthe below errors
What might cause this to happen?
Wjhat can i do to fix this?
Purchase Order Line: PO0311816, 10, 700511-IRGP E: Item number does not exist. E: Unit of measure EA does not exist. Purchase Order Line: PO0311816, 14, 9533266…
Can somebody take a look at their database, and verify the following?
I'm on Sage 500 2016 January 2018 MU (i.e. 7.70.6.0). tciCarton contains CartonKey, but it is NOT a primary key, nor are any constraints.
As a result, I've got a few duplicate…
Hi Everyone :),
First time here so please go easy on me.
I am in charge of IT at this institute and yesterday my CFO called me and said that the accountants told her about a wrong entry that has been made couple of years back (3).
the entry is…
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…
I am trying to support a client running Timeslips 2006 (I know, I know), and he is received error messages when opening the program: "your database has an error in an index file. This is not dangerous to your data and can be easily corrected"...and so…
Year end is always a pain but this year upgrading from 15 to 16 I have trouble upgrading files in Inventory. The error is Field 'useunits' must have a value. So somewhere in the Inventory database the default value for "useunits" has not established or…
I have a client who I just started with. They are seeing lots of issues which look like bad data corruption. The previous guy recommended they reboot the server whenever things hung up, so I think whole batches of data have been lost. BW still functions…
When I tried to build something in the assembly it showed a -1 quantity but when I look at the inventory it shows 0 quantity. I noticed this in several "assembly" items & it started about a week ago.
Will running an integrity check clear this up? If…
While trying to restore a SQL server backup for one of our Sage databases, the process returned a restore error. Upon research i found out that the DB may have been corrupted. What can be done to recover from this?
Priti
Sage 300 v2014
I have a situation where there is a gap in the I/C Adjustment Numbering and therefore can no longer drill down on their details from the I/C Adjustment Function. However, all postings to GL are correct and I/C Stock Transactions report…
Sage 100 v 4.4 I ran the utility Recalculate Item History and now the inventory values are wrong. There are values where there is no inventory and some that are just completely wrong. Now the Inventory Module will not balance to the G/L and it's about…
We're currently on Sage 100 2014 (Non SQL) and we're currently running into the issues where we are being sent names containing certain ranges of extended ascii characters.
For now, we are going to limit ourselves to the first 127 in the ascii table…
Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date.
Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9"…
I need to download the HF22031340 for version 2014 to fix the good 'ol "the sum of ICIVAL.STKQTY for item XXX doesn't match ICILOC.QTYONHAND". It is listed on the partner portal but not in Sage City's list of hot fixes. The problem is when I try to download…
Once every 1-2 weeks I rebuild all sort files and am wondering if I should also be rebuilding the key files? Is there any risk/downside to rebuilding the key files? Also, when I am running the utility do I want Integrity Check and Optimize File checked…
Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered.
Is this normal?
I can import…
