To post accounting document from Billing document.

[Former Member]

Hello Friends,

I need your help with regards to resolve below specified issue.

1) Due to some mishandling of delivery document , cumulative netweight and cumulative gross weight became negative. Delivery document was issued without any problem and invoice document was created and accounting document was released as well.

2) But negative values also transfeered to billing document. Fields at billing documents are net weight and gross weight.

These fields should not be negative as required.Because of this negative values at billing document ,it is not possible to open the invoice document as It throws dump.

3) There is a std report "WSLIPSKC" available already which can correct the negative values at delivery and report suggests to cancel the invoice and recreate it.

4) I have used the report. Delivery values were corrected. When i cancelled the invoice , system created cancelled invoice but that invoice still had negative values on it. But accounting document is not cleared because now the closed period ( last month). We cant open this cancelled invoice to change the posting date as it throws dump because of the negative values.

i cant open the last month period to post accounting document.

Please suggest  how can i post the accounting document now.

[Former Member · Accepted solution]

Hi manish

The only solution that occurs me is to directly change the net weight and gross weight in VBRP table using SE16 and “EDIT mode (I think that in VBRK there’s no weight fields) .

After that you should be able to change the posting date in billing documents and no dumps shoud occurs.

Note that this is a risky solution. If possible, you should test it first in a test environment.

Regards

[Former Member · Accepted solution]

Hello Jose,

Thanks for your response. I also think that this could be one solution.

But i am also concerned about it;s impact it FI-CO. Accounting document of normal invoice was cleared having negative values.

Do you think if this cancellation invoice is corrected by removing negative values and accounting document is relased, there would be any impact in FI-CO ?

Thanks in advance.

Regards

[former_member182708 · Accepted solution]

Hi Jose,

hi Manish,

this procedure is not recommended and should be carried out only be experts from SAP Development Support.

Direct manipulation of field values in tables can lead to severe inconsistencies, if done wrongly.

Afterwards it is impossible to find out the cause, because there is no change log for such an action.

Best regards,

Tobias

[Former Member · Accepted solution]

Hi manish,

In FI document the weight has no impact. But in CO, if you use the weight in any field of the CO document, it can have impact.

If you can, test all the process in a test environment.

Regard's

[Former Member · Accepted solution]

Hi Tobias, you are right.

These is a risky solution and should be taken with caution.

Regard's

[Former Member]

Hi Manish,

If I understand your problem correctly.. the issue is in the posting of accounting document for cancellation billing doc due to period closure.

To post this

1. Open the cancellation invoice

2. Change the billing date (header invoice ) to current period date.

3. Save the Invoice and check if the accounting doc is created

Regards,

Ram

[Former Member]

Hi,

Thanks for your response.

No, the issue is that i can't even open billing document due to negative values as mentioned above.Hence not able to change the posting date.

Regards

[former_member182708]

Hi manish kumar,

please check if the execution of correction report ZZCORBIL (from note 367296) for the affected billing document helps.

The negative values in the weight fields VBRP-NTGEW and VBRP-BRGEW will have to be changed to positive ones.

Best regards,

Tobias

[Former Member]

Hello Tobias,

Thanks , this is helpful.

But ,SAP note does not mention anything about FI-CO impact.

Do you think correction cancelled invoice and then clearing accounting document would have any impact in FI-CO?

Thanks in advance ,

Regards

[former_member182708]

Hi Manish,

the weight has no impact on FI or CO documents.

Go ahead and correct the negative values, afterwards you can view and release the cancellation invoice to accounting in VF02.

Best regards,

Tobias