供应商应付未付已付款报表

onnet168

纵横四海 可以帮我说说怎么做供应商应付未付已付款报表吗?
我只找到那几个表主题怎么做不清楚
希望可以指教

纵横四海

asktom回答一下吧。

ricozhao

可以直接‘点将’的阿

onnet168

AP_invoices_all
AP_invoices_Distrbutions_all
AP_invoices_payments_all
怎么实现通过货物类型和会计期间统计供应商应付未付已付报表
希望高手指点
主要是不知道怎么取值
因为我在AP_checks_all也可以看到支付记录
不能确定到底是用那个地方的订单已付金额和应付金额

onnet168

回复 #1 onnet168 的帖子

It seems ap_invoices_all is enough (you don't need the payment and invoice distribution tables).

应付: base_amount or invoice_amount
已付: amount_paid or payment_amount_total
未付: This will be a calculated amount, which is 应付 - 已付

Of course, you can use some payment flag like payment_status_flag to check the payment status.

If you will provide a supplier name as a parameter, then you have a condition like "vendor_id = xxx", or if you want to list all suppliers, then you can "order by vendor_id".

You will provide a start and an end dates to screen out invoices outside the date range.

Create a simple query and play it with your data. When you get the result you are expecting, take a detailed look at your query to see if there is anything else you want to modify/enhance.

Of course, your result should be an Oracle report. After you get the query, creating a report based on the query you have should be easy.

chen64683
甲骨文三段

onnet168

Supplier and supplier site information are at the invoice header level. That is for sure.

Where are you trying to get 货物类型? If this is through some detail at the invoice distribution level, then you have to that level. However, there is no concept of payment associated with any invoice distribution. For example, if one of your invoice recorded $200, and from the invoice distribution, you put $100 on a TV and $100 on a radio. If this invoice is 50% paid, you cannot claim that the TV is 100% paid and the radio is not paid. Even if you say both got paid 50%, that will still be an incorrect statement.

So what you need to do now is to go back to the business people, to see what they really want from this feature. Your current intERPretation is inconsistant with what Oracle provides.

chen64683
甲骨文三段

sunweijie22

关注中...