Navigation:  Voyage Accounting > FDA Program > FDA - General points

 

 

General Points:

 

 

1.Charge Category = Carrier Disbursement charges should be identified based on the voyage and Principle selected from the T_ID_SHIP_LEDGER . SHL_CHARGE_KEY.

2.Documents which are matched with the above condition will be considered first. Then for the header filter parameter, SHL_FDA_KEY should not be updated which means FDA should not have been created for the documents fetched.

3.Once the Fetch button is selected, all the respective details to be fetched in the Grid.

4.All the voyages to be fetched. User can create FDA based on the voyage selection which is provided in the left side. Entire voyages can also be selected. Voyages to be fetched from T_ID_VOYAGE_MASTER.

5.If multiple voyages are selected, then FDA to be generated each voyage wise and document number to be generated in the grid once the “Post” button is selected.

6.Selected Local Amount and VAT amount to be fetched based on the invoice documents selected from Details grid. By default, all the invoice documents for the particular voyage should be auto selected so that total amount will be displayed. This field will dynamically change based on the invoice documents selected for creating FDA.

 

Selected Local Amount        - T_ID_SHIP_LEDGER . SHL_LOCAL_AMOUNT

VAT amount                        - T_ID_SHIP_LEDGER .  SHL_TOTAL_TAX_AMOUNT

 

7.Manual selection from the master is allowed in all other columns in the grid.

8.System date will be fetched as the Doc Date.

9.Below validations to be checked for Doc Date.

•DEFAULT SYSTEM DATE

•FUTURE DATE SHOULD NOT BE ACCEPTED

•BACK DATED CAN BE ACCEPTED, BUT PERIODS SHOULD BE OPENED FOR THE PARTICULAR DATE

•PERIOD CHECK

FOR CUSTOMER INVOICE        -> PASS THE SUBLEDGER AS  'AR' AND 'GL'

FOR SUPPLER INVOICE        -> PASS THE SUBLEDGER AS  'AP' AND 'GL'

FOR RECEIPT/PAYMENTS        -> PASS THE SUBLEDGER AS  'BANK', 'CB' AND 'GL'

 

i.VALIDATE THE SUBLEDGER MASTER WITH THE SUBLEDGER PERIODS BY "PASSING THE SUBLEDGER CODE AND DOC DATE" AS PARAMETER

ii.SELECT SUBPRD_STATUS from t_ID_SUB_LEDGER_PERIODS WHERE SUBPRD_PERIOD_TYPE = 'F'

 AND SUBPRD_SUB_LEDGER_KEY  IN (SELECT SLEDGER_KEY FROM T_ID_SUB_LEDGER_MASTER WHERE SLEDGER_CODE IN ('AR','AP','BANK','GL'))

 AND 'DOC_DATE' BETWEEN  TO_DATE(SUBPRD_FROM_DATE) AND TO_DATE(SUBPRD_TO_DATE) + 1

 AND SUBPRD_MODE = 'N'

IF SUBPRD_STATUS != 'O' THEN RAISE A MESSAGE AS 'Financial period is not opened or closed for the given document date'

Else proceed with the user entry.

 

10.Document number will be generated each voyage-wise.

11.After selection of invoices, and tax calculation done, Total Local and Foreign amount will be fetched automatically at the lower grid based on the documents selected for a particular voyage.