Add markup value to cost conditon (VPRS) during PGI

[former_member266503]

Dear Friends,

I got a very strange requirement from the business i.e. add some markup % to cost condition "VPRS" then post final cost to COGS and Inventory during PGI.

VPRS is $100 and markup (ZTMP) 10%; Final Cost (ZPRS) is 110

Below is the background for this requirement.

Client is selling articles to customers through different e-com channels and each channel has dedicated DC to fulfill customer shipments.

Ex: Channel X has DC "X000", Channel Y has DC Y000"

Shipments will fulfill from DC "Y000" for channel "X" in two different scenarios. If we use intercompany process, cost difference can be handled through intercompany price but unfortunately intercompany process is not in scope. So business is asking to add markup % as shown in the above example to actual cost in DC Y000 to derive the final cost then post it to inventory and COGS accounts during PGI.

Option1). I have configured different condition types and maintained the routine to calculate final cost but it is not posting G/L because cost is fetching from article valuation segment during GI.

Option2).post markup % value to same inventory and COGS accounts as different entries than VPRS price. So business can see actual cost and markup value in the accounting document.

Kindly advise any enhancements or configuration options to accomplish above requirement. Your immediate response will be appreciated immensely

Regards,

Govind. A

[Prasoon]

Hi,

If you post the VPRS + Mark up to Inventory, the Inventory GL might become negative, right? I hope you need to explain the concept in more detail to the customer.

For example, VPRS = 100, Mark up = 10%, and the user expects 110 to be credited from the Inventory GL. If the stock quantity was 1, then the total stock value will be 100 before GI. Now, at the time of GI, if system post the VPRS+mark up to inventory GL, the stock account will be negative (100-110 = -10). Please check and revert!

Regards,

[former_member266503]

Hello Lakshmipathi,

Thanks for your response. Option is not working because cost is fetching from article valuation segment during PGI instead of the condition value.

COGS account will be determined based on OBYC config and COGS account will not determine if we assign account key in the SD pricing procedure. Kindly advise any other ideas 🙂

[Lakshmipathi]

On option-1, not sure, what exactly you tried and what was the issue but you can go with second option. Alternatively, you can have one more condition type with calculation type as % for which, set a new Account Key in pricing procedure. For this, new Account key, assign the required COGS G/L account. Now maintain condition record with the required markup % and try