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 Posted
If Document.documentLine.variousText is set. And Document.documentAmount > 0. Asset Account Accrual from the related Various Text is used.
If Document.documentLine.variousText is set. And Document.documentAmount < 0. Liability Account Accrual from the related Various Text is used.
If Document.documentLine.portCostCode is set. And Document.documentAmount > 0. Asset Account Accrual from the related Port Cost Code is used.
If Document.documentLine.portCostCode is set. And Document.documentAmount < 0. Liability Account Accrual from the related Port Cost Code is used.
If Document.documentLine.handlingCostCode is set. And Document.documentAmount > 0. Asset Account Accrual from the related Handling Cost Code is used.
If Document.documentLine.handlingCostCode is set. And Document.documentAmount < 0. Liability Account Accrual from the related 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 related 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 related Account is used.
Accrual Reversed
If Document.documentLine.variousText is set. And Document.documentAmount < 0. Asset Account Accrual from the related Various Text is used.
If Document.documentLine.variousText is set. And Document.documentAmount > 0. Liability Account Accrual from the related Various Text is used.
If Document.documentLine.portCostCode is set. And Document.documentAmount < 0. Asset Account Accrual from the related Port Cost Code is used.
If Document.documentLine.portCostCode is set. And Document.documentAmount > 0. Liability Account Accrual from the related Port Cost Code is used.
If Document.documentLine.handlingCostCode is set. And Document.documentAmount < 0. Asset Account Accrual from the related Handling Cost Code is used.
If Document.documentLine.handlingCostCode is set. And Document.documentAmount > 0. Liability Account Accrual from the related 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 related 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 the related Account is used.
Bunker Adjustment Posted
If Document.documentAmount > 0. Asset Account Accrual from the related Account is used.
If Document.documentAmount < 0. Liability Account Accrual from the related Account is used.
Bunker Adjustment Reversal
If Document.documentAmount < 0. Asset Account Accrual from the related Account is used.
If Document.documentAmount > 0. Liability Account from the related 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 the related Various Text account is used.
If DocumentLine.portCostCode is set. Profit/ Loss Account from the related Port Cost Code account is used.
If DocumentLine.handlingCostCode is set. Profit/ Loss Account from the related Handling Cost Code account 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 the related Various Text account is used.
If DocumentLine.portCostCode is set. Accrual Profit/ Loss Account from the related Port Cost Code account is used.
If DocumentLine.handlingCostCode is set. Accrual Profit/ Loss Account from the related Handling Cost Code account 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.