Equipment allocations

SUGGESTED

Sage 100 Contractor Canadian

How to correct vendor invoices allocated to equipment that are already paid?

We have a number of payable invoices that were allocated to the wrong equipment and need to fix the allocation.  I tried to do a journal entry to debit and credit the same GL account so that I could change the allocation to equipment, but the system will not accept a debit and a credit to equipment on the allocation screen.

I posted this question a week ago, and I can't find it in the forums.  Hope I have this in the correct forum.

Thank you

DGlick

  • 0
    Aloha...Did you try making the adjustment in Journal Transactions 1-3? Debit & credit the same equipment account so that you can get to the equipment posting screen; minus out of incorrect equipment & post to correct equipment.
  • 0 in reply to Kathy Gotzenberg
    Thank you Kathy - I tried doing that, but it kept asking me if I wanted to allocate this JE to the equipment, and since I had already tried that I just cancelled the JE. I just tried it again with the credit to the equipment that was allocated in error and the debit to the correct equipment and it once again asked me if I want to allocate the cost to equipment - I cancelled the Journal Entry. These vendor invoices are all in this fiscal year and have all been paid. Any other ideas? I am more than willing to try any suggestions.
    Thanks
    DGlick
  • 0 in reply to dglick
    Is it possible to correct these errors under 8-2 Equipment Costs? Do not want to effect the GL.
    So if I select Go to Source which brings up the vendor invoice and then under Costs select Equipment Costs which brings up the equipment cost screen - can I safely change the equipment number?
    Thanks
    DGlick
  • 0 in reply to dglick
    Hmmmm....tested this type of entry on my side and it worked OK. Aren't you trying to take the costs out of the incorrect equipment and move to correct equipment?
  • 0 in reply to Kathy Gotzenberg
    yes, the payable invoices were posted, paid and the cost allocation was to the wrong equipment. My concern is that as these invoices were paid and cheques cashed - bank rec has been done can I change the equipment cost allocation on the payable invoice without effecting the bank rec? The journal entry correction is not working.
    Thanks
    DGlick
  • 0 in reply to dglick
    I tried to change the equipment cost on the original payable invoice and it will not allow me to change it. I just tried to do the 1-3 journal transaction again and after I credit one equipment and debit another and safe, I get " Do you want to post equipment costs?" when I enter yes, it brings up the journal transaction equipment costs screen again - when I hit enter I get the same question again. Any suggestions - the only thing I can think that might be the problem is that these corrections go back to our first fiscal month and I have archived the payroll for 2015 - would this prevent me from fixing this problem?
    Thanks
    DGlick
  • 0 in reply to dglick
    Aloha....I got the same message when I tried to save the 1-3 transaction...."Do You Want to Post Equipment Costs?" I kept answering yes and it took me back to the journal transaction screen & didn't save. I finally hit "NO" to the questions...and low and behold it saved it. I went back & checked the 2 pieces of equipment I was using and they were updated. Go figure!
  • 0 in reply to Kathy Gotzenberg
    Ok, I will try this in a test file - thanks this really doesn't make any sense at all. I'll let you know if this works.Thanks for your help.
    DGlick
  • 0 in reply to dglick
    SUGGESTED
    Well it worked thank you so much I did not check to see if the entry I said no to actually posted. There must be a problem with the program.
    thanks again
    DGlick
  • 0 in reply to dglick
    SUGGESTED
    If I'm understanding the issue, you're trying to reallocate equipment costs that were posted to the wrong equipment. I ran into a similar issue and Sage support walked me through a scenario that I believe applies to this situation. Open up menu 1-3 (as if you are going to enter a journal entry, although you will NOT actually be saving a 1-3 journal entry). From the 1-3 menu, select the option to "view equipment costs" (I'm not at my computer, so I don't recall exactly what the menu says, however, I'll try to convey the concept). This is the same window that you see as the second step (second window) when recording a transaction where one of the line transactions hits the equipment ledger account. Essentially, this is a "back door" where you can shift around or update equipment costs. It is here where you'll want to enter the correct information, "offsetting" costs from one piece of equipment to another. You'll want to enter a positive amount for the correct equipment number, then create a negative (offsetting) amount to the erroneous equipment number. Once you save this entry, the system will update the equipment costs. However, it does NOT require that you save anything in the 1-3 menu—you can just close that window. Does this make sense? I hope I understood the question correctly. Good luck!