Sage 100

So rebuilding sort files typically cleans this up, but we have an item code showing a warehouse having a qty of 8000 on Sales Order, but as far as we are aware (and as stated on the 'Orders' tab in item maintenance, the item is on 2 sales orders for a…

We are running 2019 100c Advanced. From time to time when entering a new SO the Order Total on the Totals tab is zero, while the total on the Lines tab is correct. Oddly, the system allows the SO to be saved in this condition! To correct the imbalance…

Is there a way to calculate economic order quantity within Sage? If not would you all have any recommendations for systems to calculate EOQ that integrate well with Sage? Is it best just to calculate it manually and input it individually? Thank you…

Does Avg Cost have any implication for a Lot item? We have an item that was FIFO some time ago, but via Item Valuation change is now Lot. That change was done some time ago. The Avg Cost field is way off now. But, does that matter? For this case,…

Most but not all Backorder lines are incorrectly calculated based on the Order Qty but should be Backorder Qty. As a test, I copied the Live company into a test company at the end of our shipping day just before running Daily Sales Reports and Updates…

Confirmed in v2020.1, and I see nothing in the release notes for PU2 to indicate this has been changed recently. Open a "completed" PO in PO Entry or Inquiry. Go to Lines and click on an Ordered quantity. At the bottom of the panel is displayed…

I'm trying my best to figure out how MRP Inquiry for a particular item came up with its 'Demand' number, but just can't seem to make sense of it. I've actually resorted to creating a test company, wiping out any SOs/POs, and resetting reorder points to…

Is there a solution to applying overhead when selling an item that doesn't go through Bill of Materials module production? We occasionally sell some bulk raw material and would like to apply overhead to the COGS for the sale. Thanks.

For some reason, in one (and only one of many) of our companies, under the Quantities selection the beginning balance for 2021 is not carrying over from the previous year. What could be causing this? Sage 100c Advanced 2018 (Version 6.00.10.0)

Really new to working with Sage. Doing weekly material count and counts are off. The item Qty is 441. There is an available balance of 41 LNF and committed of 400. Its showing me that there was work order that called for 400 lnf but its already been closed…

We have two different customers who've recently upgraded to v2020, and they are having the same issue: new Sales Orders are being created with bad totals (often zero). The Lines tab "Total Amount" is shown correctly, but the Totals tab's non-taxable…

Hello SAGE ppl, We buy parts from vendor as 001 and that part for outside job and receive it as 002 - How can we account that in SAGE system? We are placing PO and receiving 001 part @ price X. Now we are placing PO and and receive the part 002 @…

Is there a way to get Sage 100 to Display the Value of the Items in each box when doing Shipping Date Entry? This would be for internal processing only. We're able to print out a packing list per box and indicate its contents, but we still need to manually…

When I do the lookup by customer I have multiple listing for the same customer. It looks like the breakdown is based on year and period. However when I select one of the same customs for a given year it's the data is not the same when I select the same…

We have a customer using Landed costs during RoG, set to go to a specific GL account, which is matched up with the eventual AP invoice. The problem is that different items have different duty rates (some lines with zero added costs). We set things up…

Why on Earth is the weight only available if you are using it for freight calculation? What harm can there be from having weight calculated and available no matter what?

Hi all, I haven't seen any recent posts on this issue. I am trying to use a Miscellaneous Charge in Bill of Materials, and receive the following error: The miscellaneous item is not available for use in the B/M module. I have the "Allow Use in Bill…

Seems like the Valuation Change is in need of some updating. When changing from a Standard Cost item to a FIFO item, one would ASSUME that the new FIFO starting layer would be based on the Standard Cost. Alas, it is based on the AVERAGE cost. And I…

I see Sage KB 99750 describes the issue and I'm wondering if I need to open a case for an update? ("Sage Engineering is Currently Reviewing"). Customer is v2018.3 Premium, but I have verified the issue still exists in my unmodified v2018.8 and v2019…

We found an anomaly when entering a PO for a SKU that does not have the standard cost setup, the pricing comes in as $73.00 vs $0.00. I believe this is not vendor specific. Is this unique to our data or some other default setup in Sage? BTW we are on…

I would like to include landed cost in the cost of items rec'd . On a PO I've indicated that the total freight will be $100 for 100 items ordered. I want to use quantity in landed cost to allocate the freight costs - so if I only receive 50 then I want…

Since Sage100 does not offer out-of-the-box an option to calculate freight based on order $ total, has anyone found a work around? We have different freight percentages established and would like to somehow designate a customer to a particular freight…

I noticed that the margin percent calculations in Sage didn't seem quite right so to test things I created a brand new average cost item. I gave the item a Standard Cost of $100. I then received in 100 units @ $100 each and then another receipt for 100…

Good afternoon Sage community! I was wondering if it is possible to ship backorders off of multiple sales orders but generate one consolidated invoice. Our most common scenario when shipping backorders is that we have a customer who has multiple Master…

Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…