SAP for Retail Blogs
Gain insights and practical tips to captivate customers, optimize your supply chain, and drive growth with SAP for Retail software. Share your own insights!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

This Document gives the details on what basis would the G/L Account Document entries be when the Material Document and Billing  Document gets created on successful posting of WPUUMS Idoc.

Posting of sales data using WPUUMS is an example of aggregated sales.

In SPRO --> Sales and Distribution --> POS Interface --> Inbound --> Aggregated Sales Control------- POS Inbound profile is defined.

This has details of :

  • Mov Type: Sale (251)
  • Mov Type: Return (252)

In the Site Master in the POS tab the POS Inbound profile woud be maintained.

Assume WPUUMS has sales data of Store XXXX for an Article 'ABCDE' along with quantity details.

(Segment E1WPU02 VORZMENGE field would have '-' in case of sales).

If configurations are made in POSDM in task 0014 as 'aggregation of material with conditions' then segment E1WPU05 of WPUUMS  would contain details of Tax, discount also.

When Posting of WPUUMS takes place two documents would be posted:

  • Article Document
  • Billing Document

Article Document

Article document posting would be for movement type '251' GI for Sales.

The Cost Center and Profit Center mentioned there would be picked up based on the following:

In Article Master of ABCDE in 'Logistics: Store' view would have 'Other Logistics Data' at the bottom, which would have details  of Profit Center,

And each of the Profit center would be associated with Cost center in T-Code OKB9 for relevant Cost elements for a company  Code.

The GL account document would have details based on:

Automatic Posting Defined for Keys BSX (Inventory Posting) and  GBB (offsetting Entry for inventory Posting)

[SPRO --> Materials Management --> Valuation and Account Assignment --> Account Determination --> Account Determination without Wizard --> Configure Automatic Postings]

Material Master of ABCDE in 'Logistics: Store' view would have 'Accounting' at the bottom, which would have a Valuation Class.

In Automatic Posting for BSX , this Valuation class would be linked to a GL Account (Credit entry Posting {99}-Sales {251} & Debit entry Posting{89}-Returns{252} )

(Rule: Debit what comes in and Credit what goes out)

This would be one side of the Posting.

And on the other side based on the GL account linked to GBB through General Modifier assigned to Movement type 251/252 the other side of the posting would take place.

Cost center would be based on the logic mentioned above for each of the two cost elements (GL Accounts)

Billing Document

In billing document the Net Value would be the sales value (inclusive of Tax net of discount) and Cost would be picked from Moving Average price of the article.

In the accounting Document linked to Billing Document:

One side would be Debit entry against the Customer(Recon Account Defined) for the Store in case of a sale.

And balancing entry would be based on the Account assignment Group Mentioned in the Article master in 'Other Sales Data' in 'Sales' view.

This Account Assignment Group would be linked to a GL Account in T-Code VKOA.

In case the IDOC also has details of Tax then based on the Pricing Procedure(Calculation Schema) defined for Inbound profile, The condition type for Tax can be linked to an Account Key and then this account key can be linked to a GL account by T-code VKOA.

In this way the GL accounts would be determined when WPUUMS Idoc is posted.

2 Comments