GL Account

Owned by Karl-André Dalby
Last updated: Apr 07, 2021
3 min read

This is an explanation of the logic behind the two GL Account fields Document.glAccount and DocumentLine.glAccount.

When Account, Port Cost Code, Handling Cost Code, Various Text, VAT Code, Asset Account Accrual, Liability Account Accrual, Intercompany and Dataloy Property is mentioned in the below text it refers to General Master Data in VMS.

General Master Data can be found in Modules - Master Data - General Master Data.

 

GL Account on Document

Invoice In and Credit In

Account from the Accounts Payable Account is used.

 

Invoice Out and Credit Out

Account from the Accounts Receivable Account is used.

 

Bunker Transactions and Actuals

GL Account from the Account set on Document.account

 

Accrual Payable

If Document.documentLine.variousText is set. And Document.documentAmount > 0. Asset Account Accrual from Various Text is used.

If Document.documentLine.variousText is set. And Document.documentAmount < 0. Liability Account Accrual from Various Text is used.

If Document.documentLine.portCostCode is set. And Document.documentAmount > 0. Asset Account Accrual from Port Cost Code is used.

If Document.documentLine.portCostCode is set. And Document.documentAmount < 0. Liability Account Accrual from Port Cost Code is used.

If Document.documentLine.handlingCostCode is set. And Document.documentAmount > 0. Asset Account Accrual from Handling Cost Code is used.

If Document.documentLine.handlingCostCode is set. And Document.documentAmount < 0. Liability Account Accrual from Handling Cost Code is used.

If Document.documentLine.variousText is null and Document.documentLine.portCostCode is null and Document.documentLine.handlingCostCode is null. And Document.documentAmount > 0. Asset Account Accrual from the Document.documentLine.account is used.

If Document.documentLine.variousText is null and Document.documentLine.portCostCode is null and Document.documentLine.handlingCostCode is null. And Document.documentAmount < 0. Liability Account Accrual from the Document.documentLine.account is used.

 

Accrual Receivable

If Document.documentLine.variousText is set. And Document.documentAmount < 0. Asset Account Accrual from Various Text is used.

If Document.documentLine.variousText is set. And Document.documentAmount > 0. Liability Account Accrual from Various Text is used.

If Document.documentLine.portCostCode is set. And Document.documentAmount < 0. Asset Account Accrual from Port Cost Code is used.

If Document.documentLine.portCostCode is set. And Document.documentAmount > 0. Liability Account Accrual from Port Cost Code is used.

If Document.documentLine.handlingCostCode is set. And Document.documentAmount < 0. Asset Account Accrual from Handling Cost Code is used.

If Document.documentLine.handlingCostCode is set. And Document.documentAmount > 0. Liability Account Accrual from Handling Cost Code is used.

If Document.documentLine.variousText is null and Document.documentLine.portCostCode is null and Document.documentLine.handlingCostCode is null. And Document.documentAmount < 0. Asset Account Accrual from Document.documentLine.account is used.

If Document.documentLine.variousText is null and Document.documentLine.portCostCode is null and Document.documentLine.handlingCostCode is null. And Document.documentAmount > 0. Liability Account from Document.documentLine.account is used.

 

Bunker Adjustment Posted

If Document.documentAmount > 0. Asset Account Accrual from Document.documentLine.account is used.

If Document.documentAmount < 0. Liability Account Accrual from Document.documentLine.account is used.

 

Bunker Adjustment Reversal

If Document.documentAmount < 0. Asset Account Accrual from Document.documentLine.account is used.

If Document.documentAmount > 0. Liability Account from Document.documentLine.account is used.

 

 

 

GL Account on DocumentLine

Invoice In, Credit In, Invoice Out and Credit Out

If DocumentLine.variousText is set. Profit/ Loss Account from Various Text is used.

If DocumentLine.portCostCode is set. Profit/ Loss Account from Port Cost Code is used.

If DocumentLine.handlingCostCode is set. Profit/ Loss Account from Handling Cost Code is used.

If DocumentLine.variousText is null DocumentLine.portCostCode is null and DocumentLine.handlingCostCode is null. Profit / Loss Account from DocumentLine.account is used.

 

VAT Payable and VAT Deductible

If DocumentLine is VAT, mean DocumentLine.account is VAT Payable or VAT Deductible. VAT GL Account from the connected VAT Code is used.

 

Bunker Transactions and Actuals

Account from the Account set on DocumentLine.account

 

Accrual Posted, Accrual Reversed, Bunker Adjustment Posted and Bunker Adjustment Reversal

If DocumentLine.variousText is set. Accrual Profit/ Loss Account from Various Text is used.

If DocumentLine.portCostCode is set. Accrual Profit/ Loss Account from Port Cost Code is used.

If DocumentLine.handlingCostCode is set. Accrual Profit/ Loss Account from Handling Cost Code is used.

If DocumentLine.variousText is null DocumentLine.portCostCode is null and DocumentLine.handlingCostCode is null. Accrual Profit/ Loss Account from DocumentLine.account is used.

 

Commission deducted from hire payable

If DocumentLine is a commission that credits charterer and it is accounts payable and the Dataloy Property com.dataloy.invoicing.ap.commission is false. If Account on the Accounts Payable Account is set, then this Account is used. If Accounts Payable Account is not set then Business Partner Code from the broker connected commission is used.

 

Co-broker commission

If DocumentLine.account is Commission Receivable and the broker is Intercompany and its accounts receivable. Account from the Accounts Payable Account is used.