• item at location does not match the sum of the lot quantities on order

    We have a customer that has recently upgraded to Sage 300 2021. They encountered this problem entering a sales shipment and trying to apply Lot Numbers to it. Although there was sufficient quantity available if they looked in either location details or…
  • Item Invalid characters put to field 'Item Number'.

    Description: Item Invalid characters put to field 'Item Number'. Source: 22:05:05 I know that I have an invalid character added to the item number field as a result of using Item Number Change Utility. How do I find these items? I am lost. Just FYI…
  • anybody seen messages like this dayend IC from PJC

    IC Shipment from PJC Mat Usage Day End posting error I know the line/item number it is sick on Transaction Number cannot be blank Transref should not be zero, should be Transnum
  • Error during retrieve from Sage 300 to Sales Analysis

    During an end of month retrieve into SA the client is getting the following error message: [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert duplicate key row in object 'dbo.UXARINVHO' with unique index 'UXARINVHO_idx0'. The duplicate…
  • Uncosted transaction fields are not zero integrity message - cause?

    We have a fairly new install who can't delete location records. Based on other info from here in Sage City, we ran the data integrity checker and found a number of "Uncosted transaction fields are not zero" errors. We'll re-run the integrity checker…
  • unable to download HF21031340 Sage 300 ERP 2014

    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…
  • Day End error 6.0 "Internal error. qtysub failed (2724 POPORZ1.C)"

    Received day end error "Internal error. qtysub failed (2724 POPORZ1.C)". Restored all items from backup as instructed in ID 27409 and no luck. I did run RVSpy and there is an error at the end but it is not helpful to me. RvSpy error is: [d78.7ff…
  • Tax information on OE missing - Detail section disappears

    I had to make a new post because someone else had this question yet marked it as answered even though there was no answer which makes all the emails stop. In order entry, we are having some orders drop the tax grid information. This then pushes into…
  • Error When attempting to open Sales Orders in one compnay

    This is the error I receive. View 'OE0520' is not a valid View ID. I went back to my client and did a database dump and load into my system and I still get the error. Any ideas?
  • Order Entry Negative Subtotal with NO Line Items...

    Hi All, Has anyone experienced (and hopefully resolved) an issue where an order in OE shows a negative subtotal despite having only positive quantities and unit prices (resulting in positive extended priced lines). Sage 300 (v2014, pu 1) is also allowing…
  • PJC does not respond when user tries to delete a Contract. Contract in estimated State and has no Projects

    I am investigating a situation where PJC does not respond when a user tries to delete a Contract. This is what happens: user clicks the delete button.. Message comes up that says Checking to see if Contract can be deleted. > Progress bar appears. >…
  • IC Item Qty on hand error

    Hi, For a particular item while posting PO- Receipt transaction getting this below error Description: Internal error. cstp xIFO iloc mismatch error (2559 ICCSTP1.C). Source: 17:26:01 I ran data integrity it gave me this error for that item, Location…