如何在2007 A里生成针对付款的所有按科目付款的部分付款的列表

baobao

How to generate a list of all partially applied 'Payment on Account' from the 'Incoming Payments' in 2007 A?
This is a new functionality in SAP Business One 2007 (A & B) & is not applicable to lower versions.
If an incoming payment is made via 'Payment on Account', then this payment will appear in the 'Incoming Payment' window for the selected 'Business Partner' (BP). It can then be used against other open invoices to reduce the balance due on those selected open invoices.
There can be a business requirement to determine either of the following:
-          Incoming Payments (paid via 'Payment on Account') that have been partially applied
-          How much of that total has been applied.
This can be achieved with a simple query.
Example:

1. Post an incoming payment transaction. Tick the 'Payment on Account' box.

2. To use payment No. 74 against other open invoices, enter the BP code in the 'Incoming Payments' window. Notice that payment No. 74 appears as 'Document Type'  'JE' (Journal Entry), with Transaction No. 1091 in the 'Document No.' field. Select the payment along with other open invoices.

  

A query can be created to display the required information. This query will provide a list of not fully applied 'Payment on Account' incoming payments. In our previous example, GBP 700.00 of Incoming Payment No. 74 had been partially applied.
Query:

SELECT                 -- Document Number of payment where 'Payment on Account' transaction was applied.                 T0.[DocNum],                 -- Busines Partner Code in the Payment transaction.                 T0.CardCode,                 -- Journal Entry ID of the 'Payment on Account' transaction used in the above Document Number.               T1.[DocEntry],                 -- 'Payment on Account' Amount Applied                 T1.[SumApplied] as [Applied Amount],                 -- 'Payment on Account' Amount                 (SELECT T5.[NoDocSum]  FROM ORCT T5 WHERE T5.[PayNoDoc]  = 'y' and T5.transid = T1.docentry )['Payment on Account' Amount],                 -- Original Document Number of the 'Payment on Account' Transaction                 (SELECT T5.[DocNum]  FROM ORCT T5 WHERE T5.[PayNoDoc]  = 'y' and T5.transid = T1.docentry) ['Payment on Account' Payment No.]                    FROM                 ORCT T0                   INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum WHERE                   --Only select the rows of the incoming payment which arise from a previous incoming payment made via payment on account                 T1. Invtype = 24                 --Select only those incoming payments where the total amount of the payment on account has not been applied.                 and                 T1.[SumApplied] <>                 (SELECT                                  ((-1)*(T6.[NoDocSum]))  FROM ORCT T6 WHERE T6.[PayNoDoc]  = 'y'and T6.transid = T1.docentry  )

Query result:

This query shows what target Incoming Payment the initial Payment on Account transaction was applied in and its partial amount.  Note:This query only displays not fully applied payments on account transactions. Save the query to the 'Query Manager' and may be used as the basis for a 'User Report'.