Customer Credit Limit Control by the customer's balance

SOLVED

Hi,

We have a situation with one of our customers that need to control the sales orders/deliveries/invoices depending on the credit level ceiling that was assigned to their customer.

What we currently see in X3 is that the calculation for the authorized credit level is based on:

-Orders

-deliveries not invoiced

-invoices not posted.

but once the invoices are posted, the amount gets reduced from the authorized credit level and the order/delivery generation are allowed.

we need someway to include the unposted invoices and payments in the calculation of the authorized credit level.

Mahmoud

Parents Reply Children
  • 0 in reply to mhenson

    The "posted, unpaid invoices" are in the "account balance"  which is then adjusted to credit level.   The unposted payments are not taken into accounts. 

    click on the button to see the calculation.  

    On order +
    On-loan order +
    Deliveries in process +
    Delivered not invoiced +
    Loan deliveries +
    Invoices not posted +
    Draft management +
    Account balance +
    Credit level total

  • 0 in reply to Stephen
    SUGGESTED

    Check the OST parameters in VEN and TC.  the OSTORD sets whether open orders are included in the total.

  • 0 in reply to Stephen

    That makes sense. I've been crawling through the help files reading the various parameters associated with credit. I think we're missing configuration somewhere, because the "accounting balance" in the customer situation risk tab shows 0 (in this instance I'm looking at a customer with no open orders, but an unpaid invoice balance), while the aging balance shows what we expect.

    There is an "update credit limit" checkbox in the GL account setup that is currently set to no, so I'm now trying to determine if setting that to Yes will cause the 'accounting balance' to update (after a BP balance resync?), and then properly be included in the credit limit calculation

  • 0 in reply to mhenson

    yes - that is a new field in v12, maybe v11.  Do the customer balance resynch and that should update