on 08-08-2014 4:50 AM
Dear Experts,
We have a bit of a problem here, so here is the scenario:
Customer 1 has a credit limit of 100,000
He orders an amount of 90,000, then he orders an amount of 20,000. since it is a service order the approval procedure will not prompt and can be added to A/R invoice with a account of 110,000. so he had exceeded his credit limit by 10,000.
is there a way to active approval procedure by adding all open Sales Order and Open A/R Invoice?
i have seen some queries in the forum but it is not activating the approval procedure.
for your help please.
thanks!.
to add:
we are using SAP Business One 8.81 PL04
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have already set this up, but what i need is an approval process to check if credit limit < account (balance + orders balance). the above process checks only the account balance. i have been trying this query but no approval window appears
SELECT DISTINCT 'TRUE'
FROM OCRD T0 INNER JOIN ORDR T1 ON T0.CardCode = T1.CardCode
WHERE T0.CardCode = $[$4.0.0] AND T1.DocNum = $[$8.0.0]
AND T0.CreditLine < (T0.Balance + T0.OrdersBal)
is this script applicable to SAP B1 9.0?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
109 | |
15 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.