Manufacturing, Distribution, and Internet Applications

[skipwhitten]

Hi,

When customer service get the message that their order puts the customer over their limit, they send a screen shot (Override Credit Limit) to accounting. This screen states that current balance is x,xxx.xx and future balance is yyy.yy. If you run an Aged Receivables for this customer the over 30 days is x,xxx.xx and the current balance is yyy.yy. Why wouldn't these screens match? Theoretically you could release an order when I customer is past due!

We are running MAS 500 7.05.20.0

Thakns in advance!

Skip

[rsisk101 · Accepted solution]

Skip,

It looks like the values for Current Balance and Future balance during the credit check come from the tarCustStatus table as calculated by the sparCreditCheck table.

The aging report comes from the transactional data as calculated by sparAging procedure.

I'm sure tarCustStatus is used during credit validation for performance reasons. When there is a large set of transactions, it could take time to calculate a credit rating if done from the transaction tables.

Hope that helps.

[skipwhitten]

Hi Richard,

Thanks for the explanation!

Regards,

Skip