x Want to participate? Join the group to interact

  • IZ TYPE CODE

    How does an IZ TYPE CODE IN INVENTORY TRANSACTION ENTRY populate?

  • FIFO Item valuation and PM Work Ticket closing method of Standard variance suggestions?

    SAGE 100c 2021.2 Advanced Production Management Work Ticket Close Does anyone use FIFO valuation on Items and close work tickets using standard close method? Our standard cost in Item Maintenance is slightly higher than Actual build cost and the…

  • Recalculate Costs on Purchase Orders

    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…

  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

  • Report that breaks out allocated cost

    We need a report (preferably one that would easily import into Excel) that breaks out the allocated cost for inventory receipts by lot. You can look at this information in the cost detail tab, but I cannot find a report that shows this information separately…

  • Outsourced Jobs accounting in SAGE 100

    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 @…

  • Can Excel pull data from Sage 100 Item inquiry under the Bill of Material menu

    FormerMember
    FormerMember
    Hi Everyone, I am wondering if there is a way that I can have excel look up a part number when entered in sage and pull the standard price from the Item Inquiry under the Bill of Materials menu automatically. So my excel sheet is for scrapped items…

  • Changing warehouse costs and costing method.

    We have items that we purchase as expense items but for which we need to manage quantities. Therefore, we want zero unit costs across all warehouses and zero Last Costs. We have a lot of years of data and there are current open SOs and POs. Once the unit…

  • Previously purchased item changed to a KIT for Purchase Unit of Measure, how do we remove the Last cost information as item no longer purchased?

    Previously purchased items are no longer being purchased. The items unit of measure for purchases was changed to KIT. The concern is the item still shows costing information and it is very old and misconceiving. How can we remove the costing information…

  • record an item return on a sales order

    We have customers that buy a new piece of equipment and trade-in an old one at the same time. How would we record the trade-in on the sale? Do we put a negative amount in the quantity field? This appears to use the wrong cost for the returned item.…

  • Direct Labor Costs Built into Bill of Materials for Items Sold as a Kit (always explode)

    We have a packaging company with a large variety of items which are packed to order. As we don’t prepack, virtually all our sales are through kits with the option selected to “always explode”. We do have a bill of materials (BOM) for each kit as items…

  • Inventory Stock Status Report vs. Physical Count Variance Register

    We are currently using MAS 200 for inventory reconciliation. I use the stock status report to balance our physical counts to MAS, giving us a potential variance amount. Once I enter the physical count numbers into physical count entry I am finding that…

*Community Hub is the new name for Sage City