Sage 300

It may have been lack of training, or situational awareness that caused this mess. Our office manager didn't notice/or react and now two years later we have a bunch of open PO receipts. We chased down the issue to the invoices from the Vendors being…

Is there a way to adjust the cost of an item without adjusting a lot. It seems the cost of the item is different than the cost of the lot. The lot cost is correct, but when we go to adjust the item we have to select a lot also. Or can we adjust the cost…

Hi friends I am unable to ignore tax on freight. For example : suppose I have an order with Items Subtotal = 7000 Miscellaneous Charges Total = 200 Less Order Discount = 500 Plus Excluded Tax = 1340 Plus Excluded Tax is applied on "Miscellaneous…

We use different online marketplaces and they charge a commission/fee to us for selling products through their website. How can I build this into Order Entry, such that the commission/fee is included in the cost of order/item. Ex. debit inv/cogs, credit…

Hi, have an issue need to solve immediately. This is the situation. We have created one MO with exp. 1000 pcs, the quantity produce 800 pcs immediately send to customer via OE before closing Manufacturing Order. When another 200 pcs completed and entered…

We are having an issue where items aren't showing as on S/O for a specific customer. Other customers work fine. The customer account is not on hold or inactive. The orders are not on hold and are active orders. Any ideas? Sage 300 2017 PU5

When entering a purchase order receipt the tax amount that was calculated included tax on the shipping amount. That was incorrect because the vendor did not tax the shipping. How do I make a tax adjustment? Do I have to reverse the entire receipt and…

Client is using Sage 300 v 2014 / SQL Server 2012 / Server 2012. Issue concerns US PR and PJC. Each employee's union benefits are set up in the Employee Pay setup with "Jobs Allocated Based on Calc Base". This works great when the employee works on…

We recently did a physical count in inventory and most of the items did a both update (quantity and cost), but two items did quantity only updates. How do we make sure that all items are doing a both update?

Is there a way to change Lot Costs? I Have many Lots with incorrect costs and incorrect AVG cost, and it does not match with ICILOC AVG cost. I read one post which it advice to edit the ICXLOT table. BUT I ma not in favor for manually editing any…

Recently (as in past couple of weeks), a user is having problems in BOM maintenance. They remove a line (component) from the BOM, and add another one in its place. (They do NOT change the BOM number). They save the BOM. When they go back to the BOM…

I have a PO for a quantity of 100. An invoice was received against this PO for a quantity of 25. The next day, we were told the invoice was billed in error and to reverse it. So, a PO Return was entered against this PO Receipt returning a quantity of…

Hi Everyone, I have an order that has been "shipped" but not invoiced and I want to reduce the shipment by one, putting the serialized item back into stock. How do I do this? Thanks David

Customer created an item, used it for a while, then realized they should not have done so. Trying to delete it via the Item master maintenance gives us an error "unit of measure is in use in receipt details and cannot be deleted". I'm not sure what…

What is the best way to create a credit memo, when a customer returns something and requires than you pay the return shipping. Example: An order is shipped that is $100 plus $10 for shipping. The customer returns the order and is expecting a credit…

Hi, I'm using Accpac 6.2. I have an item which shows qty on PO under location details but no details are shown when drilling down on the item. Pending Receitps inquiry for this item shows nothing outstanding also. Can I just change Qty on PO to zero…

Sorry if this is a duplicate posting - I may have hit the wrong button when previously entering. I have a client who recently converted to Sage 300. They implemented Inventory Control with FIFO for all items, even those that are serialized. Is there any…

Using: Payroll 7.0 with Sage ERP 300 2012 Hello, We recently started a new payroll and the YTD amounts for USSS (Social Security) were not brought over. This caused us to deduct USSS amounts from employees that were already maxed out on their deductions…

Some of the costs(average cost) are showing negative on Adjustement...I will like to know what I am doing wrong to show this and what can be done to correct it,also what to avoid to avoid next occurrence...Thanks

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.

Hi there, Our client has an issue regarding job-related O/E Shipment. After posing a job-related shipment, user noticed that unit price was wrongly entered. As the shipment is job-related, any fields in this screen are not editable anymore. Do…

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

Hi, An additional cost was missed while making PO- Receipt and Invoice also posted. How to add the additional cost now? It's important to update the missed additional cost to the same document with 'cost proration' method. Pls help.

We are new to Sage 300 and are trying to write processes for our Project Managers and Estimator. Is there anyone that could share their Job Cost Variance review and approval processes and estimating processes etc I know it is a lot to ask, but any information…

Hello All, Does anyone know how (without going through SQL) to modify the columns "Quantity for Costing" under the lot tracking module? IC Lot Reconciliation and IC Adjustments merely affect the "quantity shippable". We're trying to modify the "quantity…