AP Lien Waivers to include credit memos

Has anyone figured out how to get AP Lien Waivers in Sage 300 to include credit memo amounts?   As far as I can tell, the Lien Waiver forms are all written based on the Job Lien Waiver file, and for some reason, credits (or negative invoices) do not show up in the Job Lien Waiver file.   Our AP clerk has to manually recreate any lien waivers which should include credit memo amounts after every check run, which is time-consuming, labor-intensive, and allows for error far too easily.    I appreciate any insight anyone can offer. 

Patty

  • +1

    At this time it is a manual change to the lien waiver amount in AP, Tasks, Subcontractor Compliance Management, select the Job, Vendor and lien waiver in question.  Change the amount on the lien waiver.   Please see Knowledge Base article 29240 for more information.  Another alternate solution is to have a custom report created, in Subcontractor compliance enter the credit invoice information on a new line.  If reporting by check and credit was on the same check, it should report properly.

  • 0 in reply to Rachel Merritt

    Thank you, Rachel Merritt.   We are currently using a manual method to correct the lien waivers, but I am finding that the large volume of invoices and credits processed allows for too many slip-ups.  I would really prefer to have this more automated, if possible.  Although I have created many custom reports in Sage 300 over the years, this one has me stumped.  Unfortunately, the lien waiver reports are written based on the JC - Lien Waiver file, and for some reason, credits never make it from the AP - Invoice file into the JC - Lien Waiver, and that is why they do not show up on the lien waivers.  I'm probably oversimplifying, but It seems to me this would not be a difficult programming change within the Sage 300 code itself.   My guess is that when writing the program to include invoices into the JC - Lien Waiver file, someone coded a condition similar to "Invoice Amount > 0", and that needs to be changed to "Invoice Amount <> 0.    Wish I knew how to talk to someone who could get this done.  Sigh.

  • 0 in reply to pec

    Ooops, ok, I just accidentally "verified" your answer.  Not really sure what that means, but sorry.