cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Quantity update in accounting document.

Former Member
0 Kudos

What are settings required to update sales value as well as sales quantity in accounting document at the time of billing document generation in SD?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

a

Former Member
0 Kudos

Hi,

Normal this is updated automatically in FI. It is important that these fields are optional on the G/L account! Often all fields are optional and the g/l account is set as automatically posting only. When this not helps have a look to rules you se up for summarization. (SD create 5 lines but you create 1 line in FI)

Paul

Former Member
0 Kudos

Hi,

Go to SPRO>COPA>Flow of Actual Values>Transfer of Billing Documents>Assign Quantity Fields

Here map the SD Quantity fields to the COPA Quantity fields

The SD quantity fields which need to mapped to the COPA Quantity fields are:

FKLMG Billing qty in SKU

NTGEW Net weight

Map the above to the quantity fields you have created.

This will update the Sales quantity in the COPA document.

Reward points if useful.

Regards,

Rajaram

Former Member
0 Kudos

Thanks for the reply.This will show the sales quantity in COPA document.What if quantity needs to be displayed in accounting document.Please clarify

Thanks

Ragini Tiwari

Message was edited by:

Ragini Tiwari

former_member712491
Active Participant
0 Kudos

Dear Ragini,

Please find the FI-SD Integration as mentioned below:

FI-SD Integration: The integration is done in T-code VKOA

1. Sales Order Created

-No Entry-

2. PGI done (Goods issue)

Cost of Goods Sold Dr (Configured in OBYC GBB T-Key)

To Inventory Account

3. Billing document released to Accounting

Customer Account Dr.

To Sales Revenue Account (ERL T-key in Pricing procedure)

Note : The GL account is assigned to this ERL in VKOA

4. Payment Received

Bank Clearing A/c Dr

Customer A/c Cr.

Former Member
0 Kudos

Thanks for the answer but this way only sales value is getting updated.What is required to update sales quantity as well?