Sage 300

Hi Sage City, I work for a company that sells imagery to companies that print and frame, as such our inventory is huge, we have upwards of 50,000 different items. Customers will order upwards of 2000 at a time which means our sales team is forced to…

Hello City Fellows, I encountered an intriguing issue but first some background details: I have SAGE 2012 running on a Windows Server 2008 R2 with SQL Server 2008. On a new server which is Azure virtual machine I got Windows Server 2019 Datacenter…

Can Sage300 order entry be prevented from copying the unshipped lines of an order onto the shipment and thence to the invoice tables, while still retaining backorder quantities on the orders? We have a situation where each order includes many products…

I have all modules converted (OE Tax, GL, AP, AR, IC), but have error when trying to convert OE. There is nothing that indicates what Price List, Item or customer. This is Multicurrency data (CAD, USD, EUR). IC has 6 Price List (3 CAD, 3 USD), ALB, ALBX…

We updated to Sage 300 2021 last week. Since then, the inquiry button next to related documents has disappeared (there used to be a magnifying glass next to, in this example PSH23119 and PINV23119, and I could click on it to open those 2 documents directly…

Is there a way to import an OE credit note without specifying the CRDNUMBER? I'd like the system to assign the next available number so I'm not duplicating and causing an issue with a manually entered one. When trying to import I'm getting an error: …

Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

Hi all, I am making a macro program to insert OE transactions in bulk by reading a csv file with a lot of Order transaction. Some of the Order might have error while trying to insert. So, I need an indicator that this specific transaction failed or…

Hi All, so one of my customer have done a wrong OE transaction, shipment, and invoice. They apply the wrong unit price, and this happen to a lot of transactions (4 days transaction) Is it possible to delete it, and delete it in a bulk? Thank you…

We had someone enter a quote and instead of changing "order type" to a quote, they posted it to an order. Is there a way to reverse this? In the order type field you can chose quote. When selected it doesn't change the order number but will it treat the…

Hi, A customer using Sage 300c v2019. Since a couple of days when primting and then concert to PDF, suddenly not working. No problem in the past. What could be issue. Here I attach video about it. Its in spanish but it shows issue.

Hi Support, One of my clients has raised an issue with OE quotation. Once the quote is posted and printed, it cannot be edited and the post button also diappears. They are using Sage 2018 advance edition. I have tested with Sage premium and this issue…

Does anyone know if there is a maximum number of shipments that can be on a single invoice, or maximum number of lines on a shipment.?

My client is using Sage 300 2019 PU4. Allow Negative Inventory Level in IC setup is NOT selected. Some users are able enter the Qty Committed for an item for example, ‘N0006’ and insert and carry on with the order onto the next order line without…

Dear Team, In the OE while we use the LOT sometime i am getting the below error. Quantity and allocated number for item A1008G/S must be equal. if you are using the web screen, note that Serialized Inventory and Lot Tracking is not available. so must…

Hi All, One of clients had a database connectivity which results with some OE Transactions not transferred to AR Invoice Batch. Further checks also revealed that OE Sales History did not get updated. I reran Day End but no transaction. Does anyone…

After a recent upgrade to Sage 2020 we found that on O/E Forms (Credit/Debit Notes), the drop down box for Document Type selection is disabled for one company and not others, The only option available is for Credit Note printing/reprinting. Why is this…

I have a client that run some sophisticated daily transaction reports from Order Entry Invoices. Occasionally, an order in invoiced a date or two late and it throws off the reporting. Is there an easy way to change the invoice date. I do not need to change…

According to my previous findings the Future Order will be activated when a day end is done on the future day. What happens when we have a future order that pushes the account over its credit limit on that day? Are we able to run a report from Sage…

"First time poster' We are looking for a way to put an Order in Order Entry on hold or in a draft or saved state so that any work in progress can be saved, exited and then returned to later without losing any of the work that was completed. Is anyone…

Our client is running Sage 300 Version 2018 with all service packs installed. I have created a CSV for importing new orders as they do so many every day. The challenge I have is the client want the system to auto create the order number so that all…

Hi All, I have a client who would like to create an order say of 10 items, ship all the items (10) but when it comes to the invoicing, he invoice in bits say he first invoice 5 items and the other items later. I have tried doing this but immediately…

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…

Hello, I need help restricting certain users from being able to alter the salesperson code on the O/E Order Entry level. I have found out how to restrict users from changing this on the A/R Customer level but cannot sort out where to make the change…

Hi all, I'm getting this error after I tried to Post Order Entry via sage 300 web api swagger in json format. the error message is : { "erro r": { "co de" : "InternalServerErro r", "mess age": { " lan g": "en -US", " val ue": "Internal Server E rror…