Question

Entity Posting Control

  • 19 May 2023
  • 1 reply
  • 51 views

Userlevel 2
Badge +6

HI

 

I have a client who wants code part: Entity, to automatically post in the GL column when an order is invoiced, a PO is paid, when inventory has been received for Intercompany customers/suppliers. 

We have a pre-posting on the customer order and purchase order, so that a person will entry the Entity in pre-posting. 

The client does not want to do this. They want it to automatically populate when the intercompany customer or supplier is used. 

 

Client solution: The one below is not working. 

They have a posting control IP2, with Code part Entity with IC2 type.  Inside the details, the intercompany group have detail specifications on customer group using AC4: country code.

 

 

Has anyone come across this situation?


1 reply

Userlevel 6
Badge +19

Hi @CorBarbaL 

This needs kind of light modification with event action. You can see in the community similar topics. But basically the idea is whenever a CO or PO is created with a certain supplier or customer then you will run an action to modify CO preposting.

Create a custom event based on your required parameters. After saving the event, create new action for this event with event type Execute Online SQL.

Build your query with variables like in posting control. You can copy the procedure of preposting creation from debug console and build your sql for the event. Once you are ready you can enable the event. It should work as you expected.

 

I recommend doing all these things first in a non-PROD environment. Once you are satisfied then move to PROD.

Hope this helps

 

Reply