Sage 300

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…

The product has an odd number of quantity on S/O. There shouldn’t be any decimals in this field because all quantities listed in S/O should be for each.

Hi, May I know what is the maximum number of lines can be entered in O/E Shipment Entry? One of our client requested to do import into O/E Shipment Entry with big volume of data. Is it possible to import 20,000 lines of data into O/E Shipment Entry…

Where can I find the last date of sale for particular item or items?

A credit card payment was entered, posted to the correct customer, but to the wrong invoice. Is there a way to fix this. We attempted to reverse the entry, but since it was made with Sage Payment Solutions this was not allowed.

When the terms are credit card all orders in order entry should be pre authorized. Is there a way to find orders that should have a pre authorization and do not?

If I enter an order in OE and enter a prepayment and post the order, when I later invoice the order the prepayment is not shown against the invoice, but only on the right hand side of the invoice totals as an order prepayment. If I enter the prepayment…

After a clean install of PU3 we can't run Sales Analysis. Interesting because in the release notes it states that they've included the fix. So, with the Hotfix described in KB20225 - is it safe to apply it to PU3?

We are doing a bank rec and the amount of deposits outstanding is incorrect. When we take a look at the outstanding deposits they are only $13,000, but the report shows $41,000. The outstanding checks are correct. Any ideas?

How do I see the activity for miscellaneous freight charges in order entry? The only report I see just lists the set-up information for miscellaneous charges.

How do you create a report to show the sales for a national account if the customer numbers are not contiguous?

Hi The company I work for is using Sage 300 ERP 2014 PU2 Order Entry (OE) with active credit limit on customers. I face a problem when I create an invoice for multiple shipments, as below sample: Credit Limit : 200,000 OE Pending Balance: 150,000 (consist…

We just turned on the portal for one of my clients and when we attempt to use the inquiry feature to see the OE invoices we get errors for all the criteria. When we select the invoice date, we cannot select a time period because all we get is ERROR.

When attempting to import inventory records we get an error "Category Cannot Be Blank" We have an entry in the category field. We even updated the inventory record with the value manually and then again attempted to import and we still get the error.…

How do you change the Sage Intelligence Report for the top 5 customers? I may want the top 10 or top 20, or even left the customer enter the number they would like to see.

How do you fix a customer check that has been applied to the wrong invoice.

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?

Where is the vendor item number stored for purchase orders?

Greetings! Is the AUDTTIME field in say, APIBH, a datetime datatype field? I get a "Arithmetic overflow error converting expression to data type datetime" when trying to convert to local time.

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…

Day End Processing won't complete and it doesn't tell me why. I'm not sure how I can fix the problem if I don't know what the problem is. All I get are these two screens: Is there someplace to find a list of Day End Processing Errors?

I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…

Hello, I just start to work for a mining company with some Capex expenditure. I use Sage 300 and has Project & Job Costing module but not use it now. I did not familiar with the PJC. But per my ERP experience of other software, i think Capex expenditure…

Hello, in my company's PO, It contains quantity ordered, & unit of measure,& unit cost. I also read a column named" extended cost" and net of tax, is that the place to add some surcharge, for example environment charge? if the PO was partially received…

Hello, I uses Sage 300, 2014 and like to get the information about Purchase Order amount issued and how much is delivered or received for a specific time period. i tried in the Purchase Action report both for Summary & Details. in the summary spreadsheet…