Exporting to other finance systems - Revision history

Priyanka: /* Troubleshooting error message "0 Invoices generated" */

2013-07-09T12:23:20Z

Troubleshooting error message "0 Invoices generated"

← Older revision		Revision as of 12:23, 9 July 2013
Line 107:		Line 107:
	'DOLPHSUP'		'DOLPHSUP'

	== Troubleshooting ~~error message "0 Invoices generated"~~ ==		== Troubleshooting invoices missing from batch ==

	No approved invoices available to interface. Error message :- 0 Invoices generated		No approved invoices available to interface. Error message :- 0 Invoices generated
Line 113:		Line 113:
	[[image:0_Invoices_generated.jpg]]		[[image:0_Invoices_generated.jpg]]

	If an invoice ~~does not appear in~~ a batch check the following :-		If an invoice is missing from a batch check the following :-

	#Check if the invoice is approved in list of invoices.		#Check if the invoice is approved in list of invoices.

2013-07-09T07:35:55Z

Approved invoices missing from batch

← Older revision		Revision as of 07:35, 9 July 2013
Line 107:		Line 107:
	'DOLPHSUP'		'DOLPHSUP'

	== ~~Approved invoices missing from batch~~ ==		== Troubleshooting error message "0 Invoices generated" ==

	No approved invoices available to interface.		No approved invoices available to interface. Error message :- 0 Invoices generated

	[[image:0_Invoices_generated.jpg]]		[[image:0_Invoices_generated.jpg]]

2013-07-08T13:08:58Z

Approved invoices not appearing in batch

← Older revision		Revision as of 13:08, 8 July 2013
Line 107:		Line 107:
	'DOLPHSUP'		'DOLPHSUP'

	== Approved invoices ~~not appearing in~~ batch ==		== Approved invoices missing from batch ==

	No approved invoices available to interface.		No approved invoices available to interface.

2013-07-04T13:28:15Z

0 Invoices generated

← Older revision		Revision as of 13:28, 4 July 2013
Line 107:		Line 107:
	'DOLPHSUP'		'DOLPHSUP'

	== ~~0 Invoices generated~~ ==		== Approved invoices not appearing in batch ==

	No approved invoices available to interface.		No approved invoices available to interface.

2013-07-04T12:04:18Z

0 Invoices generated

← Older revision		Revision as of 12:04, 4 July 2013
Line 113:		Line 113:
	[[image:0_Invoices_generated.jpg]]		[[image:0_Invoices_generated.jpg]]

	If an invoice does not appear in a batch check the ~~followoing~~ :-		If an invoice does not appear in a batch check the following :-

	#Check if the invoice is approved in list of invoices.		#Check if the invoice is approved in list of invoices.

2013-07-04T12:00:39Z

← Older revision		Revision as of 12:00, 4 July 2013
Line 106:		Line 106:
	'DOLPHAUX'		'DOLPHAUX'
	'DOLPHSUP'		'DOLPHSUP'

			== 0 Invoices generated ==

			No approved invoices available to interface.

			[[image:0_Invoices_generated.jpg]]

			If an invoice does not appear in a batch check the followoing :-

			#Check if the invoice is approved in list of invoices.
			#Check if the invoice was captured by previous batches.
			#Check the date of invoice, the 4th day of the month will include all current calendar month documents i.e. documents from 1st to 3rd.The actual day of month might change. If in doubt check with NEOSYS programmers.
			#Check if the alias codes are entered in client & brand file and in supplier file although this will probably abort the interface with an explanatory message.

2012-05-28T16:08:35Z

Exporting XML Files using Finance Interface

@@ Line 26: / Line 26: @@
 === Exporting XML Files using Finance Interface ===
 ==== Generation of XML files ====
@@ Line 48: / Line 53: @@
 #The Crosstab section allows you to add additional rows of the information you want to display.
 #In the Crosstab columns section it is best to select A/c No to get a good overview of the figures and likewise it is best to select Both for Dr/Cr.
 ==== Procedure to generate Invoice XML file ====
@@ Line 69: / Line 64: @@
 #To get a pivot table of the same for the Invoices XML file, you can use the following options – however you can select more rows from the options shown: <br> [[image:Pivot Invoice.jpg]] <br> After clicking on generate you will get a report similar to this: <br> [[image:Media Finance Reconciliation Invoice.jpg]] <br>
 #After confirmation from SAP IT that the file has been interfaced and you have confirmed the figures, you need to sign off the Invoices XML file generated so that the system can generate the next output: <br> [[image:Invoices Sign.jpg]] <br>
 == Closing of the book month ==

2012-02-27T07:35:09Z

← Older revision		Revision as of 07:35, 27 February 2012
Line 80:		Line 80:

	[[Image:companyfileperiod.jpg]]		[[Image:companyfileperiod.jpg]]

			== Alias Keys ==
			===Unilever===

			cliententityaliaskey='ENTITY'
			clientsoaliaskey='SO'
			brandaliaskey='CPG'
			vehiclealiaskey='AP'
			supplieraliaskey='SUPPLIER'
			districtaliaskey='DISTRICT'
			marketaliaskey='MARKET'

			===Dolphin===
			These keys aren’t required for SAP interface but they need to be added for any records related to Magna otherwise the Dolphin interface will fail.

			'DOLPBILL'
			'DOLPCOST'
			'DOLPHCL1'
			'DOLPHCL2'
			'DOLPHAUX'
			'DOLPHSUP'

2012-02-26T08:19:12Z

Exporting using XML files

← Older revision		Revision as of 08:19, 26 February 2012
Line 9:		Line 9:
	#Reversals of all ads for which provisions were created in the prior batch		#Reversals of all ads for which provisions were created in the prior batch
	#Re-entry of provisions for ads from the beginning of the current year until the last day of the prior month (eg. if the batch was run on 25th June, the provisions will be created for the period 1-Jan until 31-May)		#Re-entry of provisions for ads from the beginning of the current year until the last day of the prior month (eg. if the batch was run on 25th June, the provisions will be created for the period 1-Jan until 31-May)

	~~''' Each ad will have 2 lines and a sample entry is as follows: '''~~

	P&L Provision Expense A/c (38131099) (40) DR		P&L Provision Expense A/c (38131099) (40) DR
Line 21:		Line 19:

	The invoice amounts only appears if the invoice is issued and approved for posting in the "Approval Date field" under Old Invoice Printouts.		The invoice amounts only appears if the invoice is issued and approved for posting in the "Approval Date field" under Old Invoice Printouts.

	~~'''Each ad will have a total of 2 lines and a sample entry will be as follows:'''~~

	P&L Actual Expense A/c (38101001) (40) DR		P&L Actual Expense A/c (38101001) (40) DR

2012-01-25T06:42:26Z

Closing of the book month

← Older revision		Revision as of 06:42, 25 January 2012
Line 78:		Line 78:
	After running the XML files and signing them off, you may decide to restrict the media operations from amending any schedules or bookings. This can be done by specifying the latest closed period in the Company File (Menu > Finance > Companies) and select the relevant company.		After running the XML files and signing them off, you may decide to restrict the media operations from amending any schedules or bookings. This can be done by specifying the latest closed period in the Company File (Menu > Finance > Companies) and select the relevant company.

	#Specifying the closed period - finance will block users to issue invoices or any finance documents.		#Specifying the closed period - finance will block users to issue invoices or any finance documents
	#Specifying the closed period - operations will block users to amend / edit / create schedule and/or any document in the media system		#Specifying the closed period - operations will block users to amend / edit / create schedule and/or any document in the media system

			Specifying 6/2011 ensures that no users can do any changes in either finance or operations (which ever is selected) for June 2012 and any period before it (Year to date)

	[[Image:companyfileperiod.jpg]]		[[Image:companyfileperiod.jpg]]