Balance

[Former Member]

Hi All,

What is the trial balance (TB) and how is the calculation of TB in SAP B1 ?

Suppose I have imported opening balance from old database to new database. The Opbal is as of 31.12.2007. Then I import TB from january - march 2008. Will the trial balance become error or incorrect if I compare to old database ?

Should I import the closed document and open document too ? The closed documents are the documents that relate to payment, inventory transactions and marketing document are either related to opening balance or not and they are created during the period january - march 2008. I still can't formulate or calculate if the result of importing will be error or not.

Please give advice. TIA

Rajh

[Former Member]

answered. Tks Suda

Rajh

[former_member583013]

Rajh,

Trial Balance is the Balance on a GL Account.

As we have been following this requirement. Importing the closed trasactions for 2008 might not really make sense. So I would suggest you important only the Open transaction (Un reconciled) AR AP etc.

Suda

[Former Member]

Tks lot for your answer. If in this case I import opening balance 2007 (as of 31.12.2007) then I import TB and open transaction only, will the TB become double calculation in the account balance ?

I mean how about the transaction that relates to the opening balance 2007 ?

I would summarize what I understand from your suggestion and pls tell me if it is wrong, as follows:

1. Import opbal 2007 (as of 31.12.2007). For the invoice, it is only for the open invoices that did not closed until april 2008 but created before 31.12.2007

2. Import all open transactions like SO, DO, PO, GRPO, Return and GRPO that created before 31.12.2007 and not closed until April 2004.

3. Import stock that is available until march 31, 2008

4. Import TB (consists of BS and PL) jan - march 2008

5. Import open transactions of documents that created in jan - march 2008 including open A/R and A/P that has not been closed until april 2008.

Pls give advice. TIA

Rajh

[former_member583013]

Rajh,

What you have described is exactly correct. But I would think that the GRPO and DO should have been invoiced in the old system and only the AR and AP total should be brought over.

bringing GRPO and DO can result in inventory issue as they are inventory transactions.

I am not sure if this can be done now or back dated to March but I would really think that GRPO and DO should be invoiced.

Suda

[Former Member]

Tks a lot for your answer.

The user still refuse to continue implementation of SAP B1 if open GRPO and DO excluded imported. If they have to import, then the stock available will be the sum of GRPO and DO and stock available until march 12/31/2008. Let me know if it is true or not. TIA

Rajh

[former_member583013]

If they want to have the GRPO and DO transactions for Jan - Mar then you need to bring the Inventory balance as of Jan 1 2008 and process every Inventory trasaction since then.

This also mean that you need to practically import every transaction for the Year 2008. This is going to be a bit challenging.

Suda

[Former Member]

Dear Suda,

Tks God. Tks a lot. The user is canceled this scenario. Your previous answers has been used by me to explain it to the management and they can accepted. This project started on November 2007 and until nw not finished.

However the new scenario is cut of until march 31, 2008. It means that I must prepare all opbals until 31.03.2008

I want to know how to retrieve all opbals in the old database.

The scenario I plan as follows:

A. A/R

1. Using the query you have given, I will retrieve all open invoices (it means the invoices that has been paid)

2. Import all JE transactions that use BP and not reconciled

3. Import all ARCM that not yet reconciled to the invoices

4. Import all incoming payment that not based on invoice and not yet reconciled.

B. A/P.

1. Using the query you have given, I will retrieve all open invoices (it means the invoices that has been paid)

2. Import all JE transactions that use BP and not reconciled

3. Import all ARCM that not yet reconciled to the invoices

4. Import all incoming payment that not based on invoice and not yet reconciled

C. GL Balance

D. Stock until march 31, 2008

I am also still confusing to use your query. Do I have to use paidsum or paidtodate ? if I use paidsum, the reconciled invoice with credit memo will be out of calculation.

For D, I am still confusing how to retrieve batch number of all available stocks until march 31, 2008. I have created properties batch for items and they have been marked in the old database on tab properties item master data.

Pls give advice if the steps above are correct and how to retrieve batch no. of items until march 31, 2008.

Rajh

[former_member583013]

Rajh,

Everything you have planned in Step A, B, C and D are correct. You are correct you should use PaidtoDate.

Let me know

Suda

[Former Member]

Tks a lot for your answer. I am still confusing how to retrieve all customer aging data. I mean the customer want that aging total in the new database must be as same as in the old database. I modified and run your query:

SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T0.[DocDate], t0.doccur, t0.docrate, T0.[DocTotal], T0.[PaidToDate], sum(t0.doctotal-t0.paidtodate) as 'Belum lunas (LC)', T0.[DocTotalFC], T0.[PaidFC], sum(t0.doctotalfc-t0.paidfc) as 'belum lunas (FC)' FROM OINV T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.[DocStatus] = N'O' and T0.[CardCode] between [%0] and [%1] and t0.docdate between [%2] and [%3]

group by

T0.[DocNum], T0.[CardCode], T0.[CardName], T0.[DocDate], T0.[DocTotal], T0.[PaidToDate], T0.[DocTotalFC], T0.[PaidFC], t0.doccur, t0.docrate

but when I compare to aging total result, it is not the same with the query result.

I've got the query result higher than aging total. I am afraid there are maybe some other unreconciled and open transactions that deal with the customer like JE, Payment on account or credit memo. I do not know what it is. Pls give advice how to retrieve them. TIA

Rajh