Update912

Update F0912 G/L Date

Major Business Rule

Object Name: B0900061

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose

This function will update the G/L Date column in F0912 records for the Recurring Journal document 
found in the F0912 table.


Setup Notes and Prerequisites

Pass in the Document Type, Number, and Company of the Recurring Journal Entry you want update.  Also, 

pass the recurring frequency of the Recurring Journal Entry.  The function returns nothing, but will 

update all of the records associated with the specified document with the new G/L Date.


Technical Specification

Open F0912 table
Select records matching partial key of DCT, DOC, KCO

Fetch record from F0912 table

Call Update Recurring Frequency BSFN (B0900058)

While F0912 records exist

   Set new G/L Date in F0912 table

   Update record in F0912 table

   Fetch record from F0912 table

Close F0912 table

^

Data Structure

D0900061 - Update F0912 G/L Date

Parameter NameData ItemData TypeReq/OptI/O/Both
mnDocvoucherinvoiceeDOCMATH_NUMERICNONENONE

Special Input Expected
Pass in the Recurring Journal Entry's Document Number.

^

szDocumenttypeDCTcharNONENONE

Special Input Expected
Pass in the Recurring Journal Entry's Document Type.


^

szCompanyCOcharNONENONE

Special Input Expected
Pass in the Recurring Journal Entry's Document Company.


^

szFrequencyrecurringRFcharNONENONE

Special Input Expected
Pass in the Recurring Journal Entry's Reccuring frequency.  Valid values are:


"WK" - Weekly

"MO" - Monthly

"QT" - Quarterly

"SA" - Semi-annually

"AN" - Annually



^

Related Functions

B0900058 Recurring Frequency Update

Related Tables

F0912 Cost Allocations/Flex Budgeting