Sage 100

I'm not sure if this is an elementary question, but I was wondering how to best handle inventory costs in the following situation. We keep inventory as average cost valuation. Periodically, we get promotions activities from vendors where we're "selling…

Is there a way to Recalc Cost on a PO similar to the Recalc Price function on SO? We have many open POs in our system where we need to update line item cost to new vendor cost based on price increases. Those new vendor costs are uploaded to the SKU, so…

Sage 100c Advanced 2018 v6.00.10.0 When we update a Receipt of Good Register, even for just a small receipt, it can take 30 minutes or more to update. No other updates in the system take as long Is there a way to refresh the work/crystal files so…

With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before. Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled. Our…

We have a client on 4.5 that uses Item Pricing by Total Quantity, based on Item Category. They are taking on a new product line, however, that they want to implement discounts by line item based on the total PRICE of the items on the order within that…

Someone really needs to explain to me why with Sage invoices, inventory and, payables can't be updated until accounting does what ever is they do. Leaving the GM, Sales and inventory blind for half the month unable to finalize anything. This is not how…

We have a client who has a customer who wants a packing list for the items that are in each box shipped for the order and not the whole order on the packing list. Does anyone have a similar issue?

I am using Sage 100 and invoicing in the Sales Order module. When I use a kit, no cost shows up, not on the invoice screen or when I print the invoice. However, if I act like I am going to post the batch (but don't actually post/update it) and go back…

We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…

A client entered a purchase order, printed it and sent it to the vendor. They went back to Purchase Order Entry, and three items were automatically added to the order mysteriously. It appears that items from another order are showing up on this order…

In receiving goods, occasionally there is one invoice for the items themselves, (paid to the vendor), and another invoice for the cost of shipping, (paid to the shipper). For the former invoice, all the items are invoiced, and in invoicing the PO, none…

We discovered a situation where we have multiple SKUs with negative inventory quantity when they are lot controlled. This appears to have happened from a physical inventory count and adjustment. Background - we had some lot controlled inventory get…

We have some items where the Sales UOM is EACH and standard is KG. When adding these items to a sales order, the sales quantity shows as EACH however the price is coming over as the standard price x the KGs per EACH. This only occurs for a handful of…

We often order stock items on a PO where the inbound freight amount is TBD or an estimated amount that is only known/determined when we receive the vendor's invoice. From what I can tell, landed freight costs are applied during Receipt of Goods. Since…

First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…

Can you send me step by step instructions as to how to receive inventory that is partially assembled outside of the factory and brought in house to be completed to a finished product?

Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you

Hi, In Sage 2018 and WOScan we could negative issue an item and create a new unique Lot or Serial Number on the fly. In Sage 2020 and MFG100, MFG100 will accept the scan, but Sage rejects the import because the number Lot/SN doesn't already exist…

I had an employee Disassemble something that was produced a week ago. When they disassembled the product the quantity she needed to select was off by 200lbs. How can something be produced at a quantity and not be able to be disassembled at the same quantity…

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…

In the Work Order module for one of our companies, we have the settings set to: Work Order Issue Method: Backflush Auto Generate Material Transactions: Yes Auto Generate Labor Transactions: Yes This has been working, but every now and then we get this…

Has anyone seen a broken Shipping List lookup (flashlight list to show previously created entries in the batch)? There is no customized ALE. Customer has enhancements (PM, ScanForce...). ShipperID has full permissions, and so does my Sage login. We…

In Work Orders, is it normal when Issue Method = Backflush Auto-Material = Yes To get the following message when issuing a completion transaction: I understand the message, but we don't get this every time. I presume there is a step I am missing, or simply…

Why is Auto Reorder Selection covered by this Role permission? It most certainly is not a "register", since no $ or inventory is moved. It's just a way to create POs. We recommend users never have the permission to post from Preview (which is the…