Browse By Tags

  • Purchase order and invoice price discrepancy

    How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.
  • Work Order Adjustments

    FormerMember
    FormerMember
    In Sage 100c Advanced 2016, Updated a completion step of Work Order. Some items posted to scrap with all the cost and some items posted to inventory with no cost. Somehow the cost was all posted to scrap. Now if we complete other steps in the Work Order…
  • Can't process sales invoice due to cost of inventory items change

    Hi, all: While I modified a sales invoice, this is error message: "The cost of one or more items has changed since you started processing this transaction. If you recently printed this transaction's Detail report, reprint the report to see the effect…
  • Qty committed to sale

    Hi Support, We have a client who used to use VM Service manager. which was linked to inventory and order entry. they have identified some items that have Qty committed to sale because of VM service manager. the items are old and need to be written…
  • How do I correct an opening balance error in bank account?

    When the system was setup, the person who did the setup, opened the bank account with 50K CR instead of 50K DR. When I took over in January, I wanted to correct the opening bank balance. I went through the account setup and changed the opening balance…
  • Inventory and item cost problem

    Hi We have a problem with my inventory. We do house and buidling wiring. We sold and install different type of cable and sometime it's sold foot by foot or in a package and I have an ''service'' item for that purpose. Also since we are in canada…
  • LOC set up wrong

    The bookkeeper before me has the line of credit account set up as a cash account. So I am unable to record payments on it and account for it correctly. Sage will not let me simply change the account type to a liability. It is only giving me asset options…
  • Duplicate cash receipt pending post, won't let me post it

    It looks like I have a duplicate receipt entry, one is type Csh rc and has posted correctly to at, however the other entry is type Cs cs rc. Same date, same check number same amount. The problem is the second type Cs cs rc is "pending post" so it will…
  • Correcting a mistake that affects bank reconciliation

    Hello all, I am just getting back from a med leave and have found an error that my temp made. Wondering if anyone can help me out. We post a recurring entry each month, which is a direct deposit to us. I had posted Aprils payment before I left. However…
  • Cannot enter inventory adjustments. Help please?

    Using sage 50 premium accounting. I recently started at a place that has their inventory listed in sage. It is our year end now, and I can't make inventory adjustments to actual because: When their inventory items were originally entered, they entered…
  • Cost decrease adjustment is not reflecting in Location details.

    We adjusted one of the item cost (cost decrease), but it is not affecting in location details. Inventory movement and Stock transaction report is showing correct figures. How an i solve this issue. In ICILOC table i saw Qtyonhand is 11 and Qtyshnocst…
  • Negative slip adjustments via activity/task code-2017

    We previously were using Timeslips 2011 and used one task/activity code set to negative 50% which automatically took care of all the affected slips. We just upgraded to 2017 and had a consultant upgrade our database. This feature no longer works with…
  • Repayment of EMployee benefit

    Hi We had an employee go on maternity leave, for just under a year. We continued to pay her medical insurance. There were no weekly entiries made, as it normally came off her check . Now that she is back, i need to figure out how to enter her payments…
  • Inventory receiving issues

    We have two companies that buy and sell from each other. We use purchase orders and invoices to move inventory between the two companies. I accidently received a PO and paid the invoice to the second company. But, we never received any product from…
  • Payroll was entered manual and now entering in module -- Different amounts

    Taking over a client who entered payroll in GJ from the online CRA payroll calculator. The journal entries have wrong calculations (for income tax) and one employee was CPP maxed but she continued to post/deduct. When I am re-entering the information…
  • How to Discount Time Worked

    We have a client we need to bill on an hourly basis (we're new to TS). If we work 6.5 hours but only want to bill for 5.5 hours, how do we do that so it shows the client we are deducting that hour. We see in the timeslips options to not bill for time…
  • Quantity on S/O but no Sales Order in system for specific item

    Our client is working on Sage 300 2014 PU3. When doing the Physical Inventory Reconciliation it gave an error that states "There is insufficient quantity available to adjust item XXX at location XXX". When checking the specific item via Item Location…
  • Have you ever had payroll post to an incorrect job and wanted to fix it without using payroll?

    It is a common issue that payroll checks get posted with incorrect job information that needs to be corrected in Job Cost. We usually recommend voiding the check or using Change Posted Time in payroll, but sometimes that is not an option for you. A great…
  • Voiding an Invoice

    Hi everyone. I was hoping someone could help me or guide me on this situation. I have a customer who signed a contract and gave a deposit in 2015, however, same customer decided to cancel the job when we were ready to start this year. My question is…
  • po receipt entry

    Dear all I have a customer who has received 16 goods intstead of 32 and inserted the invoice number.. after running the day and processing, he realizes that he was supposed to receive all 32 quantities... what do i do please help
  • Multi Year Data Input and Adjustments

    Hi, Situation : My client recently lost all access to their old accounting software (the only access they have is to their data is via excel reports). It is my job to import their trial balance from 2008FY to 2015FY into Sage 50 2016 CA. My next step…
  • electronic billing -- third-party processor reduced our payment

    Our new third-party processor cut out $210.00 of fees we billed on our first electronically generated bill. Is there a "standard" out in the world about how to handle this situation? Do we go ahead and approve the original bill, then show CREDITS on the…
  • Historical Inventory - Help!

    On April 1, we set up historical data for our inventory products. Several of these inventory accounts used serialization. Switched to go live, and then when trying to process a sale, the items associated with serialization would freeze the system. After…
  • Outstanding Checks - balance transfer between liability accounts

    Hi all - I recently inherited an accounting position where my predecessor was playing catch-up trying to re-create a company's records with incomplete information. The company uses 2 credit cards to help with cash flow in paying vendors. I recently…
  • Year End Closing

    Hello All, I recently took over the accounts payable department at my job. I learned that when they close the year out, they do close the current year, they actually close the prior year. For example: 12/31/15, they closed out 2014 not 2015. My questions…