Sage 300

Hi, I'm preparing for our annual inventory counts and having a valuation issue. When I run the Item Valuation report as of March 31st for a range of account sets and locations it gives me a total for each location. But when I generate the inventory…

Client tracks medical supplies with Lots and expiration dates, which are stocked in bins using Orchid Bin Tracking. They would like to add a few alerts and or processes; for example, when product has X days left before expiration, put it on Quarantine…

We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…

I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish

Sage 300 OE module has 3 units of measure per line. A pricing UOM, invoice UOM and costing UOM. However it does not have a weight UOM, so it is taking the unit weight (which is for the default stocking unit of measure, and not using the conversion factor…

I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…

Hi..I have a question which need advise from the experts here. If the Item is 16.7g per bottle. And every time to use in IC BOM, it required 0.35g. How do I set the Stocking Unit Conversion in the IC Item? As the Conversion Factor not allow to use decimal…

I need your advise on how to use account segment (identification of account segment) even from PO. Let’s make example, a PO was created from Segment Division of 100 (Fakultas Kedokteran). What I wanted is when I receipt goods, the Journal will be Dr Inventory…

Can you make an inventory location the default? We only have one inventory location but must select it or type it in for various transactions. It would be easier if we could default it. Is there a setting somewhere I am missing? Thanks!

Hello, Does anyone know if you can place an inventory item on hold (so it doesn't show as good sellable stock)? We do quality inspections and would like to place the new inventory on hold until the inspections are complete.

How can I get a listing of the inventory Items in a specific location that contains a specific word in the description? For example a want a listing of all item with "Widget" in the Inventory Item Description. HELP???? Our OLD system could have…

Hi - we have been using the Reorder report for years for category 03 with minimum and max = 0 and reorder qty = 5 so we would know when there was an order inhouse since these are on demand only items. Then one day the reorder report stopped producing…

Hi All, I have a kit with a non-stock item in it with an assigned cost (for labor). I'd like to assign a price list code to the kit that is a markup from cost. It's not including the cost I assigned in the kit for the non-stock item. Is there a possible…

An IC shipment was created where the operator accidently removed 51,138,686,093 units from stock. The Shipment appears to have posted but when trying to open the shipment we get a Code: 3.3550.0 Source: IC0630 error. Can I go into the ICSHED table end…

Hi Expert I am middle of a prodect and i am getting stucked. I need to fetch inventory details location or warehouse wise in webapi. In the following way, I am using Request url xxxxxxxx/.../ICItems eq '*KL-ST1-R*' I want the inventory details…

I am having trouble understanding the aged inventory report. See the output of one of the items below. If I just looked at the over 730 days column I would think that I had 602 quantity that was over 730 days old. But in fact I have to look at the other…

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…

Is there anything we should look out for when we change the stocking unit of measure? We some items that have a couple of conversion factors and the items are used in BOMs. To be careful should I issue out all the inventory, change the stocking unit…

I have amended a product name under I/C Items and Price Lists, along with I/C Vendor Details, but the new product name is not showing up in Order Entry like I thought it would. There must be one other place that I have neglected to change. Please…

IC Transfer number skipping a digit, for example after posting a transfer, TRF 0002, the next number generated is TRF 0004! (the image shows transfer no. TRF0005433 is missing the user says that when he posted the system did not give him the option…

I have a client who wants to restrict IC location selection to few locations (Approx 5 locations) on IC Transfer when I try to set criteria on the IC Transfer and select those 5 locations and save it. On the IC Transfer transactions, I can see only the…

I am trying to add inventory items and price lists through the web services API. I can add the inventory item through the ICItems endpoint and I can add the price list code through the ICPriceListCodes endpoint. What I can't find is what endpoint to use…

Using Sage 300 Premium 2018, with Purchasing and Inventory Control modules. The PO Clearing account on the balance sheet has no means of reconciliation or audit report that proves the GL. I need a report that shows PO receipts that reconciles to the…

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Can someone please advise (or provide) where can I find a Template, instructions and key for I/C Adjustments? We are using the Export/Import capabilities as often as possible and I can usually find what I need by exporting a previous item and recreating…