Sage 300

Is there a way to do the following without an IC transfer from Loc W to selling loc? Item A is received into Loc W but sold from multiple locations and they want the GL segment code to override depending of the location it is sold/shipped from ie Item…

What is the most common way of tracking OT on projects using timecards? When the PJC timecard is entered there is only one default hourly rate for the employee. When the timecard is sent to payroll the OT is calculated accordingly. How can we capture…

What is the use of Unit Cost Column in I/C Kitting Items Screen? For me it always remains empty.

Hi, Where does Sage pull the information for this field? Thanks.

Hi We have a client who is running Sage 300 2021 Pu2. They recently upgraded and are experiencing issues with Inventory control and Lot Tracking. Posting here as advance warning to other BPs intending to upgrade. MAKE SURE YOU TEST TO SEE IF YOU ARE…

Is there any way to have qty committed to order and have 0 value in back-order? We are trying to manage our back-orders but it doesn't make sense to put qty committed, same as back-order qty if stock is available? ideally we would like to commit to stock…

We now have certain items in our inventory that are non taxable. How do I set up a non taxable item in IC while not effecting other taxable items on an OE order?

When i do a materials return in PJC it is using the Most recent cost instead of the Average cost set on that item. Is there something that am doing wrong or a setting that i should change in PJC? Sage 300 2020

Sage 300 2019 PU2 + UP73A PU18 + UT73G PU1 We found a rounding error in the payroll pre-check register. A time card was entered for 15 hours @ 62.2743 = 934.1145 Normal round would give 934.11 but the pre-check register shows to 934.12 Yeah I…

A Sage 2012 user has to collect Texas sales tax starting now. So, this user has thousands of items and about 40-50 item categories. I can add the tax authorities to the item categories, but what about the pre-existing items? Is there a utility to add…

We have a customer that receives grants on Projects and they are wanting to record the amount expected as an estimate, however a negative estimate value cannot be added. Would anyone have an idea how to apply this? Thanks

Does anyone know how to establish contract prices for a customer, one product that has multiple units of measure and a few of the units of measure have contract prices but not all. Contract prices defaults to stocking unit of measure.

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.

The client makes purchase orders from a vendor where shipping costs are already known and to be paid to same vendor. Without adding "shipping cost" in the Purchase Order, the total does not match the actual Purchase Order to be placed with the vendor…

Hi all, I hope you are all well. We have experienced in the following scenario on one stock item during Order Entry: Qty on hand = 0 Qty Committed = -3 Qty Available = 3 Negative inventory is never allowed. Could anyone shed some light on…

Hello, I am trying to create a new Service Code (service agreement) but I am not sure where to enter in the actual length of the service agreement so that the amount paid for the agreement is amortized correctly over the length of the contract. I am…

Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…

We have setup contract pricing for certain customers and have attached the correct price list to the items. But why in OE does it still ask for Price Approval?

We are a stocking parts distributor and also do equipment repairs. Repairs is a smaller but significant part of the business, and it may be increasing. We use "Create Purchase Orders from I/C" to create our purchase orders to our vendors, whether the…

Good day Does anyone know the procedure of changing from Moving Average to Standard Cost? If i change the Costing method on my Account Sets in IC is there anything else i need to do? Do i need to create variance accounts or what else do i need to change…

I have a client that when reviewing the YTD information on the last paycheck, it does not match the W2. Our brief investigation shows that the W2 is correct, but the YTD information includes information for one extra paycheck and it is not the last one…

Hi all, I have a customer who when is receiving items also enters an "estimate" of the additional costs and prorate that by cost. Then when the real additional cost invoice comes in she puts that invoice against the receipt/receipts and again prorates…

Strange Issue, I am receiving Stock BUT, when I post the receipt, I receive the error "Negative inventory levels are not allowed." The Item QOH is Zero, Committed is Zero. There are QTY of SO and on QTY on PO... I am Receiving Positive Qty and The…

1. Find below screenshot, for a particular item cost is booked while doing PO Receipt but when those items were sold it is not showing any cost for shipment entry under inventory out. 2. And for some items, it just suddenly takes some unrelated…

We have a prospect that has complex IC contract costing requirements. They distribute food containers to the foodservice industry. They purchase (via Purchase Orders) from manufacturers at a certain cost and proceed to sell and invoice to customers at…