Accounting Rules for AP - Accounts Payable
AP10: Manual entry of supplier invoices
When applied
Account entries are created when supplier invoices are manually recorded in 'Supplier Invoice. Record' (APS100).
References
See Manually Entering Supplier Invoices.
Accounting rules for AP10: Manual entry of supplier invoices
This table shows the accounting rules for manual entry of supplier invoices:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP10-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP10-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP10-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP10-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP10-200 |
C |
Accounts payable |
Represents the creditor's control account on which the invoice is automatically booked in the General Ledger. The account must be registered as an accounts payable account in 'Accounting Identity. Open' (CRS630). |
AP10-205 |
C |
Not paid letter of credit |
Used if the purchase order to which the invoice is matched is connected to a letter of credit in 'Letter of Credit. Connect Orders' (RMS101). An additional invoice with an invoice number equal to the letter of credit number is then created using this accounting rule. The account must be registered as an accounts payable account in (CRS630). |
AP10-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP10-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP10-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP10-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP10-215 |
D |
Clearing account for supplier invoices |
Represents the account that is debited automatically for debit invoices when using a detail record for FAM function AP10 for which alternative 1 or 2 is selected in the 'Clearing account code' field in 'FAM Function. Open Details' (CRS406). |
AP10-217 |
Self-assessment tax |
Represents the offsetting credit transaction for self-assessed Provincial Sales Tax in Canada created in (APS100). For details, see Canadian Sales Tax in M3. |
|
AP10-218 |
Offset account for base investment tax |
||
AP10-280 |
Rounding off |
||
AP10-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP10-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP10-396 |
D |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP20: Manually recorded supplier payments
When applied
Account entries are created when payments are manually recorded in 'Suppl Payment. Enter Manual' (APS120).
References
See Manual Payments.
Accounting rules for AP20: Manually recorded supplier payments
This table shows the accounting rules for manually recorded supplier payments:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP20-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP20-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP20-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP20-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP20-121 |
C |
Drafts without acceptance |
Used when recording payment by means of a draft without acceptance, that is, a draft that is printed by the supplier and confirmed afterward by the customer. The account in the first accounting dimension must be registered as an accounts payable account in 'Accounting Identity. Open' (CRS630). |
AP20-200 |
D |
Accounts payable |
Only used for on-account payments, that is, when selecting option 'On account' in (APS120/F). (For other payments, the account is retrieved from the original invoice instead.) |
AP20-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP20-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP20-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP20-214 |
C |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP20-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP20-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. Same as the description with AP20-301, but refers to the capital loss instead. |
AP20-340 |
D |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals sign in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP20-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP20-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP20-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP30: Supplier payments by check
When applied
Account entries are created when a payment proposal is confirmed in 'Suppl Payment Proposal. Open' (APS130), provided that the proposal includes invoices with a payment method that belongs to payment class 2 (Checks with direct allocation to invoice) in 'AP Payment Method. Open' (CRS071).
References
See Executing Supplier Payments Based on Payment Proposal.
See Pay by Check.
Accounting rules for AP30: Supplier payments by check
This table shows the accounting rules for supplier payments by check:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP30-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP30-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP30-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP30-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP30-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP30-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP30-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP30-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP30-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that is specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP30-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP30-340 |
C |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP30-380 |
Bank fees |
||
AP30-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP30-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP30-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP31: Supplier payments by EDI
When applied
Account entries are created for supplier invoices with a payment method that belongs to payment class 3 =(Bank transfer) and with transfer method 2 (EDIFACT payments) selected in 'AP Payment Method. Open' (CRS071) in these scenarios:
- You confirmed a payment proposal in 'Suppl Payment Proposal. Open' (APS130). The proposal includes invoices with alternative 0 = 'No bank confirmation' selected in the 'Bank confirmation' field for the payment method.
- You confirmed payments of invoices paid through EDI in 'Suppl Payment. Report Bank Confirmation' (APS190). Alternative 1 = 'Manual confirmation' or 2 = 'Automatic confirmation' is selected in the 'Bank confirmation' field for the payment method used.
References
See Executing Supplier Payments Based on Payment Proposal.
Accounting rules for AP31: Supplier payments by EDI
This table shows the accounting rules for supplier payments by EDI:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP31-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP31-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP31-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP31-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP31-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP31-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP31-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP31-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP31-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP31-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP31-340 |
C |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals sign in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP31-380 |
Bank fees |
Represents any fees charged by the bank for processing the payment. |
|
AP31-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP31-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP31-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP32: Supplier payments by manual bank transfer
When applied
As for AP31 except that transfer method 1 (Manual bank transfer) is selected for the payment method in (CRS071).
References
See Executing Supplier Payments Based on Payment Proposal.
See Pay by Manual Bank Transfer.
Accounting rules for AP32: Supplier payments by manual bank transfer
This table shows the accounting rules for supplier payments by manual bank transfer:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP32-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP32-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP32-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP32-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP32-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100), it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP32-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP32-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP32-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP32-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP32-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP32-340 |
C |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals sign in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP32-380 |
Bank fees |
Represents any fees charged by the bank for processing the payment. |
|
AP32-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP32-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP32-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP33: Supplier payments by draft
When applied
Account entries are created when a payment proposal is confirmed in 'Suppl Payment Proposal. Open' (APS130), which includes invoices with a payment method belonging to payment class 4 (Drafts) and alternative 0 = 'Draft records created at payment receive status 20' selected in the 'Draft confirmation' field in (CRS071).
References
See Executing Supplier Payments Based on Payment Proposal.
See Pay by Draft.
Accounting rules for AP33: Supplier payments by draft
This table shows the accounting rules for supplier payments by draft:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP33-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP33-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP33-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP33-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP33-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP33-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP33-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP33-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP33-295 |
C |
Accepted draft |
Used if the draft was issued by the purchasing company and therefore automatically accepted. |
AP33-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP33-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP33-340 |
C |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals sign in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP33-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP33-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP33-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP34: Confirmation of draft payment
When applied
Account entries are created when you confirm that supplier drafts have been collected by the bank in 'Draft. Reconcile Confirmations' (APS175).
The original invoices must have a payment method belonging to payment class 4 = Drafts and alternative 1 = 'Drafts receive status 20 at confirmation' selected in the 'Draft confirmation' field in (CRS071).
References
See Executing Supplier Payments Based on Payment Proposal.
See Pay by Draft.
Accounting rules for AP34: Confirmation of draft payment
This tables shows the accounting rules for confirmation of draft payment:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP34-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP34-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP34-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP34-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP34-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP34-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP34-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP34-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP34-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP34-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually specified VAT amount in local currency. |
AP34-340 |
C |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals sign in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP34-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP34-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP34-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP35: Supplier payments by direct debiting
When applied
Account entries are created when a payment proposal is confirmed in 'Suppl Payment Proposal. Open' (APS130), which includes invoices with a payment method belonging to payment class 5 (Direct debiting).
References
See Executing Supplier Payments Based on Payment Proposal.
Accounting rules for AP35: Supplier payments by direct debiting
This table shows the accounting rules for supplier payments by direct debiting:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP35-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP35-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP35-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP35-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP35-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP35-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP35-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP35-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP35-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP35-302 |
D |
Realized exchange rate loss |
Same as the description with AP35-301, but refers to the capital loss instead. |
AP35-340 |
C |
Cash discount granted |
Represents the cash discount that is automatically deducted when a payment is recorded within the cash discount limits. You can use the equals sign in all accounting dimensions in this accounting rule. By specifying =, the corresponding accounting ID in the accounting string of the invoice is retrieved instead of a fixed accounting identity. If there are split accounting lines from costs or revenues in the original invoice, the net cash discount amount is also split proportionally to the posted amounts in the invoice. |
AP35-390 |
D |
Claim on other division - centrally made payments |
Represents the clearing account when a payment is specified in one division on the behalf of another division. |
AP35-395 |
C |
Debt to other division - centrally made payments |
As above. |
AP35-396 |
C |
Withheld tax amount |
Represents the amount for withheld tax that is calculated based on the withholding percentage defined in 'Supplier Service Code. Open' (CRS063) when the user exits (APS100). A prerequisite is that tax withholding method 3 is selected for the supplier in 'Supplier. Define Purchase & Financial' (CRS624/F). See Reporting Supplier Tax. |
AP45 - Match credit request transactions to supplier invoice
When applied
Account entries are created when credit request transactions are matched to a supplier invoice in 'Credit Request Transactions. Match' (APS395) or when the credit request transactions are manually closed in 'Credit Request Transactions. Open' (APS390).
References
See Match Credit Request Transactions to Supplier Credit Note.
Accounting rules for AP45 – Offset credit request transactions
This table shows the accounting rules for offset credit request transactions:
Rule | D/C | Name | Description |
---|---|---|---|
AP45-215 | C | Clearing account for supplier invoices | Used when user posts the remaining amount to be distributed to clearing account in (APS395). |
AP45-245 | C | Credit request variance | Used when user selects option 'Check and Account' in (APS395) and the amount is within the defined tolerances in 'Settings – Supplier Invoice Matching' (APS900). |
AP45-246 | Credit request closing | Used when user selects option 'Complete credit request' or 'Reverse completion' in (APS390). | |
AP45-247 | C | Credit request write off | Used when user selects the option 'Write Off' in (APS395). |
AP45-280 | D | Rounding | |
AP45-301 | D | Realized exchange gains | Represents the currency gain when the foreign exchange rate changes between credit request transaction creation and credit request matching. |
AP45-302 | D | Realized exchange losses | Represents the currency loss when the foreign exchange rate changes between credit request transaction creation and credit request matching. |
AP46 - VAT accruals for Good Received Not Invoiced (GRNI)
When applied
Account entries are created when a proposal is confirmed for VAT accruals for not invoiced or partially invoiced goods receipt transactions in 'VAT Accruals Round. Create Proposal' (APS460).
References
See Reporting VAT for Goods Received/Not Invoiced.
Accounting rules for AP46 - VAT accruals for Good Received Not Invoiced (GRNI)
This table shows the accounting rules for VAT accruals for GRNI:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP46-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP46-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP46-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP46-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP46-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP46-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP46-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP46-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP46-222 |
Supplier - Goods received/not invoiced |
||
AP46-232 |
Charges - Goods received/not invoiced |
Represents an expense account for charges with any VAT excluded. |
|
AP46-959 |
Purchase - Goods received/not invoiced |
Represents an expense account of VAT account type 4 for the purchase without any charges and VAT. |
AP50: Automatically generated supplier invoices
When applied
Account entries are created when Accounts Payable is updated in 'Supplier Invoice Batch. Open' (APS450) with invoices belonging to one of the following invoice types: 0 (Invoices received via EDI), 13–19 (Self-billing invoices), and 20 (Invoices scanned using M3 Automatic Data Capture).
References
See Managing Batch Supplier Invoices.
Accounting rules for AP50: Automatically generated supplier invoices
This table shows the accounting rules for automatically generated supplier invoices:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP50-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP50-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP50-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP50-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP50-200 |
C |
Accounts payable |
Represents the creditor's control account on which the invoice is automatically booked in the General Ledger. The account must be registered as an accounts payable account in 'Accounting Identity. Open' (CRS630). |
AP50-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP50-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP50-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP50-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP50-215 |
D |
Clearing account for supplier invoices |
Represents the account that is debited automatically for debit invoices when you use a detail record for FAM function AP50, for which alternative 1 is selected in the 'Clearing account code' field in 'FAM Function. Open Details' in (CRS406). This accounting rule is also used for invoices that are matched to purchase orders or goods receipt but where the matching is not approved. |
AP50-218 |
D |
Accounting line for line type 8 |
Only used for supplier invoice lines and line type 8-'Accounting line'. For each line, the accounting string is retrieved and validated against the accounting rules and exceptions in 'Accounting rule. Set' (CRS395) using the normal process. The objects that can be used are accounting objects 1-7 and refer to the objects on the invoice lines with line type 8. The dynamic values of these objects are retrieved from the table FAPIBL (supplier invoice batch lines) in 'Supplier Invoice Batch. Open Lines' (APS451). Other accounting objects from supplier master and vendor information can also be used by accounting rule AP50/218. The accounting string can be manually changed in (APS451). When updating the invoice to AP, each accounting string from each line in (APS451) with line type 8 is used and updated to general ledger and moved to the table FRC040. |
AP50-230 |
D |
Charges on invoice header level |
Represents the account entry created for each invoice line of line type 2 (Order charge) in 'Supplier Invoice. Open Automatic Lines' (APS053). |
AP50-280 |
Rounding-off |
AP51: Debit notes
When applied
Account entries are created when accounts payable is updated with debit notes, that is, invoices belonging to invoice types 33–36, in 'Supplier Invoice Batch. Open' (APS450).
References
See Managing Batch Supplier Invoices.
Accounting rules for AP51: Debit notes
This table shows the accounting rules for debit notes:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP51-111 |
C |
VAT payable 1 |
Used when the 'VAT reported on payment day' check box is left cleared for the VAT code in 'VAT Code. Open'(CRS030). |
AP51-112 |
C |
VAT payable 2 |
Used when the 'VAT reported on payment day' check box is left cleared in combination with VAT method 2 or 3 in (CRS030). |
AP51-113 |
C |
Suspense account for VAT payable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP51-114 |
C |
Suspense account for VAT payable 2 |
Used when the 'VAT reported on payment day' is selected in combination with VAT method 2 or 3 in (CRS030). |
AP51-200 |
C |
Accounts payable |
Represents the creditor's control account on which the invoice is automatically booked in the General Ledger. The account must be registered as an accounts payable account in 'Accounting Identity. Open' (CRS630). |
AP51-211 |
D |
VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is left cleared in (CRS030). When used to record Canadian sales tax on purchases in 'Supplier Invoice. Record' (APS100) it represents the General Sales Tax (GST) or the Harmonized Sales Tax (HST). For details, see Canadian Sales Tax in M3. |
AP51-212 |
D |
VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). When used to record Canadian sales tax on purchases in (APS100) it represents the Provincial Sales Tax (PST) or Quebec Sales Tax (QST). If the PST is self-assessed by the company, an offsetting PST credit transaction is created based on accounting rule AP10-217. |
AP51-213 |
D |
Suspense account for VAT receivable 1 |
Used when the 'VAT reported on payment day' check box is selected in (CRS030). |
AP51-214 |
D |
Suspense account for VAT receivable 2 |
Used when the 'VAT reported on payment day' check box is selected in combination with VAT method 2 or 3 in (CRS030). |
AP51-215 |
D |
Clearing account for supplier invoice |
Represents the account that is debited automatically when the debit note is not approved for payment, that is, alternative 1 or 2 is selected in the 'Not approved for payment' field for FAM function AP51. This accounting rule is only used when an error occurs. |
AP51-237 |
C |
Debit note not invoiced - item |
Represents the offsetting accounting string to accounting rule PP20-237. Normally defined with the same accounting string as accounting rule PP20-237. |
AP51-238 |
C |
Debit note not invoiced - line charge |
Represents the offsetting accounting string to accounting rule PP20-238. Normally defined with the same accounting string as accounting rule PP20-238. |
AP51-280 |
Rounding-off |
AP65: Invoice split in accounts payable
When applied
Account entries are created when a supplier invoice is split by using option 'Invoice split' in 'Acc Payable. Display' (APS200/B).
Accounting rules for AP65: Invoice split in accounts payable
This table shows the accounting rules for invoice split in accounts payable:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP65-200 |
C |
Accounts payable |
Represents the creditor's control account on which the invoice is automatically booked in the General Ledger. The account must be registered as an accounts payable account in 'Accounting Identity. Open' (CRS630). |
AP65-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP65-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP72: Drafts without acceptance
When applied
Account entries are created when a draft without acceptance for a supplier invoice is recorded as collected in 'Draft without Acceptance. Open Payment' (APS380). This requires that the invoice has a payment method that belongs to payment class 4 (Drafts) and has alternative 2 selected in the 'Draft confirmation' field in 'AP Payment Method. Open' (CRS071).
References
Accounting rules for AP72: Drafts without acceptance
This table shows the accounting rules for drafts without acceptance:
Rule |
D/C |
Name |
Description |
---|---|---|---|
AP72-200 |
D |
Accounts payable |
|
AP72-295 |
C |
Drafts accepted |
|
AP72-301 |
C |
Realized exchange rate gain |
Represents the capital gain that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually entered VAT amount in local currency. |
AP72-302 |
D |
Realized exchange rate loss |
Represents the capital loss that arises when invoices that are specified in a foreign currency are settled using a different exchange rate. Used when the VAT amount in foreign currency calculated based on the invoice rate differs from the manually specify VAT amount in local currency. As above, but refers to the capital loss instead. |
AP91: Third currency adjustments AP
When applied
Account entries are created when 'Ex rt mgmt 3rd' is set to 1 or 2 in ‘Settings - General Ledger’ (CRS750) and when adjustments in the third currency are required.
Accounting rules for AP91: Third currency adjustments AP
Rule |
D/C |
Name | Description |
---|---|---|---|
AP91-304 | C | Realized exchange rate gains - third currency | Represents the capital gain that arises when invoices that are specified in a foreign currency, not equal to the third currency, are settled using a different third exchange rate. |
AP91-305 | D | Realized exchange rate loss - third currency | Represents the capital loss that arises when invoices that are specified in a foreign currency, not equal to the third currency, are settled using a different third exchange rate. |