Browse By Tags

  • Year end adjustments to account payables

    I know there was few topics on similar issue but it seems I didin't find the answer. I received following year end adjustments Account payables Cr 20 000 consulting services Db 20 000 Since I cannot do adjustments to accounts payables without…
  • reversing bank charges from bank reconciliation

    I have posted bank charges in expenses tab in account reconciliation as of Oct 31. After year-end adjustments, my accountant asked me to move it for next year. For some reason this transaction was not showing up to him. How can I move it to November so…
  • AR Invoice Adjustment not reflected in GL

    Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…
  • overbillings and fiscal periods

    This is my first year using Sage 100 Contractor (or sage at all). I started with a construction company in March 2021. I recently took a deep dive into how the overbillings and changes to estimated job profits effect each fiscal period. I simply wanted…
  • Buy & Sell Inventory with different part numbers

    Hello. I'm trying to sort through our inventory and I'm looking for a way to purchase a part that comes as a kit and then sell the individual pieces from said kit. The problem is the kit is one part number and the individual pieces are another. I have…
  • Deleting inventory that has been invoiced to a customer?

    Hi there, My company has several Inventory Items that we would like to remove from our system for various reasons. Our supplier has discontinued them, upgraded to a new version, etc. However many of these inventory items have been sold to customers…
  • Tracking external processing item costs Sage 50 Quantum

    Hi, I'm trying to determine what the best way to track the costs of external processes on inventory items? hoping some folks around here could chime in. RM=RAW MATERIAL AS=ASSEMBLY FG=FINISHED GOOD EXAMPLE: 1. 10 x Widgets item number (RMWIDGET1…
  • How to correct serial number when doing an order?

    There is a major issue when we enter the serial number on each of the line item at the order. Usually, a product includes several bar codes on the package box, for example, serial number, UPC code, EAN etc. Problem is that BV pops up the serial number…
  • Physical Inventory Count Posted Accidently

    Hi, We were reviewing the physical count and posted it on accident. Is there a way to reverse that? Regards, Becki
  • varying pay periods

    Our normal pay period is bimonthly (24 pay days) One person's payroll does not make sense because some periods, his pay stub is correct (march1-15, then 16-30) but some months, the pay stub is incorrect (april1-15, then 25-31). The bi-monthly salary…
  • IC Shipment Quantity Issue

    An IC shipment was created where the operator accidently removed 51,138,686,093 units from stock. The Shipment appears to have posted but when trying to open the shipment we get a Code: 3.3550.0 Source: IC0630 error. Can I go into the ICSHED table end…
  • possible, specific 'tutoring'?

    Hi! Does this forum offer names/contact info for possible tutor sessions? Having specific problems not easily addressed, and no 'go to' person in our very small office.... Timeslips 2014, attorney based. Thanks!
  • MATERIAL RECEIVED WRONG WAREHOUSE

    Hello, We sent a PO to one of our vendors and it was supposed to get shipped to our CA location, however they sent it to our FL location. We now need to send this material to our other warehouse as we have no space here to keep the product. For…
  • Unable to fix negative COGS due to adjustments in inventory module ?

    We are a factory using Sage 50 Quantum. We use average cost and quantities were not negative. I managed to set the correct quantities and values of the inventory by using the inventory module, by first resetting the value to 0 in the module and then adding…
  • Transferring FG inventory from one warehouse to another

    Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
  • Is there a way to change the Inventory adjustment transactions to use the 'Average' instead of the 'Replacement' unit cost?

    We are setup for inventory adjustments to use the replacement value, this value is incorrect. Can we change it to use the average cost?
  • Changing Stocking Unit of Measure

    Is there anything we should look out for when we change the stocking unit of measure? We some items that have a couple of conversion factors and the items are used in BOMs. To be careful should I issue out all the inventory, change the stocking unit…
  • Negative quantities posting to I/C

    We are currently building a pump, the way we process the job is to charge everything and then at the end we post a negative quantity of the completed pump to balance the numbers. Unfortunately, now that I need to close jobs for the end of January next…
  • Inventory Returned and at what point is it put back in to inventory

    We had a customer return some material. We issued a credit memo for these items...each piece was entered onto the credit memo and the quantity that was returned. When looking at the inventory reports it does not show that the material was put back into…
  • Average Costing Negative Inventory

    We are currently exploring moving some of our smaller, order-in products from FIFO to Average costing. I understand how the valuation works on both sides, but we are still working through some company process issues where sometimes a S/O will get finalized…
  • Sage 100 migration taking WIP turning into Inventory

    We are currently Migrating from Sage 50 to Sage 100 and about to go live. We have one particular item we sell that we put as a job in Sage 50 where all costs go to WIP and then an Inventory adjustment puts the item into inventory. For clarification we…
  • Inventory for items not for sale

    Hi everyone, We use pallets to ship our produce and we want to start keeping track of the pallets. Can I do this as an inventory item in sage without money involved. I know I would have to assign accounts to the items but not sure what accounts to use…
  • How to correct duplicate Misc. Cash Receipt entry

    The same Misc. Cash Receipt was entered twice, on different dates. Since it was not payment towards an AR customer account, how do you correct the duplicate entry?
  • Prior Year Adjusting entry

    I need some insight on how to make adjusting entries for expense accounts from 2018 to 2019 that were not claimed for 2018 Taxes. I need to carry forward the amounts I made from receipts and Invoices that were charged and paid for in 2018. For example…
  • Import I/C Adjustments

    Can someone please advise (or provide) where can I find a Template, instructions and key for I/C Adjustments? We are using the Export/Import capabilities as often as possible and I can usually find what I need by exporting a previous item and recreating…