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 : APX - from the Accounts Payable Account is used.
Invoice Out and Credit Out
Account : ARX - 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 is a various cost/revenue, meaning DocumentLine.variousText is set. And Document.documentAmount > 0. Asset Account Accrual from the related Various Text is used.
If Document.documentLine is a various cost/revenue, meaning DocumentLine.variousText is set. And Document.documentAmount < 0. Liability Account Accrual from the related Various Text is used.
If Document.documentLine is a port cost, meaning DocumentLine.portCostCode is set. And Document.documentAmount > 0. Asset Account Accrual from the related Port Cost Code is used.
If Document.documentLine is a port cost, meaning DocumentLine.portCostCode is set. And Document.documentAmount < 0. Liability Account Accrual from the related Port Cost Code is used.
If Document.documentLine is a handling cost, meaning DocumentLine.handlingCostCode is set. And Document.documentAmount > 0. Asset Account Accrual from the related Handling Cost Code is used.
If Document.documentLine is a handling cost, meaning 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 is not a various, port cost or handling cost.portCostCode is null and Document.documentLine.handlingCostCode is null. And Document.documentAmount > 0. Asset Account Accrual from the related Account Document.documentLine.account is used.
If Document.documentLine is not a various, port cost or handling cost.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 Document.documentLine.account is used.
Accrual
...
Receivable
If Document.documentLine is a various cost/revenue, meaning DocumentLine.variousText is set. And Document.documentAmount < 0. Asset Account Accrual from the related Various Text is used.
If Document.documentLine is a various cost/revenue, meaning DocumentLine.variousText is set. And Document.documentAmount > 0. Liability Account Accrual from the related Various Text is used.
If Document.documentLine is a port cost, meaning DocumentLine.portCostCode is set. And Document.documentAmount < 0. Asset Account Accrual from the related Port Cost Code is used.
If Document.documentLine is a port cost, meaning DocumentLine.portCostCode is set. And Document.documentAmount > 0. Liability Account Accrual from the related Port Cost Code is used.
If Document.documentLine is a handling cost, meaning DocumentLine.handlingCostCode is set. And Document.documentAmount < 0. Asset Account Accrual from the related Handling Cost Code is used.
If Document.documentLine is a handling cost, meaning 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 is not a various, port cost or handling cost.handlingCostCode is null. And Document.documentAmount < 0. Asset Account Accrual from the related Account Document.documentLine.account is used.
If Document.documentLine is not a various, port cost or handling cost.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 Document.documentLine.account is used.
Bunker Adjustment Posted
If Document.documentAmount > 0. Asset Account Accrual from the related Account Document.documentLine.account is used.
If Document.documentAmount < 0. Liability Account Accrual from the related Account Document.documentLine.account is used.
Bunker Adjustment Reversal
If Document.documentAmount < 0. Asset Account Accrual from the related Account Document.documentLine.account is used.
If Document.documentAmount > 0. Liability Account from the related Account Document.documentLine.account is used.
GL Account on DocumentLine
Invoice In, Credit In, Invoice Out and Credit Out
If DocumentLine is a various cost/revenue, meaning DocumentLine.variousText is set. Profit/ Loss Account from the related Various Text account is used.
If DocumentLine is a port cost, meaning DocumentLine.portCostCode is set. Profit/ Loss Account from the related Port Cost Code account is used.
If DocumentLine is a handling cost, meaning DocumentLine.handlingCostCode is set. Profit/ Loss Account from the related Handling Cost Code account is used.
If none of the above is set then Account form DocumentLine.variousText is null DocumentLine.portCostCode is null and DocumentLine.handlingCostCode is null. Profit / Loss Account from DocumentLine.account is used.
...
Accrual Posted, Accrual Reversed, Bunker Adjustment Posted and Bunker Adjustment Reversal
If DocumentLine is a various cost/revenue, meaning DocumentLine.variousText is set. Accrual Profit/ Loss Account from the related Various Text account is used.
If DocumentLine is a port cost, meaning DocumentLine.portCostCode is set. Accrual Profit/ Loss Account from the related Port Cost Code account is used.
If DocumentLine is a handling cost, meaning DocumentLine.handlingCostCode is set. Accrual Profit/ Loss Account from the related 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.