PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

400+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Sales Order Document Approval Query by Overdue A/R Invoice

SAP Business One Tips Sales Order Document Approval Quey
SHARE ON

Almost all companies using ERP Systems such as SAP Business One are wanted to restrict and analyze their sales through correct data submitted by their sales admin. Company management wants to know if their customers have outstanding invoices before they open another new sales order document. This will lead management to decide if these customers can buy products from them through the approval process in SAP Business One.

You can use the query below in Approval Templates menu so the approval process can be done in SAP Business One Hana version or SAP Business One SQL version:

/*HANA Query Version*/
SELECT DISTINCT 'True'
FROM "OINV" T0
WHERE T0."CardCode"=$[$4.0.0]
AND  T0."DocStatus" ='O'
AND T0."CANCELED"='N'
AND T0."DocDueDate" <  CURRENT_DATE

 

/*SQL Server Query Version*/
SELECT DISTINCT 'True'
FROM dbo.[OINV] T0
WHERE T0.[CardCode]=$[$4.0.0]
AND  T0.[DocStatus] ='O'
AND T0.[CANCELED]='N'
AND T0.[DocDueDate] <  GETDATE()
Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , ,