Message Boards

Sales Order Credit Hold - partly invoiced AR tax amount

Rene Balduk, modified 3 Years ago.

Sales Order Credit Hold - partly invoiced AR tax amount

Post Date: 5/10/23 (Silver, 51 Posts) Recent Posts
Hi All,

We are struggeling already for a while to implement a firm process to control sales order credit hold. 

I detected al issue in case sales orders are partly invoices already. The VAT amount of the sales order lines invoiced is also included in the open sales order balance listed in Csutomer credit limit maintenance 27.20.1.6. Hence the hold is applied to early when tax amount is calcualted twice (In AR and sales order balance).

I also like to know what the logic is QAD will apply when mulitple sales orders are created and balance is exceeding only when a new sales order is created. I noticed e.g. that only one sales order is not on hold whereas a sales order with an earlier due date is put on hold.

Kind Regards,
René Balduk.
thumbnail
Phill Norrey, modified 3 Years ago.

RE: Sales Order Credit Hold - partly invoiced AR tax amount

Post Date: 5/23/23 (Yoda, 1010 Posts) Recent Posts
At the time of creating a Sales Order or maintaining it a credit check is run.  But if you do not run the auto credit check then it will  stay that way until you change it manually.  so for example you create a SO a few days ago but it gets put on hold.  Then the day after you get a payment from the customer so now he has more available credit.  When you create the new order it will pass because at the time of creating that order there was sufficient credit available.  If after receiving the payment you had run  the auto credit check the older worder would have been released and the new one would fail.  Many years ago I created a program that was run each night and did a series of checks.  For example if there was a zero price on a line but it was not marked as a sample order then it would use a credit hold code of ZC (Zero Cost),  It went through many different scenarios based on what this client needed.  It would also release any that now matched all conditions and had available credit.  Another feature we built in was if the order total was below a certain amount then it would put the order on hold.  However, this was a much older version of QAD but in reality a lot of these checks are still valid.

Message place holder