Browse By Tags

We are seeking to use ICIVAL to run a retrospective Inventory Valuation report (to agree with the GL control account for Inventory). Usually I would expect the "last" transaction in table ICIVAL for a particular [ITEM]-[LOCATION] to have the highest value…

Today we dayend error "Description: Cannot read OESHCDL (3950 OEPOSTS1.C)." How to solve this? manas@up

Hi Team Having a bit of a problem with the day end for customers that do not have IC module, on the normal desktop the day end then sit on Purchase orders how ever the web interface do not have the day end on PO. The admin must log on to the server…

Is it possible to setup pricing with Sage where there would be a discount based on the quantity. We are looking for a way for this to be done in Sage: to setup pricing for the first item to be free and then the next item a price needs to be paid.

ICBOM01.rpt gives connector error when processing CSV file made by ICCOMP.DLL V2020 I get no error if I suppress the sub-report so I know it is that sub-report showing BOM details Error happens on server with O365 and another server with no Office installed…

When we are using costing item on Inventory Control module, Day End Process or During Posting. Then we have Audit result and doing Adjustment backdate, ex. current period Nov 2023 (many issued/internal usages Item from Jan to Oct), we input IC Adjustment…

We use Sage 300 2022 PU2, and Costing setup Inventory Control is During Posting (not Day End Process). We have done Adjustment Cost (IC Adjustment --> Cost Increase) for date 31 Dec 2022, after that we do issue (internal usage) for 24 Aug 2023. But the…

When adding an item to a BOM using the web screens (Sage 300 2023.1) I get " Item number does not exist" error. Sometimes with the master item and always with the component item. I also notice that the UOM does not show in the UOM finder on the BOM either…

While looking over the recipe for an error in a large multilevel BOM I noticed a interesting issue. The Sub BOM's Default numbers have been changed but that doesn't seem to be reflected throughout the Master BOM recipe. Is there a way for the Build of…

A client uses the inquiry screen called Optimize Inventory under IC Items & Price Lists. As more and more users at that company become familiar with that screen, they want to use it -- but they've found that only one person can be in at a time. Is this…

Does Sage 300 provide a barcode system or inventory management system that works with Sage products? When we first took on Sage (It was Timberline back then) they did not provide a warehouse management system. Has that changed in the last twenty-five…

After upgrading to 2022 Sage 300 item number change is sunning extremely slow. Changing one item number was taking 2-3 hours in 2019 and now it would take close to 20 hours. Item valuation is taking forever, my guess is close to 18 hours. Hardware is…

We are running Sage 2018 (Build 30) (Product Update 3) - IC65A Inventory Control. A User posted a Stock Transfer transaction from Location AAA to Location YYY for stock item 123456. Then, before I/C Day end processing done, the User removed the Picking…

Good day I am seeking an add on to Sage in which an inventory BOM runs on raw material when a finished product is invoiced out. Is there such an add on available? Thanking you in advance Nadine

Hi, If we receive an item to an existing Lot, Why the stock date and Expiry dates are not updating automatically to the date of PO Receipt. ? This will make an issue of Auto-allocation in OE, system will take this Lot ,even it contains the latest…

We're just going up on Sage 300 to control inventory, in a manufacturing environment. We have 1 central stocking location for bulk supply inventory parts, and a factory floor in close proximity. The plan is to periodically move 2 week's worth of inventory…

Hi All, I was wondering if anyone has used any 3rd party inventory solutions with BW. We find that the inventory module isn't quite doing enough for us and are constantly forecasting/managing inventory levels using excel via an ODBC connection to be…

We have an opportunity to sell Sage 300 to a distributor that supplies Chinese restaurants. They want items to have English and Chinese descriptions. When I try to insert Chinese characters into the item description it shows up as ???? when I save. Any…

I recently joined a company using Sage 300, and I've been trying to get their system working. In the past, they used generic item numbers on purchase orders (i.e. BATHHARDWARE1), so their inventory counts were useless because many items shared the same…

Hey Everyone, Rather new to Sage here, but trying to determine if there is a way to setup multiple Bin/Location fields in BW SP8. I reached out to Live Chat, they setup a call later since they couldn't figure it out. I am trying to have 2 or 3 Bin/Locations…

My client did an inventory transfer and most items worked fine, but one item only transferred 1479 lbs of the 1488 requested to be transferred. 9 lbs remains outstanding. They have run day end processing, All the other lines show as complete, but that…

I am looking at loading lead time days in the location detials screen onder the "Lead Time (SIA)" field. is this asking for calendar days or business days?

Hello, Which is the correct procedure of comparing current Inventory value with General ledger? Item valuation by ''Transaction cost'' is matching with GL. But, ''Location details cost'' not matching with GL.

My SAGE 300 is setup the way every time we enter receipt it will update vendor cost in Vendor Details. In general this is fine but lately we experiencing problem where PO’s are delivered after 3-4 moths and price is changing frequently, so old PO will…

Is there a way to adjust a BOM during a transaction. My client has a BOM that can use substitute materials. We are creating versions of the BOM for normal customizations, like using 50% of one material and 50% of the other, but they can make many versions…