Budgeted PO's

We use Sage50 2016 and we are fairly new to it.  Our customers issue us a PO stating how much they approve that we spend on the Project, we then bill against this PO and when we get close we have to go back to the customer for a new PO to add to the old one and so on.  At this time we are using excel to track this but we were hoping to do it in Sage. 

I have gone through to see if I can do a project and a budget but it still doesn't warn when we go over the budget amount and I also have to print a Budget vs actual to see how far off we are. 

I should also mention that this is not a prepaid account by any means.

Hopefully I have explained this well, if anyone could help that would be great.

  • 0
    Typically when I work with SO's (based on a client's PO) where the job is billed as a percentage being completed, I enter the quantity of 100 as the percentage. Then bill against that with a percentage completed. Each time you invoice against that sales order, the backordered quantity goes down to leave only what is the unbilled part of the job.

    So if I have issued 3 invoices against the SO for completion of 50%, 25% and 15%, then I still have 10% left to bill. This can be easily seen on the Pending Sales Orders report. This method may or may not work for you but I have had success with it.

    How are you entering the sales orders based on your client's PO?