Link A/P materials invoices to A/R materials billed to clients

Hello. I'm looking for a solution to handle the following process: We want to be able to flag A/P that it's ok to pay when a certain event occurs. For example, when we purchase materials, we bill them out to our client. Only when we have been paid for the invoice from the client do we turn around and pay the A/P invoice, no matter the date. Currently, I manually look through a binder of physical invoices and stamp the ones that are ok to pay, based on the cheques we've received for payment. Is there anyway to make this more automatic? Or link A/P invoices (materials) to A/R (said material billed out to client)?

Thank you.

  • 0

    FortuneOilfield said:
    Only when we have been paid for the invoice from the client do we turn around and pay the A/P invoice... Is there anyway to make this more automatic? Or link A/P invoices (materials) to A/R (said material billed out to client)?

    It would take a mess of custom reports to do that in Sage 50, since the information is stored in separate modules that aren't solidly linked together, except through dollar amounts of transactions into the G/L. 

    For example, there's no connection (except for serial numbered items) between a specific Purchase invoice and an inventory or service item, or from a specific item to a Sales invoice. 

    In Quantum, it's just possible to use Projects and numerous reports to establish that every allocated purchase Order item was invoiced on a Sales Order (by item, so no-one has that kind of time unless they're selling earthmovers).  

    But there's no connection between Payments and Projects, so determining the payment status of any project is a manual operation.

    Your best bet, given the decision to only, ever pay *vendors* when *you* get paid is to buy several dozen boxes of good quality binder clips, attach the purchase invoices (or copies) to the sales invoices, then file everything by sales invoice, and pay from the 'Paid Sales Invoice' copies.