x Want to participate? Join the group to interact

  • Inventory Discrepancy

    Does inventory have to be moved to final warehouse before completing ROG? Several commercial invoices were processed through ROG, but the inventory hadn't been moved to the correct warehouse. Invoice is correct in AP but inventory balances are incorrect…

  • Hide Line Item on Tax Invoice

    I would like to hide a line item on a tax invoice. We work much like the car repair industry. I invoice out the total service charge in one line item however I have inventory items related to the total charge and if not invoiced individually out it…

  • Intercompany billing

    Hello. Does anyone know the best way to bill between departments in Sage 100 Contractor? we have one department that acts as a subcontractor to another department and needs to bill them to recognize the revenue for their work.

  • Moving a paid AP invoice to a subcontract

    I paid a couple of AP invoices which were correctly assigned to a job, but were not allocated to a subcontract. How do I assign them to the subcontract without voiding and reentering?

  • Inventory Cost Detail out of whack

    Where do I start to fix this ... Show I run the Balance Inventory Qty and Cost...

  • PO in Back Order Status

    Hello I have a PO that product was already received back in 2022 but the line items also have a backorder qty and I can't edit the PO to remove those quantities.. Is there a way to remove the BO qty's and status.

  • Adjusting Inventory

    Hello what is the best way to make an adjustment to inventory without taking hit on the money side... I have an item that shows 2 in stock but there is nothing on hand and hasn't been for years. I need to bring inventory to 0 count but not take a…

  • employee year to date wages

    We reversed an employees check but now their year to date amounts are incorrect. how do we correct those?

  • Comments on AP Invoices

    Is there any way to modify AP invoice comments after the invoice has been posted?

  • Undo a bank statements, as many months as needed.

    Can you go back and undo a bank rec? Going back and undo as many months as needed?

  • JC_JobTransactionDetail table import question

    I'm simply trying to change some comments for some records in the JC_JobTransactionDetail table. The source code for the records I'm trying to change is "PR" and it is set correctly in the import job and in the source file. The cost type is L for…

  • Changing Effective dates when running a Job.

    When we run a job nightly for IRP do we need to change the effective and cutoff dates every day or does it change automatically somehow?

  • On order quantity does not match open purchase orders

    We have recently found that the on order quantity shown in item maintenance does not agree with the quantity of open purchase orders. See screenshots below. On PO qty shows 12 pcs However, we only have an open PO for 6 pcs We cannot figure out…

  • AP automatic check is a bank adjustment now

    We have just run into a new issue. 3 automatic ( not manual) checks show up in the bank recap report as "Adjustments" and not check, like everything else. They were printed during a check run with 400 other checks, but they show as 'Adjustment' in the…

  • Cash receipts

    How do you reverse an incorrect prepayment id cash recepits?

  • General Leader

    We just upgraded to Sage 100, however, our Asset are wrong along with all of the GL account opening balances, how would you revise the beginning balances?

  • Completed more against a work ticket than the planned quantity

    A user accidentally completed a total of 700 parts against a work ticket that was planned and originally processed for 600. I thought if we just increased the Quantity Ordered to 700, it would set things up for the extra 100 as far as the Materials go…

  • AP batch coding change

    How do I change an account coding once a batch is completed

  • Job Cost

    If a payables is already posted can I go back and add a job to it?

  • Work order

    In work order module is there a way to transfer materials from one work order to another and maintain the original cost?

  • Work Ticket BOI Change QuantityOrdered and Rescale Labor and Materials

    Using Sage 100 Advanced 2023 and the Production Management Module, I am trying to use BOI to update the Quantity Ordered on a Work Ticket but want it to automatically trigger the rescaling of labor and materials like it asks when you change the quantity…

  • IP TYPE CODE

    Does IP Type Code show up in transaction tab for all items during inventory count or does it only show up in the transaction tab if a count was made towards the item?

  • IZ TYPE CODE

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

  • Transfer history in a GL Code to a new GL.

    In the General Ledger, I would like to transfer history in a GL Code to a new GL. The new account will not have been used before, just trying to clean up the books. Is there a way to do this?I have looked at Utilities/Change accounts, but am not sure…

  • Grid Entry

    Has anyone figured out an efficient way to update things such as employee benefit costs or equipment cost updates? I've used other software that allows for grid entry, which is an incredible time saver.

*Community Hub is the new name for Sage City