FICO - Raghav - Damodhier - 2017-08-14 - 43850 - Spec - ABAP - FICO Journal Entry Upload Program (Baiwa by 2017-12-30) #wipdoc

SPECIFICATIONS

43850-Spec-ABAP - FICO Journal Entry Upload Program

Purpose

FICO Journal entry upload program

Admin Info

Purpose	FICO Journal entry upload program
Requested By	Baiwa
Spec Created By	Raghav
Spec Created Date	08/14/2017
Spec QA by	Raghav
Objects	ZFI_GLUPLOAD ZGLUPLOAD
Document Status	WIP

Estimates

Sl.No	Activity	Estimation in Hours
1	Research	08
2	Documentation	06
3	Development/ Config	16
4	Unit test in DEV	10
5	Unit test in QUA	4
6	Other activity
	TOTAL	44

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

DOC-1775.pdf Sample JE upload with New Era Codes and Cross Company.csv

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.	Change Details	Requested By	Requested On	Notes if any
1

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

In my last two employers, we used a t-code called ZGLUPLOAD. This allowed entries to be made in a must faster way instead of copying and pasting 10 or 20 lines at a time, it would upload 999 lines at a time.

The GL Upload was done by building your JE in excel, saving as a csv and running the transaction code.

Even if this is not in place for the ADP PR process, I would like to explore this option as an easy way for accounting to gain some efficiency.

Attached is a sample excel upload file I've used in the past

The entries were limited to 999 lines at a time.

In Scope:

[List the activities to be included in scope]

Out of Scope:

[Out of scope activities]

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

Create new program for GL posting with the upload file format csv
Program Name:- ZFI_GLUPLOAD
Transaction: ZGLUPLOAD

Field	SAP Fields	Logic to post invoice from file
Company code	BKPF-BUKRS	upload the company code from file
Document Date	ACGL_HEAD-BLDAT	Give screen upload field
Currency	ACGL_HEAD-WAERS	Currency should be default do not change
Posting Date	ACGL_HEAD-BUDAT	Give screen upload field
Reference ID	ACGL_HEAD-XBLNR	Reference field should use the first line of item text field in the upload file
Doc.Header Text	ACGL_HEAD-BKTXT	Blank
Document type	ACGL_HEAD-BLART	Hardcode SA
GL Account	ACGL_ITEM-HKONT	GL account should be pulled from file field GL Account
Debit/Credit	ACGL_ITEM-SHKZG	If there is negative value then H else S
Amount	ACGL_ITEM-WRBTR	Get the value from upload file field Amount
Assignment	ACGL_ITEM-ZUONR	Get the value from upload file field Assignment
Item text	ACGL_ITEM-SGTXT	Item text field in the upload file
Company code	ACGL_ITEM-BUKRS	Get the value from upload file field Company code
Cost center	ACGL_ITEM-KOSTL	Pull cost center from file field Cost center
Profit center	ACGL_ITEM-PRCTR	Pull cost center from file field Profit center
Trading Partner	ACGL_ITEM-VBUND	Get the value from upload file field Trading partner
Order	ACGL_ITEM-AUFNR	Get the value from upload file field Internal order

Test Plan

[List test scenarios/cases to be executed here]

Date: 10/04/2017

Test ID	Test Scenario	Expected Results
FI-001	Journal posting for cocd 0010	All GL accounts given in csv file should post to journal entry item wise with the given document type SA from input file Header text, Document and posting date should pick from selection screen Cost object should assigned to GL account as given
FI-002	Journal posting with cross cocd for cocd0010 and 0011	All GL accounts given in csv file should post to journal entry item and cocd wise with the given document type SA from input file Header text, Document and posting date should pick from selection screen Cost object should assigned to GL account as given
FI-003	AP invoice postings for cocd0010	Accounts given in csv file should post to vendor invoice with the given document type KR from input file Header text, Document and posting date should pick from selection screen Cost object should assigned to GL account as given
FI-004	AP credit memo postings for cocd0010	Accounts given in csv file should post to vendor credit memo with the given document type KG from input file Header text, Document and posting date should pick from selection screen Cost object should assigned to GL account as given
FI-005	AR invoice postings for cocd0010	Accounts given in csv file should post to customer invoice with the given document type DR from input file Header text, Document and posting date should pick from selection screen Cost object should assigned to GL account as given
FI-006	AR credit memo postings for cocd0010	Accounts given in csv file should post to customer credit memo with the given document type DG from input file Header text, Document and posting date should pick from selection screen Cost object should assigned to GL account as given
FI-007	Negative testing with excess value for cocd0010	Journal entry should not post to accounting due to wrong calculation

Solution Details

[Provide complete technical details for configuration or programming here]

Issues

[List Issues / Bugs identified in configuration or development]