Jasa Pembuatan dan Bimbingan Skripsi Informatika

Home » ERP SAP » Selisih Antara Inventory Audit Report dengan Balance Sheet di SAP B1

Selisih Antara Inventory Audit Report dengan Balance Sheet di SAP B1

Recent Posts

Untuk mengetahui selisih antara Inventory Audit Report dengan Balance Sheet di SAP B1 bisa menggunakan query :

SELECT
T0.TransId, T1.Account, sum(T1.Debit-T1.Credit) Balance
FROM
OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId
WHERE
T0.TransType = 30 and
T1.Account in (SELECT distinct InvntAct FROM OINM)
GROUP BY
T0.TransId, T1.Account

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: