3463119 – Manual Posting to Inventory Account

3463119 - Manual Posting to Inventory Account

Symptom

An inventory account of the General Ledger (G/L) is incorrectly used in manual postings or Journal Entries.

As a result, there may be a discrepancy between Inventory Audit Report and G/L inventory account balances, since manual postings do not create any entries in inventory subledgers.

Resolution Analysis

Three methods below can be used to retrieve a list of manual postings where the inventory account is incorrectly used:

1. Using RSP task

The transactions can be retrieved via the Remote Support Platform for SAP Business One, using RSP task No. 1563300.

2. Using General Ledger Report

The general ledger report can be used to display detailed information about manual journal entries posted to the inventory G/L account. To do so, follow these steps:

  1. In the SAP Business One Main Menu, choose Reports → Financials → Accounting → General Ledger.
  2. Deselect the Business Partner selection area.
  3. Select the Accounts selection area. Find the inventory G/L accounts and select them.
  4. Define the posting period.
  5. Click the Expanded button and select Journal Entries. Choose OK to close the window.
  6. Choose OK to execute the report.
  7. The report generates a list of manual journal entries posted to the inventory G/L account.

3. Using Query Generator Detection Query

The Query Generator, along with the following query, can be utilized to identify the journal entry number, the specific inventory G/L account, and the amount for the journal entry.

  1. In the SAP Business One main toolbar, choose Tools → Queries → Query Generator.
  2. Choose Execute to open the query interface.
  3. In the new window, choose the Pen icon to activate the free text field.
  4. In the free text field, delete the contents and paste the following 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”

If feasible, cancel detected manual postings.

When cancellation is not possible (such as detected manual postings relate to closed accounting periods), corrective Journal Entries can be posted in the current period to adjust G/L account balances as needed.

This may involve creating a separate corrective Journal Entry for each detected manual posting, or a bulk Journal Entry for multiple postings, depending on the complexity and volume of detected postings.

Important: The cancellation of detected manual postings must always be tested first in a test environment. The results of the cancellation testing must be reviewed and approved by the company’s accountant. The same applies to the creation of corrective Journal Entries.

Prevention

To block a manual posting for an inventory account, access the Chart of Accounts window, choose an account and select the Block Manual Posting checkbox. For more information, refer to SAP Note 2228864.

Picture of Trần Văn Sơn

Trần Văn Sơn

Với 18+ năm kinh nghiệm và 50+ dự án thành công, tôi chuyên giải quyết bài toán quản trị từ gốc rễ quy trình và con người. Phương châm của tôi là hướng doanh nghiệp vận hành theo chuẩn SAP B1 toàn cầu, đảm bảo hệ thống vận hành đơn giản, hiệu quả ở hiện tại và dễ dàng nâng cấp, mở rộng trong tương lai.
Thảo luận và chia sẻ kinh nghiệm
Bạn có gặp tình huống tương tự khi sử dụng hệ thống SAP Business One?

Bài có liên quan theo chủ đề đang xem

3777838 – Enhanced “E-Mail” type activities

Symptom Here are the updates to the E-Mail type activities: New Send As options in E-Mail type activities and Send Message window New sending option of Microsoft Outlook New Activity of “Email” Type option in Sent Emails Report – Selection Criteria window Enhanced Emailed checkbox

Xem tiếp »
Scroll to Top