Screen Locking Time - User Level

The information you access and maintain in SAP Business One as part of your job, might be sensitive and should not be publicly available.

Its important to secure your data on your SAP System; You should know that you can lock your SAP Business One client when you are not in your seat. Click the ‘Lock Screen’ icon on the toolbar. The ‘Login’ screen immediately appears and requires to enter user password:

As every one know about the General settings for locking the SAP Application on a time interval if the system is idle;

 

Also, there is an option user wise to  lock the application based on user convince.

How to get Net Balance of A/R Down Payment Invoice?

Down payment  available net value can be fetch from  DPI15 A/R DP - Drawn Dpm Applied Table; Check the column [DpApplNet] - Dpm Appl Net LC;

Once linked to invoice level, Document Line table 9(eg. INV9) have the details of Down payment linked Invoice. Filed

DrawnSum have the down payment value used in the Invoice. So if user minus the value from the 

DocTotal of Down paymnet and DrawSum, will get the net amount in the Down Payment.

SELECT 
  T0.DocNum,
  T0.DocDueDate,