Sage 300

Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…

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…

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 everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…

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 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?

Our company started using item structures and segment codes around 3 years ago and it is simply not working for the type of business we do. Currently we use the hyphen as a segment separator. We would like to go back to using the vendors item number as…

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…

I am producing steel pipe (item 2) from a coil of steel (item 1). for example an 8000 kg steel coil produces 1200 - 6 foot pipes and 34 kgs of waste steel. How do I deal with the scrap steel?

Client migrating to new server, Winsows 2019 with Sage 300 2020. Existing server is Windows server 2008, running Sage 300 2016. On the old existing server, Sage uses Windows authentication for many users. On the new server, when I try to change the…

I changed item numbers for ten of the items using item number change utility. It went through successfully. However, I am unable to find three of the items. I do know that these items exist in Sage but I can not use these items. When I scroll through…

Is there a way to disable the forcing of capital letters in the PO no. field within order entry? We have a partner who sends us PO numbers that contain both capital and lowercase letters. When we transmit through EDI back to them the information is…

Hi, The OE shipment entry is not generating GL entries if the invoice tick box is unselected. If Invoice option got selected, then invoice entry and GL entries are being posted to respective modules. How do I set the system to allow to post the GL entry…

Hello, Our company is a food distributor to supermarkets/retailers. We currently sell our items per case and that is our OUM. We want to start selling on Amazon but for this, our UOM has to be an actual unit and not case. Is there anyway that we can…

Our client runs Sage 300 Version 2016 and have multi locations where they sell from. They want Orders, Shipments and Invoices to have different prefixes as per the locations they are sold from. Is this achievable? All responses will be highly appreciated…

I deployed Sage 300 2016 Web Deployment and were able to login from client computers without "Enable Application Security" box being enabled in Database Setup Utility. However, after enabling this option, I started getting the warning message "Session…

Can anyone explain to me what happened after an item 0001 merged into item 0002 ? What happened to item 0001 old receipt, PO etc? After clicking the POST button in Item Number Change, a message box pop up to ask back up database, is that normal? Thank…

Hi there, Our accountant has raised a query about the Inventory control category code setup. By default, the category is used to group items together and assign sales and COGS account. Is there any other purpose for the category code? Can it also…

Hi All, Does anyone know or can tell from which screen in sage the alternate item is usable? can it be use in order entry where you can easily substitute the alternate item when the original item has no stock? Thanks