Skip to Content
author's profile photo Former Member
Former Member

How SAP Business One handle Item Costing of back day documents

I have some questions about the the Item Costing in SAP Business One, hope someone can give me the solution.

I would like to know how SAP Business One handle the back day documents.

For example

Inventory Valuation Method: Moving Average

Originally, the inventory balance is zero, then

There is a GRPO on 27/05/2013 with 100PCS @ $10

27/05/2013 Create Delivery Note -10PCS@$10

Then I found that I forget to key in the Goods Receipt PO on 26/05/2013

and then I key in the GRPO with posting date 26/05/2013

26/05/2013 Create a Goods Receipt PO, with 50PCS@$12

Supposedly, I think on 26/05/2013 the Inventory Balance is

(100PCS * $10 + 50PCS * 12) / (100+50) = $10.67

Therefore, I think the Delivery Note needed to be has the COGS -10PCS @ $10.67

However, when the Delivery Note saved, the COGS has been recognized with -10PCS @ 10

Also, as I know, in the Inventory Audit Report, the selection criteria for the date has two options, 1. System Date, 2. Posting Date

If I used the Posting Date, the report will be like this

System Date Posting Date Qty Cost Cumulative Qty Cumulative Value

27/05/2013 26/05/2013 50 12 50 600

26/05/2013 27/05/2013 100 10 150 1600

26/05/2013 27/05/2013 -10 10 140 1500

Which is quite strange.

If I choose system date

System Date Posting Date Qty Cost Cumulative Qty Cumulative Value

26/05/2013 27/05/2013 100 10 100 1000

26/05/2013 27/05/2013 -10 10 90 900

27/05/2013 26/05/2013 50 12 140 1500

The question is, does SAP Business One has any module to handle this case? Thanks for answering.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Posted on May 27, 2013 at 05:51 AM

    Hi Eric Mak,

    Same data is tested in 8.81 PL 10. The results are,

    Posting date:

    By System date:

    Item cost under item master data- Inventory tab:

    So, there is no problem in date in report.

    Thanks & Regards,

    Nagarajan


    A1.JPG (45.2 kB)
    A2.JPG (46.1 kB)
    A3.JPG (47.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2013 at 06:11 AM

    Hi Eric Mak,

    The system behavior is correct. It will considered the price 10.00 in delivery note. But in journal entry it will take average cost of the item.

    Please check journal entry of above delivery note.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 28, 2013 at 10:30 AM

    Hi Eric,

    SBO is correct. What happened if you post entry in the past, system will update cost for issue? It's not logic.

    GLU

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2013 at 03:47 PM

    Hi,

    You may put your foot on the SAP shoe. All historical JE had be posted. That means there is no way to change existing posting. The logic has to be based on current on hand and value even for pre-dated transactions.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      But for my client's case, the procurement department and sales department cannot communicate as perfect as your suggestion. The sales department will not wait for the procurement department to enter the Goods Receit PO and then create the delivery. In that case the problem always exists and my client always complaint SAP business one. Does any of your client have this concern? Thanks very much.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2013 at 07:07 AM

    Hi, Eric Mak

    SAB B1 Post entry according to system date whatever may be posting date. Item Cost is calculated according to System Date.So, we have to post inventory entries in correct sequence (specially in case of moving average valuation method).

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 15, 2013 at 05:59 AM

    Hi,

    If it is a regular requirement to have back dated entries, then solution may be difficult. However if it is an occasional case, then can you not restore the SAP database at that point in time, then enter the GRPO document, and then import all the remaining transactions afterwards?

    Note: I am new to SBO, but coming from other ERP backgrounds, it should be possible.

    Hope this helps.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2014 at 09:05 AM

    The same issue i am also facing..! we are in process for implementing of SAP Business one. The opening inventory balances & Qty updated was wronge after anylysis we found some of the items unit price is more or lase as well quantiy. I tried by using issue & receipt voucher but the cost was considered todays average cost.

    We have alredy entred sales,purchases. but due to woronge inventory opening balances we can not match books such as Inventory & Cost of sales.

    Is there any way to correct? after correction the posted trancsaction balances should adjust accordingly.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.