Progress billing issue on new startup

SUGGESTED

I've made a mess and I do not know how to fix it. 

In 3-7 Progress billing I opened a job and imported the proposal.

The problem being since this is a new start-up I had to recreate the progress billing we had been using. The way our progress billing was shown on the report previously had it sectioned out with some zero dollar value rows for different buildings. When I imported the proposal these zero dollar rows did not import and I unknowingly submitted and posted the progress bill. Then I started a next months progress bill and realized the mistake. The problem I am having is I can't seem to void the first pay app, when I tried to void the application Sage told me that it would void that application and any after it. 

Good that is what I wanted...

But during that process it failed with a "WARNING failed to void application"

Now I have pay app #4 that is closed and Pay app #5 that is void and neither of them have the correct proposal. 

Is this even fixable?

  • 0

    Hi Jasin, check to make sure that no pay apps are paid in Sage. If so, you have to void the payment and then you can go void the 3-7 pay app and eventually post the payment once you fix the pay app.

    If they're not paid, an easy way to fix is to print pay app 4, 5, and anything after to pdf or paper. Then go to a pay app before like 2 or 3 and void those back to a status of 2 - Submitted. Post that pay app again, and then you are back to where you started at an open pay app #4.

  • 0
    SUGGESTED

    This is a complicated answer so bear with me. 

    In order to modify the original schedule of values you would need to void all the payments and the first PB record (which will void 2-current).  Now you can add new rows to the bottom (you cannot insert) for the stuff that was missed.  if you use cost codes, you can modify the PB report to sort by cost code when it prints.  If you don't use cost codes, then you can use the userdef column to number the rows in the order you want them to print, and then modify the report to sort by that column.  

    Option #2

    You can do a new PB record that reverses the billed to date back to zero and post it.  Now you can add whatever rows you need (again only at the bottom).  Then determine how you want to sort the info when printed and modify the report accordingly (like I suggested above). 

    Option #3: 

    If you are not already using phases, post a new record to reverse all prior billed to date on your existing string.  Then create a brand new PB using a phase #, AND the correct Application # for prior billed amounts.  Set up the schedule of values correctly.  and re-bill the billed to date in the current column.  Post it.  Now you have a new string of billings you can use.  In cash receipts, apply the credit from the old string to the billed to date for the new string/phase.  Be careful to get the retention amounts correct.

    GOOD LUCK!