uk gl copa reconciliation issues
TRANSCRIPT
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 1/16
1) GL account 5081100 (Destroyed Merchandise/Scrapping) is mapped to COG
Oso!escence Sa!ea!e (""8#0) in CO$% ut this account is not updated in &' reporting
Reporting Head: COG Oso!escence Sa!ea!e
Action: GL account 5081100 shou!d update in &' reporting
Delta value in BI :
GL balance:
2) Flip Sign issue: %ccount 50811#5 is haing *Sign +or ,' direct postings- .here it is
sign +or i!!ing document ,!ip Sign is actie in custom ta!e
Reporting Head: COG others
,' direct postings +or GL account 50811#5- .hereas it is mapped to COG other (""1#0)in CO$%
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 2/16
Credit a!ance in ,' side !eads to sign in CO$% postings
Other COG other accounts are haing *signs +or deit postings ia i!!ing See e!o.
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 3/16
%ccount 508105 is mapped to COG Other (""1#) in CO$%- .hereas deit postings o+
this account a!so haing Sign +or &i!!ing postings
Action: 2ere issue .ith ,!ip sign is actie in custom ta!e +or ""1#0
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 4/16
) Retail Pro issue: 6003960 are having retail pro posting which arenot having any COPA postings.
Reporting Head: Gratis
%ccount #0034#0 is mapped to Gratis (""80) in CO$% ut no CO$% documentsgenerated to retai! pro postings
$ostings are happened to Cost center no postings in CO$%
%ccount #0034#1 (Gratis Manua!) is mapped to Gratis (""80) .hereas cost center had een used +or ,' direct postings and resu!t no CO$% postings
Action: O6&4 settings and $% trans+er structure needs to update +or Gratis
!) "rong assign#ent o$ %& to 'A structure: Cost e!ement 7010430 .as .rong!y
assigned to $rice%d*Damage D', * $% trans+er structure
%ccount 7010430 (9eturn Sa!ea!e) is .rong!y assigned to $% trans+er structure o+
$rice%d*Damage D',
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 5/16
,' direct postings o+ account 7010430- .hereas it posted to $r%d*Damage D', (""#30)
due to .rong $% trans+er structure assignment
%ction: ;o action is re<uired $% trans+er structure a!ready corrected
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 6/16
() =M outound de!iery postings +or Mtype 551 > 1#1 are not generated any
CO$% postings
Mtype 551
Mtype 1#1
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 7/16
Action: ;o action is re<uired- CO$% setup a!ready done
6) Wrong postings: COG others (508105! postings wronglyposte" to "isco#nts$allowances (%%600!.
COPA postings
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 8/16
&P'' con"ition "eriving G acco#nt 508105
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 9/16
Con"ition type &P'' is )appe" to %%985 val#e *iel" in COPA.
C#sto) ta+le as +elow is ro#ting %%985 to %%600(,isco#nt$Allowances! val#e *ile".
Action: 2ere asica!!y ""485 is mapped to COG others and Discounts/a!!o.ances
Current documents are +!o.ing correct!y
?g
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 10/16
%ccounting
CO$%
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 11/16
;o action is re<uired- as postings are +ine no.
) 'nentory 9ea!uation account 5057#00 is haing ,' direct postings- .hereas resu!t no
CO$% postings
Action: $% @rans+er Structure is a!ready there so O6&4 settings are re<uired or e!seuser has to +i!! the $% segment during postings
*) Sa!es %dustment (7010100) postings get posted to Gross Sis Sa!ea!e Manua!(""080)- due to .rong assignment in custom ta!e
%ccounting document
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 12/16
CO$% postings
Condition A01 is mapped to %ccount 7010100
=hereas it is assigned to a!ue +ie!d ""100
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 13/16
%nd it .as ,!ip sign actie in custom ta!e
Action: ;o action is re<uired since changes a!ready in done custom ta!e
+) No COPA Postings: 600550 (-o Charge erch/al! acco#nt is+eing #se" *or )an#al postings whereas no COPA postings. * Acco#nt#sage *ine then nee" O29 settings
Direct ,' postings .ith cost center .hereas no CO$% postings
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 14/16
Action: $% trans+er structure is a!ready there- i+ CO$% postings are re<uired O6&4
settings are re<uired
1,) Condition type A01 (100B ad Discrepanc) is mapped to ""100 (Sa!es
%dustments)- and custom ta!e is not haing any routing to routeDiscounts/%!!o.ances
Condition type A01 is deriing Discounts account 7010300
A01 is assigned to a!ue +ie!d (""100) Sa!es %dustment- and not routed to
Discounts/a!!o.ances a!ue +ie!d to get updated
Custom ta!e doesnt hae any routing +or ""100 to any other a!ue +ie!d See e!o.
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 15/16
Action: 2ere account 7010300 is .rong!y deried it seems- current setup is deriing
7010100 (Sa!es %d) account and CO$% postings are +ine
8/13/2019 UK GL COPA Reconciliation Issues
http://slidepdf.com/reader/full/uk-gl-copa-reconciliation-issues 16/16