Sage 500 ERP v7.4 Invoice Overpayments – Continued


It was not my original intention to have a continuation on the original blog which you can see at  http://joenoll.rklesolutions.com/2012/01/04/sage-500-erp-v7-4-invoice-overpayments, however my good friend Richard Sisk at Sage provided some follow-up on the original post that provide additional insight into this new process. I thought I needed to follow-up on this new found information to complete my prior posting. This is great information. Thank you Rick!

In the original post I closed out by saying it would be nice to be able to post a second payment against the same invoice even though the balance was already < 0. It turns out this does exist it just did not work as I thought it would so I missed it. I apologize for the oversight but in this post I detail this newfound information for you.

I have entered another payment from Aldebrn for $150. I am applying this payment to against an invoice that has a current balance of $0. This brings the new balance to –$150.

image

Now I register and post this batch. This makes this record permanent. My next step is to create another batch with a another payment for Aldebrn of $135, as shown below. As you can see by entering in the Invoice No 1113 and then pressing the Tab key key it retrieves the invoice information showing the current balance of –$150. I then key in the Payment Applied of $135 as mentioned by Richard Sisk and it now brings the value of the new balance to –$285.

image

So I stand corrected in my comment in my original post. It appears that Sage has accommodated for this possibility!

How is this being treated in the database is quite interesting and simplistic. You can see this with some simple selects as shown below. The TranNo and the corresponding keys are based on the values from my demonstration and would most likely be different in your system.

   1: -- Invoice Header information

   2: SELECT InvcKey, TranID, TranDate, CompanyID,

   3:        TranAmt, Balance

   4: FROM tarInvoice

   5: WHERE tranno like '%1113%';

   6:  

   7: -- Invoice Header Application information

   8: SELECT ApplyToInvcKey, PostDate, PmtAmt, ApplyFromPmtKey, ApplyFromTranID

   9: FROM tarInvoiceAppl

  10: WHERE ApplyToInvcKey = 1307;

  11:  

  12: -- Customer Payment Header

  13: SELECT CustPmtKey, BatchKey, PmtRcptDate, 

  14:     PostDate, TranID, TranAmt, UnappliedAmt

  15: FROM tarCustPmt

  16: WHERE CustPmtKey IN (515, 516, 517);

  17:  

  18: -- Customer Payment Application

  19: SELECT CustPmtKey, ApplyToInvcKey, ApplyToTranDate, ApplyToTranID,

  20:         PmtAmt

  21: FROM tarCustPmtAppl

  22: WHERE CustPmtKey IN (515, 516, 517);

 

 

 

Results of above Select statements in order of the selects.

image

I recommend that you read up on this functionality in more detail and experiment with it in a test environment of your own. It is a very useful enhancement. Thank you Sage!

Advertisements

About joenoll
I live in Lancaster, PA. I am the President of RKL eSolutions LLC and a Partner at RKL LLP.

One Response to Sage 500 ERP v7.4 Invoice Overpayments – Continued

  1. Pingback: Sage 500 ERP v7.4 Invoice Overpayments « Joe Noll's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: